?? zsedit.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標(biāo)題文檔</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
</head>
<body>
<jsp:useBean id="ConBean" scope="session"
class="com.bitc.ch13.DBCon"/>
<%
String id = request.getParameter("id");
Connection con = ConBean.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM vidc where id ='"+id+"'");
while(rs.next()){
%>
<form action="zsv.jsp" method="post" name=frmLogin>
<table width="816" height="245" border="1" bordercolor="#009999">
<tr>
<td width="98" height="37"> <input name="mc" type="text" id="mc" value="<%=rs.getString("mc")%>" size="10"></td>
<td width="121">價格:
<input name="pric" type="text" id="pric" value="<%=rs.getInt("pric")%>" size="8"></td>
<td width="102">郵局:
<input name="e" type="text" id="e" value="<%=rs.getString("m")%>" size="6"></td>
<td width="63"><select name="s" id="s">
<%String k = rs.getString("s");out.println("<option value="+k+" selected>"+k+"</option><option value=MSSQL>MSSQL</option><option value=MYSQL>MYSQL</option>");%>
</select></td>
<td width="106">FTP:
<input name="ftp" type="text" id="ftp" value="<%=rs.getString("ftp")%>" size="8"></td>
<td width="129">FTP密碼:
<input name="ftppwd" type="text" id="ftppwd" value="<%=rs.getString("ftppwd")%>" size="8"></td>
<td width="151">域名: <input name="www" type="text" id="www" value="<%=rs.getString("www")%>" size="12"></td>
</tr>
<tr bgcolor="#FFFFCC">
<td height="49" colspan="7">聯(lián)系人資料:</td>
</tr>
<tr>
<td height="32">姓名:
<input name="lxr" type="text" id="lxr" value="<%=rs.getString("lxr")%>" size="6"></td>
<td>電話:<input name="dh" type="text" id="dh" value="<%=rs.getString("dh")%>" size="10"></td>
<td>QQ:
<%String qq = rs.getString("qq");out.println("<input name=qq type=text value="+qq+" size=8>");%></td>
<td colspan="3">地址:<input name="dz" type="text" id="dz" value="<%=rs.getString("dz")%>" size="30"></td>
<td>E-Mail:<input name="sfz" type="text" id="sfz" value="<%=rs.getString("sfz")%>" size="12"></td>
</tr>
<tr>
<td height="73">備注：</td>
<td colspan="5"><textarea name="bz" cols="60" rows="6" id="bz"><%=rs.getString("beizhu")%></textarea></td>
<td><p>開始日期：
<input name="ks" type="text" id="ks" value="<%=rs.getString("riqi")%>" size="20">
</p>
<p>結(jié)束日期：
<input name="js" type="text" id="js" value="<%=rs.getString("daoqiriqi")%>" size="20">
</p></td>
</tr>
<tr>
<td height="5"> <input type="hidden" name="id" value="<%=id%>"></td><td><input type="button" name="Submit2" value="刪 除" onClick="del(<%=id%>)"></td>
<td><a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin=<%=qq%>&Site=深圳萬網(wǎng)&Menu=yes><img border="0" src=http://wpa.qq.com/pa?p=1:<%=qq%>:1></a></td>
<td colspan="3"><input type="button" name="Submit3" value="轉(zhuǎn) 正" onClick="r(<%=id%>)"></td>
<td><input type="submit" name="Submit" value="保 存"></td>
</tr>
</table>
</form>
<%
}
rs.close();
stmt.close();
ConBean.close();
%>
<script language="javascript">
function del(id)
{
myvalue=confirm("該操作不可恢復(fù),確認(rèn)要刪除嗎？");
if (myvalue== true)
window.location ="s.jsp?id="+id
}
</script>
<script language="javascript">
function r(id)
{
myvalue=confirm("確認(rèn)該用戶已經(jīng)打款了嗎？");
if (myvalue== true)
window.location ="z.jsp?id="+id
}
</script>
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -