62,614
社区成员
发帖
与我相关
我的任务
分享
。。。。。
public void run() {
while (true) {
try{
readList() ;
}catch(Exception e){
log().error("",e);
}
}
}
private List<CMPP2AbstractMessage> readList() {
Session ssn = null;
Connection con = null;
PreparedStatement pre = null;
ResultSet rs = null;
List<NewSmsBeenSentNumber> smsSent = new ArrayList<NewSmsBeenSentNumber>();
try {
//log().info("read data to send--->get the datebase session----->begin"); ssn = HibernateSessionFactory.currentSession();
//log().info("read data to send--->get the datebase session----->over!"); con = ssn.connection();
log().info("read data to send--->get the datebase conection--->over!");
String str = "select DN_NEEDREPLY, DC_SERVID, phoneId, DC_DST_ID, s.dn_id as dnSmsId, contentId, DC_EXTMARKID, dn_feeusertype,";
str += " DC_FEETERMID, nc.DN_FORMAT, dc_feeType, dc_feecode, dc_srcid, nc.DC_CONTENT, DN_PK_NUMBER, DN_PK_TOTAL";
str += " from";
。。。。。。
str += " on s.dn_id = nc.dn_sms_id";
pre = con.prepareStatement(str);
pre.setQueryTimeout(60 * 2);//SQL语句执行超时时间为2分钟
log().info("query data-->begin");
rs = pre.executeQuery();
log().info("query data->return back");
while (rs.next())
{
NewSmsBeenSentNumber bean = new NewSmsBeenSentNumber();
int dnNeedreply = rs.getInt("DN_NEEDREPLY");
bean.setDnNeedRly(dnNeedreply);
String dcServId = rs.getString("DC_SERVID");
bean.setDcServid(dcServId);
.......
smsSent.add(bean);
}
} catch (Exception e) {
log().error("", e);
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
pre.close();
} catch (Exception e) {
}
HibernateSessionFactory.closeSession();
}
//
。。。。。。。。。 }
private Logger log() {
return ThreadLogger.getInstance();
}