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); } }