ResultSet rs = stmt.executeQuery();
rs.next();
if (!rs.next())
{
System.err.println("Does not exist");
}

ResultSet rs = stmt.executeQuery();
if (rs.next())
{
  System.err.println("Does exist");
}
else
{
  System.err.println("Does not exist");
}

 rs.close();
stmt.close();
return rs.getString(1);

PreparedStatement stmt = null;
ResultSet rs = null;
String strSQL = "";
String result = "";
try
{
  strSQL = " SELECT Paytypeid FROM Paytype WHERE Payname= ?";
  stmt = getDBTransaction().createPreparedStatement(strSQL, 0);
  stmt.setString(1, vstrPayname);
  rs = stmt.executeQuery();
  if (rs.next())
  {
    result = rs.getString(1);
  }
}
catch(SQLException se)
{
  se.getMessage();
  result = "-1";
}
catch(Exception e)
{
  e.printStackTrace();
  result = "-1";
}
finally
{
  if (rs != null) rs.close();
  if (stmt != null) stmt.close();
}
return result;