📄 do_update_d.jsp
字号:
<html>
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>修改片区信息</title>
</head>
<jsp:useBean id="db" scope="page" class="sale.dbBean" />
<body>
<p align="center"><font size="7" color="#000080">销售管理信息系统</font></p>
<hr>
<%
String id=new String();
id=(String)session.getAttribute("id");
if(id==null)
{
response.sendRedirect("index.htm");
}
%>
<%
String name=new String(request.getParameter("name").getBytes("8859_1"),"gb2312");
String address=new String(request.getParameter("address").getBytes("8859_1"),"gb2312");
String postcode=new String(request.getParameter("postcode"));
String d_id=new String(request.getParameter("d_id"));
String tel=new String(request.getParameter("tel"));
String tax=new String(request.getParameter("tax"));
String sql="update district set name='"+name+"',address='"+address+"',postcode='"+postcode+"',tel='"+tel+"',tax='"+tax+"' where id='"+d_id+"'";
db.executeInsert(sql);
%>
<p align="center">您已经成功修改片区信息！</p>
<div align="center">
<table border="0" width="60%">
<tr>
<td width="50%">
<p align="center">片区编号</td>
<td width="50%">
<%=d_id%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">地址</td>
<td width="50%">
<%=address%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">邮编</td>
<td width="50%">
<%=postcode%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">经理姓名</td>
<td width="50%">
<%=name%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">电话</td>
<td width="50%">
<%=tel%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">传真</td>
<td width="50%">
<%=tax%>
</td>
</tr>
</table>
</div>
<form method="POST" action="district.jsp">
<p align="center">
<input type="submit" value="返回">
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -