public boolean validateSmitemData(String servicecode, String paramcode,String gatename) {
DBConn con;
boolean flag=false;
try {
con = new DBConn();
con.setConnName("bdxt");
PreparedStatement ps=null;
String select_smitem_s_p_g="select * from SmItemData where ServiceCode=? and ParamCode=? and GateName=?";
ps=con.prepareStatements(select_smitem_s_p_g);
ps.setString(1, servicecode);
ps.setString(2, paramcode);
ps.setString(3, gatename);
ResultSet rs=ps.executeQuery();
System.out.println("rs====="+rs.next());
if(rs.next()){
flag=true;
System.out.println("flag===1======="+flag);
}else{
flag=false;
System.out.println("flag====2======"+flag);
}
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
} catch (Exception e) {
log.debug("操作数据库保存注册上行信息时出错:" + e.getMessage());
e.printStackTrace();
}
return flag;
}
DBConn con;
boolean flag=false;
try {
con = new DBConn();
con.setConnName("bdxt");
PreparedStatement ps=null;
String select_smitem_s_p_g="select * from SmItemData where ServiceCode=? and ParamCode=? and GateName=?";
ps=con.prepareStatements(select_smitem_s_p_g);
ps.setString(1, servicecode);
ps.setString(2, paramcode);
ps.setString(3, gatename);
ResultSet rs=ps.executeQuery();
System.out.println("rs====="+rs.next());
if(rs.next()){
flag=true;
System.out.println("flag===1======="+flag);
}else{
flag=false;
System.out.println("flag====2======"+flag);
}
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
} catch (Exception e) {
log.debug("操作数据库保存注册上行信息时出错:" + e.getMessage());
e.printStackTrace();
}
return flag;
}
这条语句的记录