📄 clientamendrun.jsp
字号:
<%--
模块名称：客户管理
模块功能：客户修改
版 本：V1.0
著 作 人：蔡静
著作日期：2001-10-08
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
ExtendString es = new ExtendString();
String customer_id, link_man, customer_name, enter_date, telephone, mobile_telephone;
String fax, email, customer_type, lawyer_id, address, customer_introduce;
customer_id = request.getParameter("customer_id");
link_man = request.getParameter("link_man");
customer_name = es.getStr(request.getParameter("customer_name"));
enter_date = request.getParameter("enter_date");
telephone = request.getParameter("telephone");
mobile_telephone = request.getParameter("mobile_telephone");
fax = request.getParameter("fax");
email = request.getParameter("email");
customer_type = request.getParameter("customer_type");
lawyer_id = request.getParameter("lawyer_id");
address = request.getParameter("address");
customer_introduce = request.getParameter("customer_introduce");
String sql = "update t_customer set customer_name='"+customer_name+"'";
if (link_man!=null)
sql = sql + ",link_man='" + es.getStr(link_man) + "'";
else
sql = sql + ",link_man=null";
if ((enter_date!=null) && (!enter_date.equals("")))
sql = sql + ",enter_date='" + enter_date + "'";
else
sql = sql + ",enter_date=null";
if (telephone!=null)
sql = sql + ",telephone='" + telephone + "'";
else
sql = sql + ",telephone=null";
if (mobile_telephone!=null)
sql = sql + ",mobile_telephone='" + mobile_telephone + "'";
else
sql = sql + ",mobile_telephone=null";
if (fax!=null)
sql = sql + ",fax='" + fax + "'";
else
sql = sql + ",fax=null";
if (email!=null)
sql = sql + ",email='" + email + "'";
else
sql = sql + ",email=null";
if (customer_type!=null)
sql = sql + ",customer_type='" + customer_type + "'";
else
sql = sql + ",customer_type=null";
if (lawyer_id!=null)
sql = sql + ",lawyer_id='" + lawyer_id + "'";
else
sql = sql + ",lawyer_id=null";
if (address!=null)
sql = sql + ",address='" + es.getStr(address) + "'";
else
sql = sql + ",address=null";
if (customer_introduce!=null)
sql = sql + ",customer_introduce='" + es.getStr(customer_introduce.trim()) + "'";
else
sql = sql + ",customer_introduce=null";
sql = sql + " where customer_id='" + customer_id + "'";
int num = db.executeUpdate(sql);
if (num <= 0) {
}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<script language="javascript">
alert("修改成功！");
location = "Client.jsp";
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -