📄 consultationamendrun.jsp
字号:
<%--
模块名称：法 律 咨 询
模块功能：修改执行
版 本：V1.0
著 作 人：SIMM
著作日期：2001-10-31
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
//---------------------------------------
//BEGIN---信息保存处理部分
//-----------------------------------------
String caseID = "",
caseReason = "",
beginDate = "",
lawyer = "",
customer = "",
subType = "",
opinion = "",
mainContent = "",
referForeign = "",
charged = "",
noPayReason = "";
caseID = request.getParameter("txtCaseID");
caseReason = request.getParameter("txtCaseReason");
//中文处理
caseReason = new String(caseReason.getBytes("ISO8859_1"));
beginDate = request.getParameter("txtBeginDate");
lawyer = request.getParameter("txtLawyer");
subType = request.getParameter("txtSubType");
opinion = request.getParameter("txtOpinion");
//中文处理
opinion = new String(opinion.getBytes("ISO8859_1"));
mainContent = request.getParameter("txtMainContent");
mainContent = new String(mainContent.getBytes("ISO8859_1"));
referForeign = request.getParameter("txtReferForeign");
charged = request.getParameter("txtCharged");
noPayReason = request.getParameter("txtNoPayReason");
//中文处理
noPayReason = new String(noPayReason.getBytes("ISO8859_1"));
customer = request.getParameter("txtCustomer");
String sql = "update t_caseinfo set case_reason='"+caseReason;
sql = sql + "',begin_date='" + beginDate;
sql = sql + "',employee_id='" + lawyer;
sql = sql + "',refer_foreign = '" + referForeign;
sql = sql + "',charged = '" + charged;
sql = sql + "',no_pay_reason = '" + noPayReason;
sql = sql + "',customer_id = '" + customer;
sql = sql + "' where case_id='" + caseID + "'";
int num = db.executeUpdate(sql);
//-------------------------------
//update T_NONCOURT TABLE CONTENT
/**/
if (num > 0)
{
sql = " update t_noncourt set ";
sql = sql + " main_content='" + mainContent;
sql = sql + "', sub_type='" + subType;
sql = sql + "', opinion_to_customer='" + opinion;
sql = sql + "' where case_id = '" + caseID + "'";
int num1 = db.executeUpdate(sql);
}
//---------------------------------------
//END---信息保存处理部分
//-----------------------------------------
if (num <= 0)
{%>
<script language=JavaScript>
alert("修改失败！");
self.location="Consultation.jsp"
</script>
<% }else
{%>
<script language=JavaScript>
self.location="Consultation.jsp"
</script>
<% }%>
%>
<html>
<head>
<title>修改d成功</title>
</head>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -