请教jdbc数据库连接问题?
执行以下程序代码:
mybag.inc文件代码如下:
<%@ page import= "java.sql.* "%>
<%@ page import= "java.util.* "%>
<%@ page import= "java.io.* "%>
<%@ page import= "com.microsoft.jdbc.sqlserver.SQLServerDriver "%>
<%@ page import= "java.lang.* "%>
<%@ page contentType= "text/html; charset=gb2312 "%>
<%
request.setCharacterEncoding( "gb2312 ");
String CLASSFORNAME= "com.microsoft.jdbc.sqlserver.SQLServerDriver ";
String SERVANDDB= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school ";
String USER= "sa ";
String PWD= "sa ";
%>
chaxun.jsp文件代码如下:
<%@ include file= "mybag.inc "%>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 无标题文档 </title>
</head>
<body>
<%
//获得请求的参数。
String id=request.getParameter( "tuser ");
String psw=request.getParameter( "pwd ");
//连接数据库
Class.forName(CLASSFORNAME);
Connection con = DriverManager.getConnection(SERVANDDB,USER,PWD);
Statement statement=con.createStatement();
String isCorrect= "select * from users where userid= ' " + id + " ' and password= ' " + psw + " ' ";
ResultSet result=statement.executeQuery(isCorrect);
out.print(result.getString( "username "));
%>
</body>
</html>
运行chaxun.jsp文件后出现以下错误,小弟没有办法解决,请教各位大哥
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.tep3_jsp._jspService(tep3_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection. <init> (Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.tep3_jsp._jspService(tep3_jsp.java:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
说明:jdbc三个驱动文件已复制到F:\Tomcat 5.0\common\lib下
[解决办法]
SQLServer2000下载补丁SP3或SP4打上就可以了
[解决办法]
http://wstatic.xunlei.com/web/download.htm?cid=E56854A62158F7C179AB2799300A5EB501A8A506
这下sp4
[解决办法]
修改：
out.print(result.getString( "username "));
为
if(result.next()){
out.print(result.getString( "username "));
}else{
out.print( "-------no data ");
}
[解决办法]
String isCorrect= "select * from users where userid= ' " + id + " ' and password= ' " + psw + " ' ";
改为
String isCorrect= "select * from users where userid= " + id + " and password= ' " + psw + " ' ";
还有就是
out.print(result.getString( "username "));
改为
if(result.next())
{
out.print(result.getString( "username "));
}
else
{
out.print( "没有此用户和密码 ");
}
我的异常网推荐解决方案：The server encountered an internal error () that prevented it from fulfilling this request.,http://www.myexception.cn/java-web/317.html
