📄 x.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.Date" errorPage="" %>
<html>
<jsp:useBean id="ConBean" scope="session"
class="com.bitc.ch13.DBCon"/>
<%
String id = request.getParameter("id");
Date Now = new Date();
String year = String.valueOf(Now.getYear() + 1900);
String month = String.valueOf(Now.getMonth() + 1);
String day = String.valueOf(Now.getDate());
String hour = String.valueOf(Now.getHours());
String minute = String.valueOf(Now.getMinutes());
String second = String.valueOf(Now.getSeconds());
String date = year + "-" + month + "-" + day;
String shijian = date + " " + hour + ":" + minute + ":" + second;
Connection con = ConBean.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM vidc where id ='"+id+"'");
while(rs.next()){
%><body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table height="389">
<form action="sendHTMLMail.jsp" method="post">
<tr>
<td height="294" colspan="2">
<textarea name="content" cols="100"
rows="20">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body,td,input{font-size:9pt}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style1 {font-size: medium}
.style2 {font-size: 14px}
</style>
<title>深圳万网JSP虚拟主机!</title>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="750" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="FF8400">
<tr>
<td align="center">
<table width="749" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" align="center" bgcolor="FF8400"> <table width="480" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="112"><a href="http://www.8isp.cn" target="_blank"><img src="http://www.8isp.cn/2.gif" width="187" height="57" border="0"></a></td>
<td width="468" align="right"><img src="http://www.8isp.cn/xx.gif" width="355" height="45"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="400" align="center" valign="top" bgcolor="#FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="97%" height="30" align="right" bgcolor="FFF1E1" style=font-size:12px><strong>结算单号：00006041 </strong>
发信时间：<%=shijian%></td>
<td width="3%" align="right" bgcolor="FFF1E1"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style=font-size:12px><strong>尊敬的深圳万网用户：</strong><br>
<span class="style1"><br>
<span class="style2">您好！感谢您订购深圳万网JSP虚拟主机！<br>
请仔细查阅以下注册信息，如有任何疑问请与我公司联系，联系方式如下：<br>
电 话：0755 - 27257807 QQ:441992599 <br>
Email：<a href="mailto:zcdnsz@10000net.cn">zcdnsz@10000net.cn</a> </span></span> </td>
</tr>
</table>
<table width="600" border="0" cellpadding="6" cellspacing="0">
<tr bgcolor="FFF1E1">
<td colspan="4" style=font-size:12px><strong>虚拟主机信息：</strong></td>
</tr>
<tr>
<td width="143" height="5" align="right"></td>
<td height="5" colspan="3"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="37" align="right" style=font-size:12px>主机名称：</td>
<td width="195" style=font-size:12px><%String mc = rs.getString("mc");out.println(mc);%></td></td>
<td height="37" align="right" style=font-size:12px>价 格 ：</td>
<td width="122" style=font-size:12px><%String pric = rs.getString("pric");out.println(pric);%>元</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="32" align="right" bgcolor="#FFFFFF" style=font-size:12px>企业邮局：</td>
<td bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("m")%></td>
<td align="right" bgcolor="#FFFFFF" style=font-size:12px>WEB空间：</td>
<td align="left" bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("k")%>M</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="36" align="right" bgcolor="#FFFFFF" style=font-size:12px>数 据 库：</td>
<td bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("s")%></td>
<td align="right" bgcolor="#FFFFFF" style=font-size:12px>绑定的域名：</td>
<td align="left" bgcolor="#FFFFFF" style=font-size:12px><%=rs.getString("www")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="4" align="right" bgcolor="#FFFFFF" style=font-size:12px> </td>
</tr>
<tr bgcolor="FFF1E1">
<td colspan="4" style=font-size:12px><strong>客户信息：</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="32" align="right" style=font-size:12px>姓名：</td>
<td colspan="3" style=font-size:12px><%=rs.getString("lxr")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30" align="right" style=font-size:12px>电话：</td>
<td colspan="3" style=font-size:12px><%=rs.getString("dh")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="31" align="right" style=font-size:12px>Q Q：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF"><%=rs.getString("qq")%></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30" align="right" style=font-size:12px>地址：</td>
<td colspan="3" style=font-size:12px><%=rs.getString("dz")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="29" align="right" style=font-size:12px>E-MAIL:：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF"><% String email = rs.getString("sfz");out.println(email);%></font></td>
</tr>
<tr bgcolor="FFF1E1">
<td colspan="4" style=font-size:12px><strong>支付信息：</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="34" align="right" style=font-size:12px>在线支付：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF">￥ <a href="http://www.8isp.cn/zf.htm" target="_blank">www.8isp.cn/zf.htm</a></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="35" align="right" style=font-size:12px>公司帐户：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF">
<li>中国工商银行深圳市新沙支行 9558 8040 0014 2388 400 顾莉莉
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="34" align="right" style=font-size:12px>手机支付：</td>
<td colspan="3" style=font-size:12px><font color="#0000FF"> 暂未开通</font></td>
</tr>
<tr bgcolor='FFF1E1'> <td colspan='4' style=font-size:12px><strong>客服支持：</strong></td>
</tr> <tr bgcolor='#FFFFFF'> <td height="31" align='right' bgcolor="#FFFFFF" style=font-size:12px>万网论坛：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px><font color="#0000FF"><a href="http://bbs.8isp.cn" target="_blank">http://bbs.8isp.cn</a></font></td>
</tr>
<tr bgcolor='#FFFFFF'>
<td height="32" align='right' bgcolor="#FFFFFF" style=font-size:12px>客服Q Q：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px>441992599</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td height="30" align='right' bgcolor="#FFFFFF" style=font-size:12px>E - MAIL：</td>
<td colspan="3" bgcolor="#FFFFFF" style=font-size:12px>zcdnsz@10000net.cn</td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="183" align="center" bgcolor="FFF1E1" style=font-size:14px><em><font color="#0000FF">本本次订购合计：</font></em></td>
<td width="250" height="20" align="right" bgcolor="FFF1E1" style=font-size:14px><em><font color="#0000FF">￥<%=pric%>.00元</font></em></td>
<td width="3" bgcolor="FFF1E1"> </td>
</tr>
<tr bgcolor="FFF1E1">
<td height="20" colspan="3" style=font-size:14px>说明:请在打款后到<a href="http://bbs.8isp.cn/thread.php?fid=53" target="_blank">论坛发帖</a>说明你的银行卡号打款金额,以及你的所在地和姓名,或者和我们客服联系,确认后我们将在15分钟以内开通你的主机!</td>
</tr>
<tr>
<td colspan="3" align="right" height=10></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="FF8400">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" style="font-size:12px;line-height:150%">深圳万网网络有限公司公司 客户服务电话: 0755-27257807 传真: 0755-27531900<br>
地址:
广东省深圳市宝安区沙井镇北环路102号1~2楼
邮编:
518105<br>
增值电信业务经营许可证粤 B2-20050204
</td>
<td width="50"> </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
</textarea>
</td>
</tr>
<tr>
<td width="95">收信人:</td>
<td width="389"><input name="to" size="40" value="<%=email%>"></td>
</tr>
<tr>
<td>主题:</td>
<td><input name="title" size="40" value="深圳万网<%=mc%>订购信"></td>
</tr>
<tr>
<td> <select name="select"><option value="10000net.cn" selected>10000net.cn</option>
<option value="126.com">126.com</option>
</select></td>
<td>
<input type="submit" value="Submit">
</td>
</tr>
</form>
</table>
<%
}
rs.close();
stmt.close();
ConBean.close();
%>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -