📄 dayin.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">
<!--
.style3 {font-size: 24px; font-weight: bold; }
.style4 {color: #000000}
.style5 {font-size: 24px; font-weight: bold; color: #000000; }
body {
margin-top: 0px;
margin-bottom: 0px;
}
body,td,th {
font-size: 16px;
}
-->
</style>
</head>
<jsp:useBean id="ConBean" scope="session"
class="com.bitc.ch13.DBCon"/>
<body><SCRIPT language=JavaScript src="inc/common.js"> </SCRIPT>
<%
String id =request.getParameter("id");
Connection con = ConBean.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM jsp8_zshost where id ='"+id+"'");
while(rs.next()){
String checkmail = rs.getString("checkmail");
String checkcn = rs.getString("checkcn");
%>
<DIV id=article>
<table width="600" height="816" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="FFF1E1" class="style4">
<td style=font-size:12px><strong>系统信息：</strong></td>
<td style=font-size:12px> </td>
<td style=font-size:12px> </td>
<td style=font-size:12px><strong><a href="javascript:doPrint()">打印</a></strong></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="32" align="right" style=font-size:12px>是否有邮局：</td>
<td style=font-size:12px><font color="#0000FF"><%if(checkmail.equals("yes")){out.println("有");}else{out.println("无");}%></font></td>
<td align="center" style=font-size:12px>是否有域名：</td>
<td style=font-size:12px><%if(checkcn.equals("yes")){out.println("有");}else{out.println("无");}%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="33" align="right" style=font-size:12px>主机开始时间：</td>
<td style=font-size:12px><font color="#0000FF"><%=rs.getString("riqi")%></font> </td>
<td align="center" style=font-size:12px>是否备案：</td>
<td style=font-size:12px><%=rs.getString("beian")%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="23" align="right" style=font-size:12px>订购的用户：</td>
<td colspan="3" style=font-size:12px><%=rs.getString("yh")%></td>
<tr bgcolor="FFF1E1" class="style4">
<td colspan="4" style=font-size:12px><strong>虚拟主机信息：</strong></td>
</tr>
<tr class="style4">
<td width="102" height="5" align="right"></td>
<td height="5" colspan="3"></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="30" align="right" style=font-size:12px>主机名称：</td>
<td width="233" style=font-size:12px><%String lx=rs.getString("lx");out.println(lx);%>
</td>
<td width="85" height="30" align="center" style=font-size:12px>容 器 ：</td>
<td width="180" style=font-size:12px><%=rs.getString("rq")%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="30" align="right" bgcolor="#FFFFFF" style=font-size:12px>数 据 库：</td>
<td bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("sjkdx")%></td>
<td align="center" bgcolor="#FFFFFF" style=font-size:12px>WEB空间：</td>
<td align="left" bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("webdx")%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="28" align="right" bgcolor="#FFFFFF" style=font-size:12px>企业邮局：</td>
<td bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("maildx")%></td>
<td align="center" bgcolor="#FFFFFF" style=font-size:12px>绑定的域名：</td>
<td align="left" bgcolor="#FFFFFF" style=font-size:12px><%String cn = rs.getString("cn");out.println(cn);%></td>
</tr>
<tr bgcolor="FFF1E1" class="style4">
<td colspan="4" style=font-size:12px><strong>FTP信息：</strong></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="29" align="right" style=font-size:12px>F T P：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF"> <%String ip =rs.getString("ftp");out.println(ip);%></font></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="28" align="right" style=font-size:12px>用户名：</td>
<td colspan="3" style=font-size:12px> <%String ftpname =rs.getString("ftpname");out.println(ftpname);%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="27" align="right" style=font-size:12px>密 码：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF"><%=rs.getString("ftppwd")%></font></td>
</tr>
<%if(checkcn.equals("yes")){%>
<tr bgcolor='FFF1E1' class="style4">
<td colspan='4' style=font-size:12px><strong>域名信息：</strong></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="26" align='right' bgcolor="#FFFFFF" style=font-size:12px>你的域名：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=cn%></font></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="26" align='right' bgcolor="#FFFFFF" style=font-size:12px>管理地址：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><a href="http://diy.hichina.com/cgi-bin/login" target="_blank">http://diy.hichina.com/cgi-bin/login</a></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="28" align='right' bgcolor="#FFFFFF" style=font-size:12px>管理密码：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px>123456 </td>
</tr>
<%}%>
<tr bgcolor='FFF1E1' class="style4">
<td colspan='4' style=font-size:12px><strong>数据库信息：</strong></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="29" align='right' bgcolor="#FFFFFF" style=font-size:12px>数据库：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=rs.getString("sjk")%></font></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="29" align='right' bgcolor="#FFFFFF" style=font-size:12px>数据库名称：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF">
<%String sjkname =rs.getString("sjkname");out.println(sjkname);%>
</font></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="30" align='right' bgcolor="#FFFFFF" style=font-size:12px>数据库用户：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=sjkname%></font></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="27" align='right' bgcolor="#FFFFFF" style=font-size:12px>数据库密码：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=rs.getString("sjkpwd")%></font></td>
</tr>
<%if(checkmail.equals("yes")){%>
<tr bgcolor='FFF1E1' class="style4">
<td colspan='4' style=font-size:12px><strong>邮局信息：</strong></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="28" align='right' bgcolor="#FFFFFF" style=font-size:12px>管理员用户：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=rs.getString("mailname")%></font></td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="28" align='right' bgcolor="#FFFFFF" style=font-size:12px>管理员密码：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=rs.getString("mailpwd")%></font> </td>
</tr>
<tr bgcolor='#FFFFFF' class="style4">
<td height="24" align='right' bgcolor="#FFFFFF" style=font-size:12px>邮局用户数：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><%=rs.getString("mailyh")%></font></td>
</tr>
<%}%>
<tr bgcolor="FFF1E1" class="style4">
<td colspan="4" style=font-size:12px><strong>客户信息：</strong></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="27" align="right" style=font-size:12px>姓名：</td>
<td style=font-size:12px><%=rs.getString("xm")%>
<td style=font-size:12px>电话：
<td style=font-size:12px><%=rs.getString("dh")%>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="29" align="right" style=font-size:12px>移动：</td>
<td style=font-size:12px><%=rs.getString("yd")%></td>
<td style=font-size:12px>Q Q：</td>
<td style=font-size:12px><%=rs.getString("qq")%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="28" align="right" style=font-size:12px>E-MAIL:</td>
<td bgcolor="#FFFFFF" style=font-size:12px><%String kehumail =rs.getString("kehumail");out.println(kehumail);%></td>
<td bgcolor="#FFFFFF" style=font-size:12px>身份正号码：</td>
<td bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("sfz")%></td>
</tr>
<tr bgcolor="#FFFFFF" class="style4">
<td height="23" align="right" style=font-size:12px>地址：</td>
<td style=font-size:12px><%=rs.getString("dz")%></td>
<td style=font-size:12px> </td>
<td style=font-size:12px> </td>
</tr>
<tr align="left" bgcolor="#FFFFFF" class="style4">
<td height="29" colspan="4" style=font-size:12px><%=rs.getString("bz")%></td>
</tr>
</table>
</DIV>
<%
}
rs.close();
stmt.close();
ConBean.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -