public void update() {
if (SpyMemCacheClient.getInstance().IsConnected())
SpyMemCacheClient.getInstance()
.delete(String.format(UserAccount.key_UserAccountByUserID, this.user_id));
String query =
String.format(
UserSQL.sqlUpdateUserAccount,
this.chips,
this.gold,
this.experience,
this.level,
this.lastlogin,
this.invitebonus,
this.id);
System.out.println(query);
Connection conn;
try {
conn = PoolFactory.getPooling().getConnection();
Statement stm = conn.createStatement();
stm.executeUpdate(query);
conn.close();
} catch (SQLException e) {
System.out.println("SQL Exception Code : " + e.getErrorCode());
System.out.println("SQL Exception Message : " + e.getLocalizedMessage());
e.printStackTrace();
}
}
public static UserAccount getUserAccountbyUserID(long userid) {
UserAccount useraccount = null;
if (SpyMemCacheClient.getInstance().IsConnected())
useraccount =
(UserAccount)
SpyMemCacheClient.getInstance()
.get(String.format(UserAccount.key_UserAccountByUserID, userid));
if (useraccount == null) {
String query = String.format(UserSQL.sqlGetUserAccountByUserID, userid);
System.out.println("User Acc Query : " + query);
try {
ResultSetHandler<UserAccount> h = new BeanHandler<UserAccount>(UserAccount.class);
Connection conn = PoolFactory.getPooling().getConnection();
QueryRunner run = new QueryRunner();
useraccount = run.query(conn, query, h);
System.out.println("User Account Details : " + useraccount.toString());
conn.close();
// System.out.println(useraccount.toString());
return useraccount;
} catch (SQLException e) {
e.printStackTrace();
}
} else {
System.out.println("Mem Cache used");
}
return useraccount;
}
/**
* DB Access methods
*
* @param chips
* @param gold
* @param experience
* @param level
* @param lastlogin
* @param invitebonus
* @param user_id
*/
public UserAccount(
int chips,
int gold,
int experience,
int level,
String lastlogin,
int invitebonus,
long user_id) {
this.chips = chips;
this.gold = gold;
this.experience = experience;
this.level = level;
this.lastlogin = lastlogin;
this.invitebonus = invitebonus;
this.user_id = user_id;
String query =
String.format(
UserSQL.sqlCreateUserAccount,
this.chips,
this.gold,
this.experience,
this.level,
this.lastlogin,
this.invitebonus,
this.user_id);
System.out.println(query);
Connection conn;
try {
conn = PoolFactory.getPooling().getConnection();
String autogenColumns[] = {"id"};
Statement stm = conn.createStatement();
stm.executeUpdate(query, autogenColumns);
ResultSet result_set = stm.getGeneratedKeys();
if (result_set.first()) {
this.id = result_set.getInt("id");
if (SpyMemCacheClient.getInstance().IsConnected())
SpyMemCacheClient.getInstance()
.add(String.format(UserAccount.key_UserAccountByUserID, this.user_id), this);
}
conn.close();
} catch (SQLException e) {
System.out.println("SQL Exception Code : " + e.getErrorCode());
System.out.println("SQL Exception Message : " + e.getLocalizedMessage());
e.printStackTrace();
}
}
public UserAccount(long user_id) {
this.user_id = user_id;
String query = String.format(UserSQL.sqlCreateUserAccountDefault, this.user_id);
Connection conn;
try {
conn = PoolFactory.getPooling().getConnection();
String autogenColumns[] = {"id"};
Statement stm = conn.createStatement();
stm.executeUpdate(query, autogenColumns);
ResultSet result_set = stm.getGeneratedKeys();
if (result_set.first()) {
this.id = result_set.getLong(1);
SpyMemCacheClient.getInstance()
.add(String.format(UserAccount.key_UserAccountByUserID, this.user_id), this);
}
conn.close();
} catch (SQLException e) {
System.out.println("SQL Exception Code : " + e.getErrorCode());
System.out.println("SQL Exception Message : " + e.getLocalizedMessage());
e.printStackTrace();
}
}