急!!求救!!
下面的代码是老是发生NullPointerException错误,可是我查了半天没看出来,哪位能帮我看看啊
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.util.*" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="dao.ConnectToDB" %>
<%!
java.sql.Statement stmt;
Connection conn;
ResultSet rst;
%>
<%
String hid = request.getParameter("dosubmit");
ConnectToDB db = new ConnectToDB();
conn = db.conn;
if(hid != null) {
util.ToChinese tc = new util.ToChinese();
String dID = request.getParameter("deptDraftID");
String cID = request.getParameter("comPlanDraftID");
String taskName = request.getParameter("taskName");
String taskContent = request.getParameter("taskContent");
if(taskContent == null){
taskContent = "";
}
String deptID = request.getParameter("deptID");
String startDate = request.getParameter("startDate");
String completeDate = request.getParameter("completeDate");
String support = (session.getAttribute("data").toString());
String c = "";
if(support != null){
String a = support.substring(1,(support.length()-1));
String[] b = a.split(",");
for(int i = 0; i < b.length; i++){
if(!(b[i].trim()).endsWith("=")){
c = c + b[i].trim()+",";
}
}
}
if(support == null){
support = "";
}
String sql = "update PSS_deptDraftPlan set comPlanDraftID = '"+cID+"',taskName = '"+tc.changeCH(taskName)+"',taskContent = '"+tc.changeCH(taskContent)+"',deptID = '"+deptID+"',startDate = '"+startDate+"',completeDate = '"+completeDate+"',support = '"+c+"' where deptDraftID = '"+dID+"'";
try{
stmt = conn.createStatement();
stmt.executeUpdate(sql);
if(stmt != null){
stmt.close();}
if(conn != null){
conn.close();}
if(session.getAttribute("data") != null){
session.removeAttribute("data");
}
if(session.getAttribute("id") != null){
session.removeAttribute("id");
}
response.sendRedirect("./DeptDeptPlanDraft.jsp");
}catch(Exception e){
e.printStackTrace();
}
}else {
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<LINK rel="stylesheet" href="css\bbs.css" type="text/css">
<html>
<script type="text/javascript" src="js\calendar.js"></script>
<script language="javascript">
var CalendarWebControl = new atCalendarControl();
</script>
<script>
function dopost(){
if(document.form1.taskName.value==""){
alert("任务名称不能为空!");
}else{
form1.submit()
}
}
</script>
<body>
<center>
<FONT face="隶书" color="blue" size="5">部门计划草案详细信息</FONT><br>
<hr size="2" color="green" width="100%"><br>
</center>
<%
String ID = request.getParameter("id");
try{
stmt = conn.createStatement();
rst = stmt.executeQuery("select * from PSS_deptDraftPlan where deptDraftID = '"+ ID +"'");
if(rst.next()){ %>
<center>
<form action="DeptDeptDraftEdit.jsp" method="post" name="form1">
<table align="center" border="1" class="a3" width="100%">
<%
try{
Statement stmt2 = conn.createStatement();
ResultSet rst2 = stmt2.executeQuery("select * from pss_complandraft where isPass = '1' and complandraftid in (select complanID from Pss_Complan where isDone = '2' and isDelete = '2') and isDelete = '2'");
%>
<tr>
<td>部门草案ID</td>
<td><input type="text" value="<%=rst.getString("deptDraftID")%>" readonly="readonly" name="deptDraftID"></td>
</tr>
<tr>
<td>公司计划草案名称</td>
<td><select name="comPlanDraftID">
<%while(rst2.next()){ %>
<option value="<%=rst2.getString("comPlanDraftID")%>"><%=rst2.getString("taskName")%></option>
<%}%>
</select></td>
</tr>
<tr>
<td>任务名称</td>
<td><input type="text" value="<%=rst.getString("taskName")%>" name="taskName"></td>
</tr>
<tr>
<td>部门ID</td>
<td><input type="text" value="<%=rst.getString("deptID")%>" name="deptID" readonly></td>
</tr>
<tr>
<td>任务开始时间</td>
<td><input type="text" value="<%
if(rst.getString("startDate")==null){
out.println("");
}else{
out.println(rst.getString("startDate"));
}%>" name="startDate" readonly onClick="CalendarWebControl.show(this,this.value)"></td>
</tr>
<tr>
<td>要求完成时间</td>
<td><input type="text" value="<%
if(rst.getString("completeDate")==null){
out.println("");
}else{
out.println(rst.getString("completeDate"));
}%>" name="completeDate" readonly onClick="CalendarWebControl.show(this,this.value)"></td>
</tr>
<tr>
<td>工作内容</td>
<td>
<textarea cols="80" rows="8" name="taskContent">
<%if(rst.getString("taskContent")==null){
out.print("");
}else{
out.print(rst.getString("taskContent"));
}%>
</textarea>
</td>
</tr>
<tr>
<td>请求支援</td><td><input type="button" value="请求支援" onclick="location.href('./DeptEditSupport.jsp?id=<%=ID%>')"></td></tr>
<%
if(rst2 != null){
rst2.close();}
if(stmt2 != null){
stmt2.close();}
}catch(Exception e){
e.printStackTrace();
}%>
</table>
<input type="button" value="提 交" onclick="dopost()">
<input type="button" value="返回上一页" onclick="history.back()">
<input type="hidden" name="dosubmit" value="true">
</form>
</center>
<% }else{
out.println("找不到对应的记录!");
}
if(rst != null){
rst.close();}
if(stmt != null){
stmt.close();}
if(conn != null){
conn.close();}
} catch(SQLException e){
e.printStackTrace();
}
%>
</body>
</html>
<%}%>
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.util.*" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="dao.ConnectToDB" %>
<%!
java.sql.Statement stmt;
Connection conn;
ResultSet rst;
%>
<%
String hid = request.getParameter("dosubmit");
ConnectToDB db = new ConnectToDB();
conn = db.conn;
if(hid != null) {
util.ToChinese tc = new util.ToChinese();
String dID = request.getParameter("deptDraftID");
String cID = request.getParameter("comPlanDraftID");
String taskName = request.getParameter("taskName");
String taskContent = request.getParameter("taskContent");
if(taskContent == null){
taskContent = "";
}
String deptID = request.getParameter("deptID");
String startDate = request.getParameter("startDate");
String completeDate = request.getParameter("completeDate");
String support = (session.getAttribute("data").toString());
String c = "";
if(support != null){
String a = support.substring(1,(support.length()-1));
String[] b = a.split(",");
for(int i = 0; i < b.length; i++){
if(!(b[i].trim()).endsWith("=")){
c = c + b[i].trim()+",";
}
}
}
if(support == null){
support = "";
}
String sql = "update PSS_deptDraftPlan set comPlanDraftID = '"+cID+"',taskName = '"+tc.changeCH(taskName)+"',taskContent = '"+tc.changeCH(taskContent)+"',deptID = '"+deptID+"',startDate = '"+startDate+"',completeDate = '"+completeDate+"',support = '"+c+"' where deptDraftID = '"+dID+"'";
try{
stmt = conn.createStatement();
stmt.executeUpdate(sql);
if(stmt != null){
stmt.close();}
if(conn != null){
conn.close();}
if(session.getAttribute("data") != null){
session.removeAttribute("data");
}
if(session.getAttribute("id") != null){
session.removeAttribute("id");
}
response.sendRedirect("./DeptDeptPlanDraft.jsp");
}catch(Exception e){
e.printStackTrace();
}
}else {
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<LINK rel="stylesheet" href="css\bbs.css" type="text/css">
<html>
<script type="text/javascript" src="js\calendar.js"></script>
<script language="javascript">
var CalendarWebControl = new atCalendarControl();
</script>
<script>
function dopost(){
if(document.form1.taskName.value==""){
alert("任务名称不能为空!");
}else{
form1.submit()
}
}
</script>
<body>
<center>
<FONT face="隶书" color="blue" size="5">部门计划草案详细信息</FONT><br>
<hr size="2" color="green" width="100%"><br>
</center>
<%
String ID = request.getParameter("id");
try{
stmt = conn.createStatement();
rst = stmt.executeQuery("select * from PSS_deptDraftPlan where deptDraftID = '"+ ID +"'");
if(rst.next()){ %>
<center>
<form action="DeptDeptDraftEdit.jsp" method="post" name="form1">
<table align="center" border="1" class="a3" width="100%">
<%
try{
Statement stmt2 = conn.createStatement();
ResultSet rst2 = stmt2.executeQuery("select * from pss_complandraft where isPass = '1' and complandraftid in (select complanID from Pss_Complan where isDone = '2' and isDelete = '2') and isDelete = '2'");
%>
<tr>
<td>部门草案ID</td>
<td><input type="text" value="<%=rst.getString("deptDraftID")%>" readonly="readonly" name="deptDraftID"></td>
</tr>
<tr>
<td>公司计划草案名称</td>
<td><select name="comPlanDraftID">
<%while(rst2.next()){ %>
<option value="<%=rst2.getString("comPlanDraftID")%>"><%=rst2.getString("taskName")%></option>
<%}%>
</select></td>
</tr>
<tr>
<td>任务名称</td>
<td><input type="text" value="<%=rst.getString("taskName")%>" name="taskName"></td>
</tr>
<tr>
<td>部门ID</td>
<td><input type="text" value="<%=rst.getString("deptID")%>" name="deptID" readonly></td>
</tr>
<tr>
<td>任务开始时间</td>
<td><input type="text" value="<%
if(rst.getString("startDate")==null){
out.println("");
}else{
out.println(rst.getString("startDate"));
}%>" name="startDate" readonly onClick="CalendarWebControl.show(this,this.value)"></td>
</tr>
<tr>
<td>要求完成时间</td>
<td><input type="text" value="<%
if(rst.getString("completeDate")==null){
out.println("");
}else{
out.println(rst.getString("completeDate"));
}%>" name="completeDate" readonly onClick="CalendarWebControl.show(this,this.value)"></td>
</tr>
<tr>
<td>工作内容</td>
<td>
<textarea cols="80" rows="8" name="taskContent">
<%if(rst.getString("taskContent")==null){
out.print("");
}else{
out.print(rst.getString("taskContent"));
}%>
</textarea>
</td>
</tr>
<tr>
<td>请求支援</td><td><input type="button" value="请求支援" onclick="location.href('./DeptEditSupport.jsp?id=<%=ID%>')"></td></tr>
<%
if(rst2 != null){
rst2.close();}
if(stmt2 != null){
stmt2.close();}
}catch(Exception e){
e.printStackTrace();
}%>
</table>
<input type="button" value="提 交" onclick="dopost()">
<input type="button" value="返回上一页" onclick="history.back()">
<input type="hidden" name="dosubmit" value="true">
</form>
</center>
<% }else{
out.println("找不到对应的记录!");
}
if(rst != null){
rst.close();}
if(stmt != null){
stmt.close();}
if(conn != null){
conn.close();}
} catch(SQLException e){
e.printStackTrace();
}
%>
</body>
</html>
<%}%>
...全文
相关推荐
js中!和!!的区别与用法
`,即`!!`,其作用就有所不同了。`!!`通常被用来进行严格布尔值转换,它的主要用途是将任何值转换为`true`或`false`,而不考虑其原始数据类型。
老人跌倒检测与求救系统
老人跌倒检测与求救系统是一种利用现代信息技术,特别是运动传感器技术,为老年人提供安全监护的智能系统。
Android-一键求救app
**事件监听**:为求救按钮添加点击事件监听器,一旦用户按下按钮,就能触发求救流程。3.
电信设备-具有求救功能的无线通讯装置及其求救方法.zip
**紧急求救系统**:这种装置可能内置了紧急求救系统,一旦用户遭遇危险情况,可以通过预设的快捷方式(如一键报警、语音识别等)触发求救信号。
电信设备-具有紧急求救功能的移动终端及其紧急求救方法.zip
自动求救信息:在用户失去意识或无法手动触发求救时,设备可通过传感器检测异常情况(如剧烈碰撞、摔倒等),自动触发求救流程。三、紧急求救方法1.


Web 开发
