啊请问jsp有关问题
高手救命啊请教jsp问题。
HTTP Status 500 - java.lang.NullPointerException
--------------------------------------------------------------------------------
type Exception report
message java.lang.NullPointerException
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause
java.lang.NullPointerException
org.apache.jsp.index_jsp._jspService(index_jsp.java:149)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.47 logs.
以上为打开的报错内容
在服务器上可以使用,我把SQL库完全备份到这台机器,源码也发在这台机器上,一样的环境,为啥不行呢?
另外问一下,SQL链接的用户和密码,哪张表在TOMCAT的哪里?
------解决方案--------------------
HTTP Status 500 - java.lang.NullPointerException
--------------------------------------------------------------------------------
type Exception report
message java.lang.NullPointerException
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause
java.lang.NullPointerException
org.apache.jsp.index_jsp._jspService(index_jsp.java:149)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.47 logs.
以上为打开的报错内容
在服务器上可以使用,我把SQL库完全备份到这台机器,源码也发在这台机器上,一样的环境,为啥不行呢?
另外问一下,SQL链接的用户和密码,哪张表在TOMCAT的哪里?
------解决方案--------------------
<%@ page contentType="text/html; charset=gb2312" errorPage="" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<jsp:useBean id="Databbb" scope="page" class="com.db.CGlobalFunction" />
<%Databbb.getConn(config);%>
<%
ResultSet rs;
String mysql,sYear="",aaid="",sName="";
String txtsrid="",txtname="";
txtsrid = (String)request.getParameter("txtsrid");
txtname = Databbb.toChinese(request.getParameter("txtname"));
String txtsrid1 = (String)request.getParameter("txtsrid1");
String txtname1 = (String)request.getParameter("txtname1");
if (txtsrid==null){ if(txtsrid1==null) {aaid = "";} else {aaid=txtsrid1;}} else {aaid = txtsrid;}
if (txtname==null){ if(txtname1==null) {aaname= "";} else {sName=txtname1;}} else {aaname= txtname;}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<link href="css/xmwuye.css" rel="stylesheet" type="text/css">
<link href="../css/xmwuye.css" rel="stylesheet" type="text/css">
</head>
<body>
<form name="studform" method="post" action="" autocomplete="off">
<table width="70%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#F2F8FF">
<td width="12%"><strong>号码:</strong></td>
<td width="35%"><input name="txtsrid" type="text" id="txtsrid" value="<%=aaid%>" size="19"></td>
<td width="12%"><strong>新号码:</strong></td>
<td width="28%"><input name="txtname" type="text" id="txtname" value="<%=sName%>" size="19"></td>
<td width="13%"><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
<p> </p>
<p>
<%
mysql = " select b.idname,b.srid,b.stdname,case b.sex when '1' then '男' when '2' then '女' end ";