安装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";   //数据库连接
 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())
{ //循环显示记录
%>

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

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

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

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