code to get the task Key of a Resource

public long taskKey(String taskname,String resourceName){
long ret=0;
try
{

Class.forName("oracle.jdbc.driver.OracleDriver");
  String url = "jdbc:oracle:thin:@localhost1:siddb";
  Connection conn = DriverManager.getConnection(url,"adm","password");
System.out.println("connected");
Statement stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("SELECT m.mil_key,m.MIL_NAME FROM mil m, pkg p, tos t WHERE m.mil_name = '"+taskname+"' AND m.TOS_KEY = t.TOS_KEY AND t.PKG_KEY = p.PKG_KEY AND p.pkg_name='"+resourceName+"'");


while (rset.next()) {
String convertret=rset.getString(1);
long longKey = Long.parseLong(convertret);
System.out.println ("TaskKey-->"+longKey);
System.out.println ("TaskName-->"+rset.getString(2));
return longKey;

}
stmt.close();
}
catch (Exception e)
{
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
}
return ret;


}