我也是刚开始学用mysql的。我下载的是mm.mysql-2.0.4-bin.jar
连接是Class.forName("org.gjt.mm.mysql.Driver").newInstance();
你试试把你的Connection Con = DriverManager.getConnection("jdbc:mysql://localhost:3306/drs_db","DRSTester","DRSTester");
改成Connection Con = DriverManager.getConnection("jdbc:mysql://localhost/mysql","你的mysql的用户名","你的密码");
实在不行你试试下面这个jsp:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
//try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/mysql";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) out.println("读出一条记录");
out.print("数据库操作成功,恭喜你");
rs.close();
stmt.close();
conn.close();
//}catch(Exception e){out.println(e.toString());}
%>
</body>
</html>
连接是Class.forName("org.gjt.mm.mysql.Driver").newInstance();
你试试把你的Connection Con = DriverManager.getConnection("jdbc:mysql://localhost:3306/drs_db","DRSTester","DRSTester");
改成Connection Con = DriverManager.getConnection("jdbc:mysql://localhost/mysql","你的mysql的用户名","你的密码");
实在不行你试试下面这个jsp:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
//try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/mysql";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) out.println("读出一条记录");
out.print("数据库操作成功,恭喜你");
rs.close();
stmt.close();
conn.close();
//}catch(Exception e){out.println(e.toString());}
%>
</body>
</html>
要确认是才行