Step 1: Download MySQL JDBC connector driver from the Internet. URL: http://dev.mysql.com/downloads/connector/j/
Step 2: Put the jar file downloaded in Step 1 in the Tomcat common lib folder and add this jar file to the CLASSPATH so that the JSP page can find the specified class.
Step 3: Create the JSP page with MySQL connection : Example is shown below:
<%
String driver="com.mysql.jdbc.Driver";
Class.forName(driver).newInstance();
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
conn=DriverManager.getConnection("jdbc:mysql://localhost/dbname?user=<username>&password=<password>");
stmt=conn.createStatement();
}catch(Exception e){
System.out.println(e.getMessage());
}
%>
Hope this will help you in your JSP development. One notice is that the driver string can also be "org.gjt.mm.mysql.Driver". This is to make it backward compatible with previous
vsersion of MySQL.
