获取最新的CaseID

 //获取最新的CaseID
 public int getNewCaseID(){
  int id=0;
  try {
   super.openConn();
   String sqlString="select max(caseid) from cases";
   pStatement=connection.prepareStatement(sqlString);
   set=pStatement.executeQuery();
   if(set.next()){
    id=set.getInt(1);
   }
  } catch (Exception e) {
   // TODO: handle exception
   e.printStackTrace();
  }
  
  return id;
 }