捕捉到ClassNotFoundException,SQLException错误

挨踢啊挨踢 2004-09-09 06:46:52

如题,是什么错误啊,我是不是需要在环境变量里加什么jar?

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html><body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("tdh.jdbc.odbc.JdbcOdbcDriver");

}
catch(ClassNotFoundException e)
{
out.print("ClassNotFoundException<br>");
}
try
{
con=DriverManager.getConnection("jdbc:odbc:tdh","sa","");
sql=con.createStatement();
rs=sql.executeQuery("select * from jobs");
out.print("<table border>");
out.print("<tr>");
out.print("<th width=100>"+"description");
out.print("<th width=100>"+"min");
out.print("<th width=100>"+"max");

out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td width=100>"+rs.getString(1)+"</td>");
out.print("<td width=100>"+rs.getString(2)+"</td>");
out.print("<td width=100>"+rs.getString(3)+"</td>");

out.print("</tr>");

}
out.print("</table>");
rs.close();
con.close();
}
catch(SQLException e1)
{
out.print("SQLException<br>");
}
%>
</body></html>

...全文

298 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

liqun5218 2004-09-14

打赏
举报

请问楼主，这样的话还需要在数据源（ODBC)中配置DSN吗？
我仿照你的写了个jsp，也是提示ClassNotFoundException信息。
我把这句
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs","sa","");
--------------->改为
con=DriverManager.getConnection ("jdbc:microsoft:sqlserver://localhost:8080;DatabaseName=jspSql","","");
这样改对吗？

挨踢啊挨踢 2004-09-13

打赏
举报

调成功了,呵呵.
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html><body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

}
catch(ClassNotFoundException e)
{
out.print("ClassNotFoundException<br>");
}
try
{
con=DriverManager.getConnection ("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs","sa","");

sql=con.createStatement();
rs=sql.executeQuery("select * from jobs");
out.print("<table border>");
out.print("<tr>");
out.print("<th width=100>"+"description");
out.print("<th width=100>"+"min");
out.print("<th width=100>"+"max");

out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td width=100>"+rs.getString(1)+"</td>");
out.print("<td width=100>"+rs.getString(2)+"</td>");
out.print("<td width=100>"+rs.getString(3)+"</td>");

out.print("</tr>");

}
out.print("</table>");
rs.close();
con.close();
}
catch(SQLException e1)
{
out.print("SQLException<br>");
}
%>
</body></html>

----------------------------------------
总结一下:
1.获取SQL Server包.考到web-inf/lib下(我现在在root下),添加到classpath中.
2.连接到数据库:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs","sa","");
4.向数据库发送sql语句:
sql=con.createStatement();
rs=sql.executeQuery("select * from jobs");
5.处理查询结果.

挨踢啊挨踢 2004-09-13

打赏
举报

还是不成！！感觉jsp的开发环境很糟糕,一些东西都要手工设置,有好的开发环境吗?我用jcreator.
我总结一下：
1.获取SQL Server包.考到web-inf/lib下,我现在在root下.
2.控制面板-->创建名为tdh的用户dsn(sql server).
(在这里是否要设置server.xml或web.xml里的参数???)
3.连接到数据库:DriverManager.getConnection("jdbc:odbc:tdh","sa","").
4.向数据库发送sql语句:
sql=con.createStatement();
rs=sql.executeQuery("select * from jobs");
5.处理查询结果.

bluesky35 2004-09-09