这个是哪里出错了,一直报?
代码:
<%@page contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<%@page language="java" import="java.sql.*" %>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String sConn="jdbc:sqlserver://192.168.20.88:1433;DatabaseName=RVIS";
Connection conn = DriverManager.getConnection( sConn,"sa","mssql" );
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
strId = request.getParameter("TacticId");
strId = new String(strId.getBytes("ISO-8859-1"), "UTF-8");
String query = "select * from RVIS_Tactic where TacticNumber="+strId+" and TacticType=1 and TacticStatus=0";
ResultSet rs = stmt.executeQuery( query );
if(!rs.isBeforeFirst()&&!rs.isAfterLast()) {
out.write("没有数据");
}
else {
while(!rs.isLast())
{
rs.next();
strTacticText=rs.getString("TacticText");
out.write("有数据");
}
}
%>
apache tomcat common\lib里有sqljdbc.jar
报错:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Exception in JSP: /rvis/test.jsp:5
2: <%@page language="java" import="java.sql.*" %>
3: <%
4: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
5: String sConn="jdbc:sqlserver://192.168.20.88:1433;DatabaseName=RVIS";
6: Connection conn = DriverManager.getConnection( sConn,"sa","mssql" );
7: Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
8: request.setCharacterEncoding("UTF-8");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
org.apache.jsp.rvis.test_jsp._jspService(org.apache.jsp.rvis.test_jsp:111)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)