以下是正确的代码,不过你要把其中的数据库名,表名换为你的数据库名,表名!!
确定你的服务器能找到mysql-connector-java-3.1.1-alpha-bin.jar
一般把它放到%javahome%/jre/lib/ext/下
<%@ page language = "java" %>
<%@ page import = "java.sql.*" %>
<%@ page contentType = "text/html;charset=gb2312" %>
<html>
<head>
<title>test</title>
</head>
<body>
<%
String sDBDriver = "com.mysql.jdbc.Driver";
String sConnStr = "jdbc:mysql://localhost/project";
String tt;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("connect to database error"+e.getMessage());
}
try
{
con = DriverManager.getConnection(sConnStr,"xd","123456");
}
catch(SQLException e)
{
out.print(e.toString());
}
stmt = con.createStatement();
rs = stmt.executeQuery("select * from student");
while (rs.next())
{
out.print("<tr><td>");
tt = rs.getString(1);
out.print(tt);
out.print("</td><td>");
tt = rs.getString(2);
out.print(tt);
out.print("</td></tr>");
}
out.print("Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Ä㣡");
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
确定你的服务器能找到mysql-connector-java-3.1.1-alpha-bin.jar
一般把它放到%javahome%/jre/lib/ext/下
<%@ page language = "java" %>
<%@ page import = "java.sql.*" %>
<%@ page contentType = "text/html;charset=gb2312" %>
<html>
<head>
<title>test</title>
</head>
<body>
<%
String sDBDriver = "com.mysql.jdbc.Driver";
String sConnStr = "jdbc:mysql://localhost/project";
String tt;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("connect to database error"+e.getMessage());
}
try
{
con = DriverManager.getConnection(sConnStr,"xd","123456");
}
catch(SQLException e)
{
out.print(e.toString());
}
stmt = con.createStatement();
rs = stmt.executeQuery("select * from student");
while (rs.next())
{
out.print("<tr><td>");
tt = rs.getString(1);
out.print(tt);
out.print("</td><td>");
tt = rs.getString(2);
out.print(tt);
out.print("</td></tr>");
}
out.print("Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Ä㣡");
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
我的确是改成我的了
包括复制文件mysql-connector-java-3.1.1-alpha-bin.jar到%javahome%/jre/lib/ext/
换成自己的数据库、表名,以及连接用的自己有权限的用户名、口令
look:<%@ page language = "java" %>
<%@ page import = "java.sql.*" %>
<%@ page contentType = "text/html;charset=gb2312" %>
<html>
<head>
<title>test</title>
</head>
<body>
<%
String sDBDriver = "com.mysql.jdbc.Driver";
String sConnStr = "jdbc:mysql://localhost/bookShop";
String tt;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("connect to database error"+e.getMessage());
}
try
{
con = DriverManager.getConnection(sConnStr,"root","123456");
}
catch(SQLException e)
{
out.print(e.toString());
}
stmt = con.createStatement();
rs = stmt.executeQuery("select * from books");
while (rs.next())
{
out.print("<tr><td>");
tt = rs.getString("publisher");
out.print(tt);
out.print("</td><td>");
tt = rs.getString("version");
out.print(tt);
out.print("</td></tr>");
}
out.print("数据库操作成功,恭喜你!");
rs.close();
stmt.close();
con.close();
%>
</body>
</html>到底哪里有问题呢?
错误提示还是一样顺便问一句 怎么是 完全错误呢
我觉得操作过程还是基本正确的啊谢谢帮助啊 希望继续
你出什么错啊?
万分感谢!
你看看吧
我马上发给你
//Can't use localhost , you must use IP or CNAME,