首先,我按照那个实例的使用说明,把所有程序的文件夹放在了apache-tomcat-6.0.16\webapps\下,然后,把数据库附加到了SQL中,然后,我把SQL驱动的三个补丁放到了apache-tomcat-6.0.16\lib下,然后就启动TOMCAT了,之后就报了这样的一个错误给我:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /login.jsp at line 96: String password=request.getParameter("password");
7:
8: Class.forName(CLASSFORNAME);
9: Connection con=DriverManager.getConnection(SERVER,USER,PWD);
10: Statement stmt=con.createStatement();
11: String isCorrect="select * from user_info where username='"+username+"'and password='"+password+"'";
12: ResultSet rs=stmt.executeQuery(isCorrect);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.login_jsp._jspService(login_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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.login_jsp._jspService(login_jsp.java:88)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs/////////////////////////////////////////////////////////////////////////////////////////
说明:
这是login.jsp 的前面一些连接数据库的代码:
import="java.sql.*,java.io.*"%>
<%@ include file="include.inc"%>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
Class.forName(CLASSFORNAME);
Connection con=DriverManager.getConnection(SERVER,USER,PWD);
Statement stmt=con.createStatement();
String isCorrect="select * from user_info where username='"+username+"'and password='"+password+"'";
ResultSet rs=stmt.executeQuery(isCorrect);这是文件include.inc的代码:
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="com.microsoft.jdbc.sqlserver.SQLServerDriver"%>
<%@ page contentType="text/html;charset=gb2312"%><%
request.setCharacterEncoding("gb2312");
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVER="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_login";
String USER="sa";
String PWD="pw1234";
%>小弟是个学JSP的新手,还希各位前辈高人们能指点一下,如果方便的话可以留个QQ联系一下吗?
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /login.jsp at line 96: String password=request.getParameter("password");
7:
8: Class.forName(CLASSFORNAME);
9: Connection con=DriverManager.getConnection(SERVER,USER,PWD);
10: Statement stmt=con.createStatement();
11: String isCorrect="select * from user_info where username='"+username+"'and password='"+password+"'";
12: ResultSet rs=stmt.executeQuery(isCorrect);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.login_jsp._jspService(login_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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.login_jsp._jspService(login_jsp.java:88)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs/////////////////////////////////////////////////////////////////////////////////////////
说明:
这是login.jsp 的前面一些连接数据库的代码:
import="java.sql.*,java.io.*"%>
<%@ include file="include.inc"%>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
Class.forName(CLASSFORNAME);
Connection con=DriverManager.getConnection(SERVER,USER,PWD);
Statement stmt=con.createStatement();
String isCorrect="select * from user_info where username='"+username+"'and password='"+password+"'";
ResultSet rs=stmt.executeQuery(isCorrect);这是文件include.inc的代码:
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="com.microsoft.jdbc.sqlserver.SQLServerDriver"%>
<%@ page contentType="text/html;charset=gb2312"%><%
request.setCharacterEncoding("gb2312");
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVER="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_login";
String USER="sa";
String PWD="pw1234";
%>小弟是个学JSP的新手,还希各位前辈高人们能指点一下,如果方便的话可以留个QQ联系一下吗?
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8009 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8080 0.0.0.0:0 LISTENING
TCP 127.0.0.1:445 127.0.0.1:1075 ESTABLISHED
TCP 127.0.0.1:1025 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1075 127.0.0.1:445 ESTABLISHED
TCP 127.0.0.1:8005 0.0.0.0:0 LISTENING
TCP 192.168.1.101:139 0.0.0.0:0 LISTENING
TCP 192.168.1.101:1825 81.52.202.222:80 ESTABLISHED
TCP 192.168.1.101:2116 211.100.21.8:80 TIME_WAIT
TCP 192.168.1.101:2124 211.100.26.123:80 TIME_WAIT
TCP 192.168.1.101:2141 211.100.26.123:80 TIME_WAIT
TCP 192.168.1.101:2149 211.100.26.123:80 TIME_WAIT
TCP 192.168.1.101:2158 211.100.26.121:80 TIME_WAIT
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1032 *:*
UDP 0.0.0.0:1038 *:*
UDP 0.0.0.0:1368 *:*
UDP 0.0.0.0:4000 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:6000 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1044 *:*
UDP 127.0.0.1:1119 *:*
UDP 127.0.0.1:1260 *:*
UDP 127.0.0.1:1307 *:*
UDP 127.0.0.1:1900 *:*
UDP 192.168.1.101:123 *:*
UDP 192.168.1.101:137 *:*
UDP 192.168.1.101:138 *:*
UDP 192.168.1.101:1900 *:*
请前辈们能教一下,怎么个看法,还有要打哪些补丁?谢谢
你把三个jar包放在tomcat-6.0.16\common\lib下,这个才是所有部署应用程序可以访问到的。
然后再把三个jar加入工程(Web-INF/lib)。
如果还有错误,你再试试安补丁。
xp系统有时是需要打ms sqlserver补丁的,也许你是驱动包配错了.
应该把三个jar包放在tomcat-6.0.16\common\lib下,这个才是所有部署应用程序可以访问到的。
然后再把三个jar加入工程(Web-INF/lib)。
这样之后应该才有安装补丁的可能性。