有人帮我看下这个错误提示是什么意思？
一个简单的SQL查询语句如下：
<%@page contentType="text/html;charset=gb2312" %>
<%@page language="java"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.util.Date"%>
<%@page import="java.sql.*"%>
<%@ page import="db.DBConnectionManager" %>
<jsp:useBean id="connMgr" class="db.DBConnectionManager" scope="session" >
<jsp:setProperty name="connMgr" property="*" />
</jsp:useBean>
<%
HttpServletRequest req;
HttpServletResponse res;
InputStream in = this.getClass().getClassLoader().getResourceAsStream("db.txt");
Properties dbProps = new Properties();
try {
dbProps.load(in);
} catch(Exception e) {
System.out.println("不能够读取属性文件:" + "请确保db.properties在CLASSPATH指定的路径中");
return;
}
String driver = dbProps.getProperty("drivers");
String user = dbProps.getProperty("access.user");
String password = dbProps.getProperty("access.password");
String url = dbProps.getProperty("idb.url");
String url1 = dbProps.getProperty("access.url");
String maxconn = dbProps.getProperty("idb.maxconn","0");
out.println(driver);
out.println(user);
out.println(password);
out.println(maxconn);
out.println(url);
out.println(url1);
Connection con = connMgr.getConnection("idb");
if(con == null) {
out.println("con为空,不能获取数据库连接");
return;
}
ResultSet rs = null;
ResultSetMetaData md = null;
Statement stmt = null;
try {
int k = 0;
stmt = con.createStatement();
rs = stmt.executeQuery("select * from user1");
md = rs.getMetaData();
if(rs == null)
out.println("不能获取数据库连接");
if(rs != null)
out.println("能获取数据库连接");
out.println("<h1>职工数据</h1>");
while (rs.next()){
out.println("<br>");
for(int i = 1; i < md.getColumnCount(); i++) {
out.println( rs.getString(i));
k = i;
}
out.println(rs.getString(k + 1));
}
stmt.close();
rs.close();
} catch(SQLException e) {
}
//将这个连接加入到数据库连接池//
connMgr.freeConnection("idb",con);
%>
结果并没有判断rs的值,所以没有任何显示rs相关的信息,数据也没有显示出来.
去点try...catch语句后,页面显示如下错误:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]??? 'user1' ???
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.test1_jsp._jspService(test1_jsp.java:144)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]??? 'user1' ???
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
org.apache.jsp.test1_jsp._jspService(test1_jsp.java:108)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
我是刚刚学习JSP,知识经验少,希望大家多多指教.
问题点数：20、回复次数：6Top
1 楼JIEK_ONE（weiwei）回复于 2004-12-01 21:43:48 得分 0
顶Top
2 楼JIEK_ONE（weiwei）回复于 2004-12-01 21:48:30 得分 0
在顶Top
3 楼JIEK_ONE（weiwei）回复于 2004-12-01 22:38:06 得分 0
没有人帮我下吗？Top
4 楼chenyongchina（）回复于 2004-12-01 23:46:08 得分 10
连接数据库的问题，JDBC-ODBC驱动问题Top
5 楼dlxu（脱离纯粹Coding阶段）回复于 2004-12-02 00:00:22 得分 10
上面好像顯示你數據庫中沒有user1這張表Top
6 楼JIEK_ONE（weiwei）回复于 2004-12-02 10:42:16 得分 0
谢谢大家了 马上JIE TIETop
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
