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.

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.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.