public void save(Rank rank){
String sqlString = "insert into webmodbus.rank "+
"(_id,rankName,tenementID,parentID,state) values("
+ "%d,'%s',%d,%d,%d)";
long id = 0L;
try {
id = sequoiadbBean.getMaxId("rank");
} catch (BaseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InterruptedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
id+=1;
rank.setRankID((int)id);
sqlString = String.format(sqlString, id,rank.getRankName(),rank.getTenementID(),
rank.getParentID(),rank.getState());
Sequoiadb db =null;
try{
db = sequoiadbBean.getConnection();
db.execUpdate(sqlString);
}catch (Exception e) {
// TODO: handle exception
}finally{
sequoiadbBean.closeConnection(db);
}
}
这就是插入新数据到rank集合中的代码,可以成功插入数据