A simple JSP connection MySQL use instance

First, the SOFTWARE environment

Download and install MYSQL,TOMACAT,JDBC, MyEclipse, or other Ides.

Second, the Environment configuration

After configuring its environment variables, download Java-specific connection to MySQL driver package jdbc, some people will find in some downloaded JDBC compressed package found in some files, For example: Mysql-connector-java-gpl-5.1.34.msi installation file, then what is this file for, and what is the difference between it and Mysql-connector-java-5.1.34-bin.jar? In fact, all two are the same, But Mysql-connector-java-gpl-5.1.34.msi is the Mysql-connector-java-5.1.xx-bin.jar encapsulated in the inside, MSI will have a folder after installation, there will be Mysql-connector-jav A-5.1.34-bin.jar This file, here we only need this mysql-connector-java-5.1.xx-bin.jar on the line.

Copy the Mysql-connector-java-x.x.x-bin.jar to the Tomcat installation bin directory D:\Tomcat 6.0\lib (if you are installing an MSI file, he may be in the Tools folder of the MySQL installation directory , this we do not recommend this use, directly download the jar file copy in the past, and then add D:\Tomcat 6.0\lib\mysql-connector-java-x.x.x-bin.jar inside the classpath. Copy this step is to configure the driver for the JSP connection database. If you are using Tomcat that comes with MyEclipse, copy the jar file directly to the "Project \webroot\web-inf\lib" path.

The purpose of this configuration is to have Java application find the driver to connect to MySQL.

third, JSP connection MySQL

Set up database student, set up table Stu_info. Now is the attempt to connect MySQL with JSP.
Build test Page test.jsp

[Java]View PlainCopy

2. <%@ page contenttype="text/html; charset=gb2312 "%>
4. <%@ page language="java"%>
6. <%@ page import="Com.mysql.jdbc.Driver"%>
8. <%@ page import="java.sql.*"%>
10. <%
12. Load Driver
14. String drivername="Com.mysql.jdbc.Driver";
16. Database Information
18. String username="root";
20. Password
22. String userpasswd="123";
24. Database name
26. String dbname="Student";
28. Table name
30. String tablename="Stu_info";
32. Connect the database information string to a full URL (or directly to a URL, and separate write is clear maintainability is strong)
36. String url="jdbc:mysql://localhost/" +dbname+"user=" +username+"&password=" +USERPASSWD;
38. Class.forName ("Com.mysql.jdbc.Driver"). newinstance ();
40. Connection conn=drivermanager.getconnection (URL);
42. Statement stmt = Conn.createstatement ();
44. String sql="select * from" +TABLENAME;
46. ResultSet rs = stmt.executequery (SQL);
48. Out.print ("id");
50. Out.print ("|");
52. Out.print ("name");
54. Out.print ("|");
56. Out.print ("phone");
58. Out.print ("<br>");
60. while (Rs.next ()) {
62. Out.print (rs.getstring (1) +"");
64. Out.print ("|");
66. Out.print (Rs.getstring (2) +"");
68. Out.print ("|");
70. Out.print (Rs.getstring (3));
72. Out.print ("<br>");
74. }
76. Out.print ("<br>");
78. Out.print ("OK, Database Query successd!   ");
80. Rs.close ();
82. Stmt.close ();
84. Conn.close ();
86. %>

Open our page in the browser side similar to: http://localhost:8080/Test/test.jsp can see the data of the query.

from:http://blog.csdn.net/kirinlau/article/details/53182789

A simple JSP connection MySQL use instance