Today's Question:  What's your opinion about Alibaba mooncake incident?        GIVE A SHOUT

Technical Article => Web =>  JSP

JSP connect MySQL

  Pi Ke      2011-05-11 10:04:57      5,284    0    0

To connect MySQL with Java Server Page(JSP). Some steps should be followed:

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.

MYSQL JSP CONNECTION DRIVER DOWNLOAD

  SAVE AS PDF   MARK AS READ   MARK AS IMPORTANT

Share on Facebook  Share on Twitter  Share on Google+  Share on Weibo  Share on Reddit  Share on Digg  Share on Tumblr    Delicious

  RELATED


  0 COMMENT


No comment for this article.


  WRITE ARTICLE

After developing a feature alone

By sonic0002