?? cha-zs-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>
<jsp:useBean id="ConBean" scope="session"
class="com.bitc.ch13.DBCon"/>
<%
String text = new String(request.getParameter("text").getBytes("ISO-8859-1"),"GBK");
String select = new String(request.getParameter("select").getBytes("ISO-8859-1"),"GBK");
String aa = "";
String id = "";
aa = "SELECT * FROM jsp8_zshost where "+select+" = '"+text+"'";
Connection con = ConBean.getConnection();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(aa);
while(rs.next()){
id = rs.getString("id");
String checkmail = rs.getString("checkmail");
String checkcn = rs.getString("checkcn");
String riqi = rs.getString("riqi");
String beian = rs.getString("beian");
%> <form name="frmLogin" method="post" action="host-gx.jsp">
<table width="927" height="444" border="1" bordercolor="#009999">
<tr>
<td width="136" height="82" align="center" valign="middle">
用戶:
<input name="yhs" type="text" id="yhs" value="<%=rs.getString("yh")%>" size="15"></td>
<td width="127">類型:
<input name="lx" type="text" id="lx" value="<%=rs.getString("lx")%>" size="10"></td>
<td width="144">容器:
<input name="rq" type="text" id="rq2" value="<%=rs.getString("rq")%>" size="15"></td>
<td width="165">數據庫空間
<input name="sjkdx" type="text" id="sjkdx" value="<%=rs.getString("sjkdx")%>" size="15"></td>
<td width="169">WEB空間:
<input name="webdx" type="text" id="webdx2" value="<%=rs.getString("webdx")%>" size="10"> </td>
<td width="146">企業郵局
<input name="maildx" type="text" id="webdx3" value="<%=rs.getString("maildx")%>" size="10"></td>
</tr>
<tr>
<td width="136" height="69"> 域名:
<input name="cn" type="text" id="cn2" value="<%=rs.getString("cn")%>" size="15"></td>
<td width="127">FTP:
<select name="ftp" id="select3">
<option value="61.152.239.26">61.152.239.26</option>
<option value="219.150.217.90">219.150.217.90</option>
<option value="<%String ftp = rs.getString("ftp");out.println(ftp);%>" selected><%=ftp%></option>
</select></td>
<td width="144"> FTP:
<input name="ftpname" type="text" id="ftpname3" value="<%=rs.getString("ftppwd")%>" size="15"></td>
<td width="165">FTP密碼:
<input name="ftppwd" type="text" id="ftppwd3" value="<%=rs.getString("ftppwd")%>" size="10"> </td>
<td width="169">數據庫:
<input name="sjk" type="text" id="sjk4" value="<%=rs.getString("sjk")%>" size="10"> </td>
<td width="146">數據庫帳戶:
<input name="sjkname" type="text" id="sjkname3" value="<%=rs.getString("sjkname")%>" size="15"> </td>
</tr>
<tr bgcolor="#FFFFCC">
<td height="42">數據庫密碼:
<input name="sjkpwd" type="text" id="sjkpwd3" value="<%=rs.getString("sjkpwd")%>" size="15"> </td>
<td height="42">郵局帳戶:
<input name="mailname" type="text" id="mailname3" value="<%=rs.getString("mailname")%>" size="15"></td>
<td height="42">郵局密碼:
<input name="mailpwd" type="text" id="mailpwd4" value="<%=rs.getString("mailpwd")%>" size="15"></td>
<td height="42">郵局用戶
<input name="mailyh" type="text" id="mailyh" value="<%=rs.getString("mailyh")%>" size="10"></td>
<td height="42">日期:
<input name="riqi" type="text" id="riqi4" value="<%=riqi%>" size="15"></td>
<td height="42">備案:
<select name="beian" id="beian">
<option value="<%=beian%>" selected><%=beian%></option>
<option value="未備案">未備案</option>
<option value="已備案">已備案</option>
</select></td>
</tr>
<tr bgcolor="#FFFFCC">
<td height="30" colspan="6">聯系人資料:</td>
</tr>
<tr>
<td height="54">姓名:
<input name="xm" type="text" id="xm2" value="<%=rs.getString("xm")%>" size="10"></td>
<td>電話:
<input name="dh" type="text" id="dh2" value="<%=rs.getString("dh")%>" size="15"></td>
<td> 移動電話:
<input name="yd" type="text" value="<%=rs.getString("yd")%>" size="10"></td>
<td>QQ:
<%String qq = rs.getString("qq");out.println(qq);out.println("<input type=text name=qq value="+qq+" size=15>");%>
<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>E-Mail:<br>
<input name="kehumail" type="text" id="kehumail3" value="<%=rs.getString("kehumail")%>" size="17"></td>
<td>身份證:
<input name="sfz" type="text" id="sfz2" value="<%=rs.getString("sfz")%>" size="15"></td>
</tr>
<tr>
<td height="48" colspan="2">地址:<input name="dz" type="text" id="dz" value="<%=rs.getString("dz")%>" size="30"></td>
<td>
<%
if(checkmail.indexOf("yes")!=-1){
out.println("<input name=checkmail type=checkbox id=checkmail value=yes checked>企業郵局<br><br>");
}
else{
out.println("<input name=checkmail type=checkbox id=checkmail value=yes>企業郵局<br><br>");
}
if(checkcn.indexOf("yes")!=-1){
out.println("<input name=checkcn type=checkbox id=checkmail value=yes checked>國際域名<br><br>");
}
else{
out.println("<input name=checkcn type=checkbox id=checkmail value=yes>國際域名<br><br>");
}
%>
</td>
<td colspan="3">
<textarea name="bz" cols="60" rows="8" id="bz"></textarea><input type=hidden name=id value=<%=id%>> </td>
</tr>
<tr>
<td height="11"><input type="button" name="Submit" value="更 新" onclick="datacheck()"></td>
<td><input type="button" name="Submit2" value="刪 除" onClick="del(<%=id%>)"></td>
<td> </td>
<td> </td>
<td><input type="button" name="Submit4" value="發 信" onClick="x(<%=id%>)"></td>
<td><input type="button" name="Submit22" value="打 印" onClick="dayin(<%=id%>)"></td>
</tr>
</table> </form>
<hr color="#FFCC33" size=5>
<%
}
rs.close();
stmt.close();
con.close();
ConBean.close();
%>
<script language="javascript">
function del(id)
{
myvalue=confirm("該操作不可恢復,確認要刪除嗎？");
if (myvalue== true)
window.location ="host-zs-s.jsp?id="+id
}
</script>
<script language="javascript">
function dayin(id)
{
myvalue=confirm("要打印嗎？");
if (myvalue== true)
window.location ="dayin.jsp?id="+id
}
</script>
<script language="javascript">
function x(id)
{
myvalue=confirm("確認要給該用戶發信嗎？");
if (myvalue== true)
window.location ="host-zs-xin.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 + -