📄 baddebtsenteramendrun.jsp
字号:
<%--
模块名称：费用管理
模块功能：坏账登记修改
版 本：V1.0
著 作 人：蔡静
著作日期：2001-10-23
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
String bad_debt_id, debt_count, customer_id, lawyer, case_id, begin_date;
String case_reason, bad_debt_reason, enter_people, enter_date;
bad_debt_id = request.getParameter("bad_debt_id");
debt_count = request.getParameter("debt_count");
debt_count = new String(debt_count.getBytes("ISO8859_1"));
customer_id = request.getParameter("customer_id");
lawyer = request.getParameter("lawyer");
case_id = request.getParameter("case_id");
begin_date = request.getParameter("begin_date");
case_reason = request.getParameter("case_reason");
case_reason = new String(case_reason.getBytes("ISO8859_1"));
bad_debt_reason = request.getParameter("bad_debt_reason");
bad_debt_reason = new String(bad_debt_reason.getBytes("ISO8859_1"));
enter_people = request.getParameter("enter_people");
enter_people = new String(enter_people.getBytes("ISO8859_1"));
enter_date = request.getParameter("enter_date");
String sql = "update t_baddebt set debt_count='" + debt_count + "'";
if (customer_id!=null)
sql = sql + ",customer_id='" + customer_id + "'";
else
sql = sql + ",customer_id=null";
if (lawyer!=null)
sql = sql + ",lawyer='" + lawyer + "'";
else
sql = sql + ",lawyer=null";
if (case_id!=null)
sql = sql + ",case_id='" + case_id + "'";
else
sql = sql + ",case_id=null";
if ((begin_date!=null) && (!begin_date.equals("")))
sql = sql + ",begin_date='" + begin_date + "'";
else
sql = sql + ",begin_date=null";
if (case_reason!=null)
sql = sql + ",case_reason='" + case_reason + "'";
else
sql = sql + ",case_reason=null";
if (bad_debt_reason!=null)
sql = sql + ",bad_debt_reason='" + bad_debt_reason + "'";
else
sql = sql + ",bad_debt_reason=null";
if (enter_people!=null)
sql = sql + ",enter_people='" + enter_people + "'";
else
sql = sql + ",enter_people=null";
if ((enter_date!=null) && (!enter_date.equals("")))
sql = sql + ",enter_date='" + enter_date + "'";
else
sql = sql + ",enter_date=null";
sql = sql + " where bad_debt_id='" + bad_debt_id + "'";
int num = db.executeUpdate(sql);
if (num <= 0) {%>
<script language="javascript">
alert("修改失败！");
</script>
<%}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<script language="javascript">
location = "BadDebtsEnter.jsp";
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -