jsp连接数据库SQLServer2008在tomcat环境下打开网页出现错误,求高手解答原因

2014-05-15 06:37:54 145 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

动态网页（JSP 文件）如何连接数据库（SQL Server）--看这里动态网页（JSP)连接数据库文件（SQL SERVER) 举例演示，请到百度网盘下载例文件，如果要是有文件可以不需要文件链接：https://pan.baidu.com/s/1_zZQV8pjaI5mlcNBgNY_0A 提取码：2fju 环境配置第一步：需配置连接环境，需要下图的文件（第一个是数据库附加的库文件压缩包，第二三都是环境文件）第二步：配置Tomcat服务器。 1. 打开Monitor Tomcat服务器，在“Java”选项卡的Java Classpath... 阅读详情

<%

// ***************** 数据库连接代码　开始 *****************

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433; DatabaseName=JDGL";
String user = "sa";
String password = "";
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url, user, password);

//建立连接
//Connection conn= DriverManager.getConnection(url);
// **** 数据库连接代码　结束 *********
%>

org.apache.jasper.JasperException: An exception occurred processing JSP page /ConnDB.jsp at line 14

11: String user = "sa";
12: String password = "";
13: Class.forName(driverName);
14: Connection conn=DriverManager.getConnection(url, user, password);
15:
16:
17: //建立连接

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:412)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:865)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794)
org.apache.jsp.index_005fMain_jsp._jspService(index_005fMain_jsp.java:220)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2532)
com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1929)
com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1917)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1061)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:185)
org.apache.jsp.index_005fMain_jsp._jspService(index_005fMain_jsp.java:74)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

...全文