java 反射 pojo dao_Java纯POJO类反射到Redis，反射到MySQL

public class DbWriterTimerTask extendsTimerTask {private static final Logger LOG = LoggerFactory.getLogger(DbWriterTimerTask.class);public static boolean isRunning = false;

@Overridepublic voidrun() {if (!isRunning) {

isRunning= true;

Date begin= newDate();

LOG.info("DbWriterTimerTask begin at {} ...", begin);

executeTask();

isRunning= false;

Date end= newDate();

LOG.info("DbWriterTimerTask finish at {}, till for {} millseconds.", end, (end.getTime() -begin.getTime()));

}else{

LOG.error("DbWriterTimerTask is executing now ...");

}

}public voidexecuteTask() {int total=0;int inserted=0;int updated=0;int duplicated=0;int errored=0;

Set setModels = new HashSet();try{//Thread.sleep(3000);

long doCount = Configure.getPropertyLong("dbWriter.docount", 20);int timeExpire = Configure.getPropertyInt("dbWriter.timeexpire", 60*60);

List list =RedisDAO.retrieveUpdateList(doCount);if(list==null)return;

total=list.size();while (list.size() > 0) {

DbUpdateItem item= list.remove(0);try{//save ids firstly

if(!setModels.contains(item.m)) {if(writeBackIdValueFromModel(item.m))

setModels.add(item.m);

}//find item from redis//找到class的类定义

Class> clazz =MySqlDAO.simpleDb().getClassByName(item.m);//从Redis加载类实体数据，不同的对象，加载方式会不同，因为有些对象是类自己控制序列化

Object object=null;if(clazz.getSimpleName().equals("CharaValues")) {

object=CharaValues.find(item.id);

}else if(clazz.getSimpleName().equals("CharaBox")) {

object=CharaBox.find(item.id);

}else if(clazz.getSimpleName().equals("CharaTask")) {

object=CharaTask.find(item.id);

}else{

object=RedisDAO.find(clazz, item.id);

}//save to db

if(object==null) {

LOG.error("can not find {} with {}.", item.m, item.id);

errored++;

}else{//find it in db

Object o =MySqlDAO.simpleDb().getById(clazz, item.id);if(o==null) {

MySqlDAO.simpleDb().create(object);

inserted++;

}else{

MySqlDAO.simpleDb().updateEntity(object);

updated++;

}

}//设置过期标志

RedisDAO.expireObject(item.m, item.id.longValue(), timeExpire);

}catch(Exception e) {

LOG.error("writeDb error.", e);

}finally{//find all same object and pop it

Iterator iter =list.iterator();while(iter.hasNext()) {

DbUpdateItem it=iter.next();//if(it.m.equals(item.m) && it.o.equals(item.o) && it.id.equals(item.id)) {

if(it.m.equals(item.m) &&it.id.equals(item.id)) {

iter.remove();//pop it

duplicated++;

}

}

}

}

LOG.info("Total {} been processed, Inserted {} records, Updated {} records, skip duplicated {} records, errrors {} records.", total, inserted, updated, duplicated, errored);

}catch(Exception e) {

LOG.error("executeTask error.", e);

}return;

}public booleanwriteBackIdValueFromModel(String modelName) {boolean result = false;

Jedis jedis=RedisDAO.getResource();try{

String idString= jedis.get(modelName+":id");if(idString==null)return true;

Long idValue=Long.parseLong(idString);

result=writeBackIdValue(modelName, idValue);

}catch(Exception e) {

LOG.error("writeBackIdValueFromModel error.", e);

}finally{

RedisDAO.returnResource(jedis);

}returnresult;

}public booleanwriteBackIdValue(String modelName, Long idValue) {

String sqlCount= "select count(*) from sangame_ids where model=?";

String sqlInsert= "insert sangame_ids(model, idvalue, time_insert) values(?, ?, CURRENT_TIMESTAMP)";

String sqlUpdate= "update sangame_ids set idvalue=? where model=? and idvalue";if(MySqlDAO.simpleDb().queryForLong(sqlCount, modelName) > 0) {

MySqlDAO.simpleDb().executeUpdate(sqlUpdate, idValue, modelName, idValue);

}else{

MySqlDAO.simpleDb().executeUpdate(sqlInsert, modelName, idValue);

LOG.info("Initial ids fro model {} with {}.", modelName, idValue);;

}return true;

}

}