public void validateLoginPreparedStatement(String username, String password) {
	try {
	stmt = conn.createStatement();
	String query = "SELECT * FROM users where username = ? and password =?";
	PreparedStatement pStat = conn.prepareStatement(query);
	pStat.setString(1, username);
	pStat.setString(2, password);
	rs = pStat.executeQuery();
	if (rs.next()) {
	     System.out.println("User is logged in");
	} else {
		System.out.println("Invalid Username and Password");}
	} catch (SQLException e) {
			e.printStackTrace();}}

public void insertUser() {
		try {
			stmt = conn.createStatement();
			String insert = "INSERT INTO users (ID, username,password) values (1004, 'newUser','newPass')";
			int rowCount = stmt.executeUpdate(insert);
			System.out.println("row Count = " + rowCount);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}