register normal

public String register(String username, String password) throws RemoteException {
		int check = 0;
		String resultado;
		// -------------------------------------
		// Verificar se o registo pode ser feito;
		// -------------------------------------
		Statement myStmt;

		// PreparedStatement Qusername;
		// PreparedStatement Qpassword;
		//
		// String FindUsername = "SELECT USERNAME\n" + "FROM users\n" + "WHERE
		// USERNAME = ?";
		// String Findpassword = "INSERT INTO users (USERNAME, PASSWORD, ONLINE,
		// USER_STATE)\n " + "VALUES (?, ?, 0, 'active')";
		try {

			myStmt = myConn.createStatement();

			myConn.setAutoCommit(false);

			ResultSet myRs = myStmt
					.executeQuery("SELECT USERNAME\n" + "FROM users\n" + "WHERE USERNAME ='" + username + "'");// results
																												// set

			if (myRs.next()) {

				if (myRs.getString("USERNAME").equals(username)) {
					check = 1;

				}
			} else if (check == 0) {
				String var ="";
				String sql = "INSERT INTO users (USERNAME, PASSWORD, ONLINE, USER_STATE, ID_FACEBOOK)\n " + "VALUES ('" + username
						+ "', '" + encryptPassword(password) + "', 0, 'active','"+var+"' )";
				myStmt.executeUpdate(sql); // results set
			}
			// myRs.close();
			// myStmt.close();
			myConn.commit();
		} catch (SQLException e) {// tratar exception de limite de carateres
			check = 1;
			try {
				System.out.println("Transaction in register is being rolled back");
				myConn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}

		if (check == 0) {

			resultado = "type: register, ok: true";

		} else {

			resultado = "type: register, ok: false";
		}
		return resultado;
	}