?? modify.jsp
字號:
?<%@ page contentType="text/html;charset=utf-8"%>
<%@include file="conn.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="description" content="description"/>
<meta name="keywords" content="keywords"/>
<meta name="author" content="author"/>
<link rel="stylesheet" type="text/css" href="default.css" media="screen"/>
<title>Summer Breeze</title>
</head>
<body>
<div class="header">
<h1>欢迎来到我的通讯录</h1>
</div>
<div class="navigation">
<a href="all.jsp">主 頁</a>
<a href="search.jsp">查 詢</a>
<a href="list.jsp">列 表</a>
<a href="new.jsp">新 增</a>
<a href="index.jsp">退 出</a>
<div class="clearer"><span></span></div>
</div>
<div class="container">
<div class="content">
<h1><cite>修改通訊錄記錄</cite></h1>
<%if (request.getParameter("Submit")!=null)
{
String mname=new String(request.getParameter("mname").getBytes("ISO8859_1"),"utf-8");
String sql="update pengyou set ming='"+mname+"',xingbie="+request.getParameter("xingbie")+",QQ='"+request.getParameter("QQ")+"',tel='"+request.getParameter("TEL")+"',mob='"+request.getParameter("MOD")+"' where id="+request.getParameter("id");
stmt.executeUpdate(sql);
%>
<script language="javascript">
alert("修改成功");
window.navigate("list.jsp");
</script>
<%
return;
}
else
{
String sql="select * from pengyou where id="+request.getParameter("id");
rs=stmt.executeQuery(sql);
rs.next();%>
<table width="98%" border="0" cellpadding="0" cellspacing="1">
<input name="id" type="hidden" id="id" value="<%=rs.getInt("id")%>">
<form name="form1" method="post" action=""><tr >
<td align="right" valign="middle">姓名：</td>
<td align="left" valign="middle">
<input name="mname" type="text" id="mname" value="<%=rs.getString("ming")%>">
</td>
</tr>
<tr ><%int xingbie=rs.getInt("xingbie");%>
<td align="right" valign="middle">性別：</td>
<td align="left" valign="middle"><input type="radio" name="xingbie" value="1" <%if (xingbie==1)
{
out.print("checked");
}%>>
男
<input type="radio" name="xingbie" value="2" <%if (xingbie==2)
{
out.print("checked");
}%>>
女</td>
</tr>
<tr >
<td align="right" valign="middle">QQ：</td>
<td align="left" valign="middle"><input name="QQ" type="text" id="QQ" value="<%=rs.getString("QQ")%>"></td>
</tr>
<tr >
<td align="right" valign="middle">家庭電話：</td>
<td align="left" valign="middle"><input name="TEL" type="text" id="TEL" value="<%=rs.getString("tel")%>"></td>
</tr>
<tr >
<td align="right" valign="middle">手機：</td>
<td align="left" valign="middle"><input name="MOD" type="text" id="MOD" value="<%=rs.getString("mob")%>"></td>
</tr>
<tr align="center" >
<td colspan="2" valign="middle"><input type="submit" name="Submit" value="提交"></td>
</tr>
<tr >
<td align="right" valign="middle"> </td>
<td align="left" valign="middle"> </td>
</tr> </form>
</table>
<%}%>
<% stmt.close();
conn.close();
%>
<div class="divider"></div>
</div>
<div class="footer">
© 2006 <a href="index.jsp">Website</a>. Valid <a href="http://jigsaw.w3.org/css-validator/check/referer">CSS</a> & <a href="http://validator.w3.org/check?uri=referer">XHTML</a>. Design by <a href="http://arcsin.se">Arcsin</a>
</div>
</div>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -