安裝JDBC驅動MySQL Connector/J 3.1.12

1.mysql-connector-java-3.1.12-bin.jar復制到 Tomcat 5.0的common\lib 和  JDK的\lib下  
(則需要設置classpath指向該路徑)
我這里classpath是
.;C:\j2sdk1.4.2\lib\dt.jar;

C:\j2sdk1.4.2\lib\tool.jar;

C:\j2sdk1.4.2\lib\NetComponents.jar;

C:\j2sdk1.4.2\lib\mysql-connector-java-3.1.12-bin.jar;

D:\Tomcat 5.0\common\classes;

D:\Tomcat 5.0\common\lib;

D:\Tomcat 5.0\common\lib\servlet-api.jar;

 

 

 

2.在mysql的test中建newtable表 

字段  id(int)         name1(char)      name2(char)

 

 

3.

test_jdbc.jsp

測試用以下代碼:

<%@ page contentType="text/html;charset=GB2312"%>
<%@ page language="java" import="java.sql.*"%>
<%
String mySqlDriver = "org.gjt.mm.mysql.Driver"; //JDBC驅動

String url = "jdbc:mysql://localhost/test";   //數(shù)據(jù)庫連接
 Connection conn;
 Class.forName(mySqlDriver);
 conn = DriverManager.getConnection( url,"root",""); //用戶名與密碼
 if(conn==null){
System.out.println("get Conn Error");
}
Statement stmt=conn.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery("select * from newtable");
while(rs.next())
{ //循環(huán)顯示記錄
%>

id:<%=rs.getString("id")%>

name1:<%=rs.getString("name1")%>

name2:(<%=rs.getString("name2")%>)
<%="<br>"%>
 

<%
}
rs.close();
stmt.close();
conn.close();
%>