81,092
社区成员
发帖
与我相关
我的任务
分享请问如何解决jsp连接sqlserver数据的问题?
求助：程序运行到con=DriverManager.getConnection("jdbc:odbc:testDB")部分出现错误，请帮忙，
源程序：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.print("class not find!");
}
try
{
con=DriverManager.getConnection("jdbc:odbc:testDB");
System.out.println("aaa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM userTale");
out.print("<table border>");
out.print("<tr><td colspan=8 align=center> userDate</td></tr>");
out.print("<tr>");
out.print("<td width=100>"+"userID");
out.print("<td width=50>"+"username");
out.print("<tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<tr>");
}
out.print("</table>");
con.close();
}
catch(Exception e2)
{
out.print("SQL Exception!");
}
%>
</body>
</html>
源程序：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.print("class not find!");
}
try
{
con=DriverManager.getConnection("jdbc:odbc:testDB");
System.out.println("aaa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM userTale");
out.print("<table border>");
out.print("<tr><td colspan=8 align=center> userDate</td></tr>");
out.print("<tr>");
out.print("<td width=100>"+"userID");
out.print("<td width=50>"+"username");
out.print("<tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<tr>");
}
out.print("</table>");
con.close();
}
catch(Exception e2)
{
out.print("SQL Exception!");
}
%>
</body>
</html>
...全文
请发表友善的回复…
发表回复
