public boolean checkNameExist(SmsName smsname){
//以下只是判断相同名字的
boolean k = false;
String sql = "select name from fs_sms_name where name=?";
System.out.println(sql+"0000000000000000000000000000000");
ResultSet rs = null;
Connection conn=null;
DBConnectionManager connMgr = DBConnectionManager.getInstance();
System.out.println("3333"+smsname.getName());
conn = connMgr.getConnection("idb");
PreparedStatement ps = null;
try{
ps = conn.prepareStatement(sql);
ps.setString(1,smsname.getName());
rs = ps.executeQuery();
if(rs.next()){
k=true;
}else{
return false;
}
catch(Exception e){
k=false;
System.out.println("check error");
e.printStackTrace();
}finally{
connMgr.freeConnection("idb", conn);
connMgr.release();
}
return k;
}
//以下只是判断相同名字的
boolean k = false;
String sql = "select name from fs_sms_name where name=?";
System.out.println(sql+"0000000000000000000000000000000");
ResultSet rs = null;
Connection conn=null;
DBConnectionManager connMgr = DBConnectionManager.getInstance();
System.out.println("3333"+smsname.getName());
conn = connMgr.getConnection("idb");
PreparedStatement ps = null;
try{
ps = conn.prepareStatement(sql);
ps.setString(1,smsname.getName());
rs = ps.executeQuery();
if(rs.next()){
k=true;
}else{
return false;
}
catch(Exception e){
k=false;
System.out.println("check error");
e.printStackTrace();
}finally{
connMgr.freeConnection("idb", conn);
connMgr.release();
}
return k;
}