📄 da_user.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>会员页面</title>
<link href="../style1.css" rel="stylesheet" type="text/css" />
</head>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="../inc/format.jsp"%>
<body>
<%
//删除操作
String delUserid=request.getParameter("delUserid");
if(delUserid!=null)
{
stmt.executeUpdate("delete from member where user_id="+delUserid);
}
//保存修改操作
if(request.getParameter("Submit")!=null)
{
//out.print("lkh");
String id=request.getParameter("id");
String name=Bytes(request.getParameter("name"));
String namec=Bytes(request.getParameter("namec"));
String tel=Bytes(request.getParameter("tel"));
String mail=Bytes(request.getParameter("mail"));
String adds=Bytes(request.getParameter("adds"));
sql="update member set user_name='"+name+"',";
sql+="user_namec='"+namec+"',";
sql+="user_tel='"+tel+"',";
sql+="user_mail='"+mail+"',";
sql+="user_adds='"+adds+"' where user_id="+id;
stmt.executeUpdate(sql);
out.print("<script>alert('保存成功!');window.location='da_user.jsp';</script>");
}
%>
<table width="588" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table23">
<tr>
<td background="../pic/Comments.jpg" height="64">
<table height="20" cellspacing="0" cellpadding="0" width="100%" border="0" ID="Table24">
<tr>
<td width="9%" height="38"></td>
<td height="38"><span class="CategoryTitleCn">会员管理</span> <span class="CategoryTitleEn">Management User</span> </td>
</tr>
</table></td>
</tr>
</table>
<br>
<table width="98%" border=0 align="center" cellpadding=0 cellspacing=1>
<tr bgcolor="#E6E6E6">
<th height="27" valign="middle">用户名</th>
<th valign="middle">真实姓名</th>
<th valign="middle">电话</th>
<th valign="middle">E-mail</th>
<th valign="middle">地址</th>
<th colspan="2" valign="middle">操 作</th>
</tr> <%sql="select * from member";
rs=dbBean.exeSQL(sql);
while(rs.next()){
String user_id=rs.getString("user_id");
%>
<tr valign="middle" bgcolor="#f8f8f8" height="25" >
<td width="112" height="18" bgcolor="#f8f8f8" ><div align="center"><%=rs.getString("user_name")%></a></div></td>
<td width="82" bgcolor="#f8f8f8" ><%=rs.getString("user_namec")%></td>
<td width="145" bgcolor="#f8f8f8" ><%=rs.getString("user_tel")%></td>
<td width="135" bgcolor="#f8f8f8" ><%=rs.getString("user_mail")%></td>
<td width="173" bgcolor="#f8f8f8" ><%=rs.getString("user_adds")%></td>
<td colspan="2" nowrap><div align="center"><a href="da_user.jsp?Userid=<%=user_id%>">[修 改] </a> | <a href="da_user.jsp?delUserid=<%=user_id%>">[删 除]</a></div> </td>
</tr>
<tr>
<td height=1 colspan="6" background="../image/dian.gif"><img src="../images/blank.gif" width=378 height=1></td>
<td width="67" background="../image/dian.gif"></td>
</tr>
<%}%></table>
<br>
<%
//修改操作
String Userid=request.getParameter("Userid");
if(Userid!=null)
{
sql="select * from member where user_id="+Userid;
rs=dbBean.exeSQL(sql);
while(rs.next()){
%>
<strong>用户信息</strong>
<form name="form1" method="post" action="">
<table width="98%" border=0 align="center" cellpadding=0 cellspacing=1>
<tr bgcolor="#E6E6E6">
<td height="27" valign="middle">用户名
<input name="name" type="text" id="name" value="<%=rs.getString("user_name")%>" size="15"></td>
<td valign="middle">真实姓名
<input name="namec" type="text" id="namec" value="<%=rs.getString("user_namec")%>" size="15"></td>
<td valign="middle"><input type="submit" name="Submit" value="保存修改"></td>
</tr>
<tr valign="middle" bgcolor="#f8f8f8" height="25" >
<td width="296" height="18" bgcolor="#f8f8f8" >电 话
<input name="tel" type="text" id="tel" value="<%=rs.getString("user_tel")%>" size="15"></td>
<td width="314" bgcolor="#f8f8f8" >E-Mail
<input name="mail" type="text" id="mail" value="<%=rs.getString("user_mail")%>" size="15"></td>
<td width="342" bgcolor="#f8f8f8" >地址
<input name="adds" type="text" id="adds" value="<%=rs.getString("user_adds")%>" size="20">
<input type="hidden" name="id" value="<%=rs.getString("user_id")%>"></td>
</tr>
</table>
</form>
<%}
}%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -