?? show.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>無標題文檔</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style></head>
<body>
<form name="frmLogin" method="post" action="host-z.jsp">
<table width="927" height="444" border="1" bordercolor="#009999">
<jsp:useBean id="ConBean" scope="session"
class="com.bitc.ch13.DBCon"/>
<%
String id = request.getParameter("id");
String lxr = "";
Connection con = ConBean.getConnection();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM jsp8_host where id ='"+id+"'");
while(rs.next()){
%>
<tr>
<td width="136" height="82" align="center" valign="middle"><%lxr = rs.getString("yh"); out.println(lxr);%><input type="hidden" name=yhs value=<%=lxr%>><input type="hidden" name=id value=<%=id%>></td>
<td width="127">類型:
<input name="lx" type="text" id="lx" value="<%=rs.getString("lx")%>" size="10"></td>
<td width="144">數據庫:<input name="sjk" type="text" id="sjk" value="<%=rs.getString("sjk")%>" size="10"></td>
<td width="165">容器:<input name="rq" type="text" id="rq" value="<%=rs.getString("rq")%>" size="15"></td>
<td width="169">FTP:<input name="ftpname" type="text" id="ftpname" value="<%=rs.getString("ftp")%>" size="15"></td>
<td width="146">FTP密碼:<input name="ftppwd" type="text" id="ftppwd" value="<%=rs.getString("ftppwd")%>" size="10"></td>
</tr>
<tr>
<td width="136" height="69">數據庫帳戶:<input name="sjkname" type="text" id="sjkname" value="<%=rs.getString("sqlname")%>" size="15"></td>
<td width="127">數據庫密碼:<input name="sjkpwd" type="text" id="sjkpwd" value="<%=rs.getString("sqlpwd")%>" size="15"></td>
<td width="144">郵局帳戶:<input name="mailname" type="text" id="mailname" value="<%=rs.getString("mailname")%>" size="15"></td>
<td width="165">郵局密碼:<input name="mailpwd" type="text" id="mailpwd" value="<%=rs.getString("mailpwd")%>" size="15"></td>
<td width="169">域名:<input name="cn" type="text" id="cn" value="<%=rs.getString("cn")%>" size="15"></td>
<td width="146">日期:<input name="riqi" type="text" id="riqi" value="<%=rs.getString("riqi")%>" size="15"></td>
</tr>
<%
}
rs.close();
ResultSet rsr = stmt.executeQuery("SELECT * FROM jsp8_user where user_name ='"+lxr+"'");
while(rsr.next()){
%>
<tr bgcolor="#FFFFCC">
<td height="42">企業郵局
<select name="maildx" id="maildx">
<option value="100M" selected>100M</option>
<option value="200M">200M</option>
<option value="300M">300M</option>
<option value="400M">400M</option>
<option value="500M">500M</option>
<option value="600M">600M</option>
<option value="700M">700M</option>
<option value="800M">800M</option>
<option value="900M">900M</option>
<option value="1000M">1000M</option>
<option value="其他">其他</option>
<option value="無限制">無限制</option>
</select> </td>
<td height="42">郵局用戶
<select name="mailyh" id="mailyh">
<option value="5用戶" selected>5用戶</option>
<option value="10用戶">10用戶</option>
<option value="15用戶">15用戶</option>
<option value="20用戶">20用戶</option>
<option value="30用戶">30用戶</option>
<option value="40用戶">40用戶</option>
<option value="50用戶">50用戶</option>
<option value="其他">其他</option>
</select></td>
<td height="42">數據庫空間
<select name="sjkdx" id="sjkdx">
<option value="100M" selected>100M</option>
<option value="200M">200M</option>
<option value="300M">300M</option>
<option value="400M">400M</option>
<option value="500M">500M</option>
<option value="600M">600M</option>
<option value="700M">700M</option>
<option value="800M">800M</option>
<option value="900M">900M</option>
<option value="1000M">1000M</option>
<option value="其他">其他</option>
<option value="無限制">無限制</option>
</select></td>
<td height="42">FTP:
<select name="ftp" id="ftp">
<option value="61.152.239.26">61.152.239.26</option>
<option value="219.150.217.90" selected>219.150.217.90</option>
</select></td>
<td height="42">WEB空間:
<input name="webdx" type="text" id="webdx" size="10"></td>
<td height="42">備案:
<select name="beian" id="beian">
<option value="未備案" selected>未備案</option>
<option value="已備案">已備案</option>
</select></td>
</tr>
<tr bgcolor="#FFFFCC">
<td height="30" colspan="6">聯系人資料:</td>
</tr>
<tr>
<td height="54">E-Mail:<br><input name="kehumail" type="text" id="kehumail" value="<%=rsr.getString("user_email")%>" size="17"></td>
<td>QQ:<%String qq = rsr.getString("user_qq");out.println(qq);out.println("<input type=hidden name=qq value="+qq+">");%><a target=blank href=tencent://message/?uin=<%=qq%>&Site=深圳萬網JSP虛擬主機&Menu=yes><img border="0" SRC=http://wpa.qq.com/pa?p=1:115798090:2 alt="點擊這里給我發消息"></a></td>
<td>姓名:<input name="xm" type="text" id="xm" value="<%=rsr.getString("user_xm")%>" size="10"></td>
<td>身份證:<input name="sfz" type="text" id="sfz" value="<%=rsr.getString("user_sfz")%>" size="15"></td><td>電話:<input name="dh" type="text" id="dh" value="<%=rsr.getString("user_dh")%>" size="15"></td><td>移動電話:<input name="yd" type="text" id="yd" value="<%=rsr.getString("user_yd")%>" size="10"></td>
</tr>
<tr>
<td height="48" colspan="2">地址:<input name="dz" type="text" id="dz" value="<%=rsr.getString("user_xxdz")%>" size="30"></td>
<td>
<input name="checkmail" type="checkbox" id="checkmail" value="yes">
企業郵局<br>
<br>
<input name="checkcn" type="checkbox" id="checkcn" value="yes">
國際域名
</td>
<td colspan="3">
<textarea name="bz" cols="60" rows="8" id="bz"></textarea> </td>
</tr>
<tr>
<td height="11"><input type="button" name="Submit" value="更 新" onClick="edit(<%=id%>)"></td>
<td><input type="button" name="Submit2" value="刪 除" onClick="del(<%=id%>)"></td>
<td> </td>
<td><input type="button" name="Submit3" value="轉 正" onclick="datacheck()"> </td>
<td><input type="button" name="Submit4" value="發 信" onClick="x(<%=id%>)"></td>
<td> </td>
</tr>
</table> </form>
<%
}
rsr.close();
String strupds = "UPDATE jsp8_host SET bid = '定單' where id = '"+id+"'";
stmt.executeUpdate(strupds);
stmt.close();
con.close();
ConBean.close();
%>
<script language="javascript">
function del(id)
{
myvalue=confirm("該操作不可恢復,確認要刪除嗎？");
if (myvalue== true)
window.location ="host-s.jsp?id="+id
}
</script>
<script language="javascript">
function edit(ide)
{
myvalue=confirm("該操作只能更新定單要繼續嗎？");
if (myvalue== true)
window.location ="edit.jsp?id="+ide
}
</script>
<script language="javascript">
function x(id)
{
myvalue=confirm("確認要給該用戶發信嗎？");
if (myvalue== true)
window.location ="x.jsp?id="+id
}
</script>
<SCRIPT Language = javascript>
<!--
function datacheck()
{
if(frmLogin.webdx.value == "")
{
window.alert("用戶的WEB大小不能為空!");
document.frmLogin.elements(17).focus();
return ;
}
frmLogin.submit();
}
-->
</SCRIPT>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -