📄 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>
<form name="frmLogin" method="post" action="host-gx.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");
Connection con = ConBean.getConnection();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM jsp8_zshost where id ='"+id+"'");
while(rs.next()){
String checkmail = rs.getString("checkmail");
String checkcn = rs.getString("checkcn");
String riqi = rs.getString("riqi");
String beian = rs.getString("beian");
%>
<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>
<%
}
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 + -