判断名称在数据库中是否存在

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;
 }