📄 associateamendrun.jsp
字号:
<%--
模块名称：合作伙伴
模块功能：合作伙伴修改
版 本：V1.0
著 作 人：蔡静
著作日期：2001-11-06
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ 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 partner_id, partner_name, linkman, telephone, mobilephone;
String email, address, web_address, spec_character, coop_events;
partner_id = request.getParameter("partner_id");
partner_name = es.getStr(request.getParameter("partner_name"));
linkman = request.getParameter("linkman");
telephone = request.getParameter("telephone");
mobilephone = request.getParameter("mobilephone");
email = request.getParameter("email");
address = request.getParameter("address");
web_address = request.getParameter("web_address");
spec_character = request.getParameter("spec_character");
coop_events = request.getParameter("coop_events");
String sql = "update t_partner set partner_name='" + partner_name + "'";
if (linkman!=null)
sql = sql + ",linkman='" + es.getStr(linkman) + "'";
else
sql = sql + ",linkman=null";
if (telephone!=null)
sql = sql + ",telephone='" + es.getStr(telephone) + "'";
else
sql = sql + ",telephone=null";
if (mobilephone!=null)
sql = sql + ",mobilephone='" + es.getStr(mobilephone) + "'";
else
sql = sql + ",mobilephone=null";
if ((email!=null) && (!email.equals("")))
sql = sql + ",email='" + email + "'";
else
sql = sql + ",email=null";
if (address!=null)
sql = sql + ",address='" + es.getStr(address) + "'";
else
sql = sql + ",address=null";
if (web_address!=null)
sql = sql + ",web_address='" + es.getStr(web_address) + "'";
else
sql = sql + ",web_address=null";
if (spec_character!=null)
sql = sql + ",spec_character='" + es.getStr(spec_character) + "'";
else
sql = sql + ",spec_character=null";
if (coop_events!=null)
sql = sql + ",coop_events='" + es.getStr(coop_events) + "'";
else
sql = sql + ",coop_events=null";
sql = sql + " where partner_id='" + partner_id + "'";
int num = db.executeUpdate(sql);
if (num <= 0) {%>
<script language="javascript">
alert("修改失败！");
</script>
<%}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<script language="javascript">
location = "Associate.jsp";
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -