📄 z.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.Date" %>
<!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 id = request.getParameter("id");
Date Now = new Date();
String year = String.valueOf(Now.getYear() + 1900);
String years = String.valueOf(Now.getYear() + 1901);
String month = String.valueOf(Now.getMonth() + 1);
String day = String.valueOf(Now.getDate());
String date = year + month + day;
String dates = years + month + day;
Connection con = ConBean.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM vidc where id ='"+id+"'");
while(rs.next()){
%>
<form action="z-z.jsp" method="post" name=frmLogin>
<table width="816" height="173" border="1" bordercolor="#009999">
<tr>
<td width="98" height="37"> <input name="mc" type="text" id="mc" value="<%=rs.getString("mc")%>" size="10"></td>
<td width="121">价格:
<input name="pric" type="text" id="pric" value="<%=rs.getInt("pric")%>" size="8"></td>
<td width="102">邮局:
<input name="e" type="text" id="e" value="<%=rs.getString("m")%>" size="6"></td>
<td width="63"><select name="s" id="s">
<%String k = rs.getString("s");out.println("<option value="+k+" selected>"+k+"</option><option value=MSSQL>MSSQL</option><option value=MYSQL>MYSQL</option>");%>
</select></td>
<td width="106">FTP:
<input name="ftp" type="text" id="ftp" value="<%=rs.getString("ftp")%>" size="8"></td>
<td width="129">FTP密码:
<input name="ftppwd" type="text" id="ftppwd" value="<%=rs.getString("ftppwd")%>" size="8"></td>
<td width="151">域名: <input name="www" type="text" id="www" value="<%=rs.getString("www")%>" size="12"></td>
</tr>
<tr bgcolor="#FFFFCC">
<td height="49" colspan="7">联系人资料:</td>
</tr>
<tr>
<td height="32">姓名:
<input name="lxr" type="text" id="lxr" value="<%=rs.getString("lxr")%>" size="6"></td>
<td>电话:<input name="dh" type="text" id="dh" value="<%=rs.getString("dh")%>" size="10"></td>
<td>QQ:
<%String qq = rs.getString("qq");out.println("<input name=qq type=text value="+qq+" size=8>");%></td>
<td colspan="3">地址:<input name="dz" type="text" id="dz" value="<%=rs.getString("dz")%>" size="30"></td>
<td>E-Mail:<input name="sfz" type="text" id="sfz" value="<%=rs.getString("sfz")%>" size="12"></td>
</tr>
<tr>
<td height="11" colspan="6"><textarea name="bz" cols="80" rows="10" id="bz"></textarea> <input type="hidden" name="id" value="<%=id%>"></td>
<td> <p>
<input type="checkbox" name="checkbox" value="yes">
域名 </p>
<p>
开始日期：
<input name="sj" type="text" id="sj" value="<%=date%>" size="10">
</p>
<p>
到期日期：
<input name="sjs" type="text" id="sjs" value="<%=dates%>" size="10">
</p>
<p>
<input type="submit" name="Submit" value="保 存">
</p></td></tr>
</table>
</form>
<%
}
rs.close();
stmt.close();
ConBean.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -