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

Reply via email to