📄 stayarchivesamendrun.jsp
字号:
<%--
模块名称：待归档案件管理
模块功能：修改run
版 本：V1.0
著 作 人：SIMM
著作日期：2001-10-26
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page language="java" import="java.util.Date,java.util.Locale,java.text.DateFormat"%>
<%@ page import="java.io.*,java.sql.*" contentType= "text/html; charset=gb2312" %>
<%@ page import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
GetID gid = new GetID(); //系统ID值
String caseID = "",
caseReason = "",
archiveID = "",
archiveDate = "",
archivePerson = "",
keepYears = "",
caseRemark = "",
caseAttribute = "",
lawyer = "",
customer = "",
beginDate = "",
endDate = "",
court = "",
judgeLevel = "",
judgeResult = "";
//判断是否获取新的档案编码 0--没有 1--有 2--错误
String isGetNewID = "2";
isGetNewID = request.getParameter("isGetNewID");
//修改案件信息的归档信息内容
caseID = request.getParameter("txtCaseID");
archiveID = request.getParameter("txtArchiveID");
archivePerson = request.getParameter("txtArchivePerson");
keepYears = request.getParameter("txtKeepYears");
caseRemark = request.getParameter("txtCaseRemark");
String sql = "update t_caseinfo set archive_id = '" + archiveID;
if(archivePerson != null)
sql = sql + "', archive_person = '" + archivePerson;
if(keepYears != null)
sql = sql + "', keep_years = '" + keepYears;
if(caseRemark == null)
sql = sql + "', case_remark = '" + caseRemark;
sql = sql + "' where case_id = '" + caseID + "'";
int num = db.executeUpdate(sql);
if (num <= 0)
{ %>
<script language=JavaScript>
out.println("修改失败！");
self.location = "StayArchives.jsp";
</script>
<%}else
{
if(isGetNewID.equals("1"))
gid.setIDNumber("archive_id", gid.getIDNumber("archive_id")+1);
%>
<script language=JavaScript>
self.location = "StayArchives.jsp";
</script>
<%
}%>
<html>
<head>
<title>修改成功</title>
</head>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -