Java(TM) Boutique - Building Web Applications Using Servlets and JSP

Tutorials : Building Web Applications Using Servlets and JSP :

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.

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.