public int executeQuery(String query) {
		System.out.println("Result SET QUERY");
		int id = 0;
		//System.out.println("MySQL DAO executeResultSet");
		 // --- 3) prepare and execute statement
		   stmt = null;		// SQL statement object
		   rset = null;		// statement result set object
		   //    get resultset
		   System.out.println("query: " + query);
		   try
		   {
			 // System.out.println("Creating a statement");
			  stmt = conn.createStatement();
			  rset = stmt.executeQuery(query);
		   }
		   catch (Exception e)
		   {
			   //System.out.println("Could not execute SQL Result statement");
			   errorLogs.getErrorMsgs().add("DATABASE ERROR: Could not execute SQL RESULT statement");
			   System.out.println(e.getMessage());
			   
			   //System.exit(1);
		   }
		// use connection to execute query,
		// --- 4) process result set
		// process resultset
		   if(rset != null){
		   try {
			   while (rset.next()) {
				   id = rset.getInt(1);
			   }     // --- end - while
		   }
		   catch (SQLException sqle) {
			   System.out.println("Could not process result set");
			   errorLogs.getErrorMsgs().add("DATABASE ERROR: Could not process result set");
			   System.out.println(sqle.getMessage());
			  // System.exit(1);
		   }
		   }
		// set errorCode
		return id;
	}