?? 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 + -