private String getModeByCode(int code) { String res; DaoSession daoSession = new DaoSession(); daoSession.openConnection(); MySqlDataReader modeDataReader = daoSession.executeQuery( "SELECT name FROM MODE WHERE code = " + code); if (modeDataReader == null || !modeDataReader.HasRows) return null; modeDataReader.Read(); res = modeDataReader.GetString("name"); daoSession.closeConnection(); return res; }
public int getLastVideoCode() { int lastCode = 0; DaoSession daoSession = new DaoSession(); daoSession.openConnection(); MySqlDataReader dataReader = daoSession.executeQuery("SHOW TABLE STATUS LIKE 'SESSION'"); if (dataReader != null && dataReader.HasRows) { dataReader.Read(); lastCode = dataReader.GetInt16("auto_increment") - 1; } daoSession.closeConnection(); return lastCode; }