The Complete ValidateUser Method

Here is the code ... putting it all together. Remember in our sample application of Part 1 we said we will write a validateUser method? Here is the code for such a method.

public String validateUser(String inputUserid, String inputPwd) 
   throws SQLException{
	String returnString = null;
	String dbUserid = "userid"; // Your Database user id
	String dbPassword = "password" ; // Your Database password
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con = DriverManager.getConnection("jdbc:odbc:myDriver",
						dbUserid ,dbPassword );
	Statement stmt = con.createStatement();
	String sql= "select USERID from USERTABLE where USERID = '" + 
		   inputUserid + "' and PASSWORD = '" + inputPwd +"' ;" ; 
	ResultSet rs = stmt.executeQuery(sql);
	if (rs.next())
	{
	  returnString = rs.getString("USERID");
	}
	stmt.close();
	con.close();
	return returnString ;
}

This method - ValidateUser will return the username if the supplied username - password combination exists in the database. Otherwise it will return null.

STEP 2: Use This Connection to Access the Database
Building Web Applications Using Servlets and JSP Part II
JDBC 2.0