Why hibernated does not create tables automatically?
zhmt via Digitalmars-d-learn
digitalmars-d-learn at puremagic.com
Thu Feb 12 19:22:29 PST 2015
here is how to use:
@UniqueIndex("id",["id"])
class Card
{
@NotNull()
@Auto()
long id;
string pwd;
long agentId;
bool valid;
long rmb;
long createDate;
long soldDate;
long chargeDate;
}
public Card[] getAllCards(long page,long pageSize)
{
Connection conn = mdb.lockConnection();
scope(exit) conn.close();
string sql = "select * from Card";
Card[] ret = MysqlOrmUtil.exeQueryToObjArr!Card(sql,conn);
return ret;
}
public void createCards(long agentId,long rmb,long count)
{
long curTime = now();
Connection conn = mdb.lockConnection();
scope(exit) conn.close();
for(int i=0; i<count; i++)
{
Card card = new Card();
card.agentId = agentId;
card.createDate = curTime;
card.pwd = createCardPwd();
card.rmb = rmb;
card.valid = true;
string sql = MysqlOrmUtil.genInsertSqlWithoutId("id",card);
MysqlOrmUtil.exeSql(sql,conn);
}
}
More information about the Digitalmars-d-learn
mailing list