<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>Data Base jsp</title>
</head>
<body>
<% Connection con;
Statement sql;
ResultSet rs;
String user="sa";
String password="09104087";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=print";
try
{
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("第一个错误!");
}
try
{
con = java.sql.DriverManager.getConnection(url,user,password);
sql = con.createStatement();
rs = sql.executeQuery("select * from client");
out.print("<table Border");
out.print("<tr>");
out.print("<th width=100>"+"编号");
out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
sql.close();
}
catch(SQLException e1)
{
out.print("第二个错误fdsgfsdgsfgsg!");
}
%>
</body>
</html>
每次执行都是显示:第一个错误,第二个错误
请问这是怎么回事!!!!!
<%@ page import="java.sql.*"%>
<html>
<head>
<title>Data Base jsp</title>
</head>
<body>
<% Connection con;
Statement sql;
ResultSet rs;
String user="sa";
String password="09104087";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=print";
try
{
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("第一个错误!");
}
try
{
con = java.sql.DriverManager.getConnection(url,user,password);
sql = con.createStatement();
rs = sql.executeQuery("select * from client");
out.print("<table Border");
out.print("<tr>");
out.print("<th width=100>"+"编号");
out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
sql.close();
}
catch(SQLException e1)
{
out.print("第二个错误fdsgfsdgsfgsg!");
}
%>
</body>
</html>
每次执行都是显示:第一个错误,第二个错误
请问这是怎么回事!!!!!
很明显你catch住了这个异常,那就证明你的db驱动没有放到你的classpath\lib的目录下
下个sql 的驱动,安装后将3个.jar文件考到classpath\lib目录下
http://www.microsoft.com/downloads/details.aspx?FamilyID=07287b11-0502-461a-b138-2aa54bfdc03a&DisplayLang=en
这个是sql2000 sp3的驱动
记得自己打补丁
我把驱动安装到C盘中了,然后把那个目录放到CLASSPATH中了,但是还是不能运行,我又把那三个.JAR放到我的JDK的LIB中去了,把这个文件也设置到CLASSPATH中了,还是不行的,我打的SP4的补丁.