?? costenteramendrun.jsp
字號:
<%--
模塊名稱：費用管理
模塊功能：費用登記修改
版 本：V1.0
著 作 人：蔡靜
著作日期：2001-10-19
使用說明：
主要技術說明：
參考文獻：法律事務設計書
修改歷史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出處：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
String charge_id, charge_sum, case_id, case_reason, part_proportion, case_object;
String time_limit, charge_type, receive_time, charge_standard, discount;
String discount_person, charge_person, currency_kind, comment;
String charge_name = "", lawyer_id = "";
charge_id = request.getParameter("charge_id");
charge_sum = request.getParameter("charge_sum");
case_id = request.getParameter("case_id");
case_reason = request.getParameter("case_reason");
part_proportion = request.getParameter("part_proportion");
part_proportion = new String(part_proportion.getBytes("ISO8859_1"));
case_object = request.getParameter("case_object");
case_object = new String(case_object.getBytes("ISO8859_1"));
time_limit = request.getParameter("time_limit");
charge_type = request.getParameter("charge_type");
receive_time = request.getParameter("receive_time");
charge_standard = request.getParameter("charge_standard");
charge_standard = new String(charge_standard.getBytes("ISO8859_1"));
discount = request.getParameter("discount");
discount = new String(discount.getBytes("ISO8859_1"));
discount_person = request.getParameter("discount_person");
charge_person = request.getParameter("charge_person");
currency_kind = request.getParameter("currency_kind");
comment = request.getParameter("comment");
comment = new String(comment.getBytes("ISO8859_1"));
charge_name = request.getParameter("charge_name");
charge_name = new String(charge_name.getBytes("ISO8859_1"));
lawyer_id = request.getParameter("lawyer_id");
String sql = "update t_charge set charge_sum="+charge_sum;
if (case_id!=null)
sql = sql + ",case_id='" + case_id + "'";
else
sql = sql + ",case_id=null";
if (part_proportion!=null)
sql = sql + ",part_proportion='" + part_proportion + "'";
else
sql = sql + ",part_proportion=null";
if (case_object!=null)
sql = sql + ",case_object='" + case_object + "'";
else
sql = sql + ",case_object=null";
if ((time_limit!=null) && (!time_limit.equals("")))
sql = sql + ",time_limit='" + time_limit + "'";
else
sql = sql + ",time_limit=null";
if (charge_type!=null)
sql = sql + ",charge_type='" + charge_type + "'";
else
sql = sql + ",charge_type=null";
if ((receive_time!=null) && (!receive_time.equals("")))
sql = sql + ",receive_time='" + receive_time + "'";
else
sql = sql + ",receive_time=null";
if (charge_standard!=null)
sql = sql + ",charge_standard='" + charge_standard + "'";
else
sql = sql + ",charge_standard=null";
if ((discount!=null) && (!discount.equals("")))
sql = sql + ",discount='" + discount + "'";
else
sql = sql + ",discount=null";
if (discount_person!=null)
sql = sql + ",discount_person='" + discount_person + "'";
else
sql = sql + ",discount_person=null";
if (charge_person!=null)
sql = sql + ",charge_person='" + charge_person + "'";
else
sql = sql + ",charge_person=null";
if (currency_kind!=null)
sql = sql + ",currency_kind='" + currency_kind + "'";
else
sql = sql + ",currency_kind=null";
if (comment!=null)
sql = sql + ",comment='" + comment.trim() + "'";
else
sql = sql + ",comment=null";
if (charge_name!=null)
sql = sql + ",charge_name='" + charge_name.trim() + "'";
else
sql = sql + ",charge_name = null";
if (lawyer_id!=null)
sql = sql + ",employee_id='" + lawyer_id.trim() + "'";
else
sql = sql + ",employee_id = null";
sql = sql + " where charge_id='" + charge_id + "'";
int num = db.executeUpdate(sql);
if (num <= 0) {%>
<script language="javascript">
alert("修改失敗！");
</script>
<%}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<script language="javascript">
location = "CostEnter.jsp";
</script>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -