📄 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-z.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");
String lxr = "";
Connection con = ConBean.getConnection();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM jsp8_host where id ='"+id+"'");
while(rs.next()){
%>
<tr>
<td width="136" height="82" align="center" valign="middle"><%lxr = rs.getString("yh"); out.println(lxr);%><input type="hidden" name=yhs value=<%=lxr%>><input type="hidden" name=id value=<%=id%>></td>
<td width="127">类型:
<input name="lx" type="text" id="lx" value="<%=rs.getString("lx")%>" size="10"></td>
<td width="144">数据库:<input name="sjk" type="text" id="sjk" value="<%=rs.getString("sjk")%>" size="10"></td>
<td width="165">容器:<input name="rq" type="text" id="rq" value="<%=rs.getString("rq")%>" size="15"></td>
<td width="169">FTP:<input name="ftpname" type="text" id="ftpname" value="<%=rs.getString("ftp")%>" size="15"></td>
<td width="146">FTP密码:<input name="ftppwd" type="text" id="ftppwd" value="<%=rs.getString("ftppwd")%>" size="10"></td>
</tr>
<tr>
<td width="136" height="69">数据库帐户:<input name="sjkname" type="text" id="sjkname" value="<%=rs.getString("sqlname")%>" size="15"></td>
<td width="127">数据库密码:<input name="sjkpwd" type="text" id="sjkpwd" value="<%=rs.getString("sqlpwd")%>" size="15"></td>
<td width="144">邮局帐户:<input name="mailname" type="text" id="mailname" value="<%=rs.getString("mailname")%>" size="15"></td>
<td width="165">邮局密码:<input name="mailpwd" type="text" id="mailpwd" value="<%=rs.getString("mailpwd")%>" size="15"></td>
<td width="169">域名:<input name="cn" type="text" id="cn" value="<%=rs.getString("cn")%>" size="15"></td>
<td width="146">日期:<input name="riqi" type="text" id="riqi" value="<%=rs.getString("riqi")%>" size="15"></td>
</tr>
<%
}
rs.close();
ResultSet rsr = stmt.executeQuery("SELECT * FROM jsp8_user where user_name ='"+lxr+"'");
while(rsr.next()){
%>
<tr bgcolor="#FFFFCC">
<td height="42">企业邮局
<select name="maildx" id="maildx">
<option value="100M" selected>100M</option>
<option value="200M">200M</option>
<option value="300M">300M</option>
<option value="400M">400M</option>
<option value="500M">500M</option>
<option value="600M">600M</option>
<option value="700M">700M</option>
<option value="800M">800M</option>
<option value="900M">900M</option>
<option value="1000M">1000M</option>
<option value="其他">其他</option>
<option value="无限制">无限制</option>
</select> </td>
<td height="42">邮局用户
<select name="mailyh" id="mailyh">
<option value="5用户" selected>5用户</option>
<option value="10用户">10用户</option>
<option value="15用户">15用户</option>
<option value="20用户">20用户</option>
<option value="30用户">30用户</option>
<option value="40用户">40用户</option>
<option value="50用户">50用户</option>
<option value="其他">其他</option>
</select></td>
<td height="42">数据库空间
<select name="sjkdx" id="sjkdx">
<option value="100M" selected>100M</option>
<option value="200M">200M</option>
<option value="300M">300M</option>
<option value="400M">400M</option>
<option value="500M">500M</option>
<option value="600M">600M</option>
<option value="700M">700M</option>
<option value="800M">800M</option>
<option value="900M">900M</option>
<option value="1000M">1000M</option>
<option value="其他">其他</option>
<option value="无限制">无限制</option>
</select></td>
<td height="42">FTP:
<select name="ftp" id="ftp">
<option value="61.152.239.26">61.152.239.26</option>
<option value="219.150.217.90" selected>219.150.217.90</option>
</select></td>
<td height="42">WEB空间:
<input name="webdx" type="text" id="webdx" size="10"></td>
<td height="42">备案:
<select name="beian" id="beian">
<option value="未备案" selected>未备案</option>
<option value="已备案">已备案</option>
</select></td>
</tr>
<tr bgcolor="#FFFFCC">
<td height="30" colspan="6">联系人资料:</td>
</tr>
<tr>
<td height="54">E-Mail:<br><input name="kehumail" type="text" id="kehumail" value="<%=rsr.getString("user_email")%>" size="17"></td>
<td>QQ:<%String qq = rsr.getString("user_qq");out.println(qq);out.println("<input type=hidden name=qq value="+qq+">");%><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>姓名:<input name="xm" type="text" id="xm" value="<%=rsr.getString("user_xm")%>" size="10"></td>
<td>身份证:<input name="sfz" type="text" id="sfz" value="<%=rsr.getString("user_sfz")%>" size="15"></td><td>电话:<input name="dh" type="text" id="dh" value="<%=rsr.getString("user_dh")%>" size="15"></td><td>移动电话:<input name="yd" type="text" id="yd" value="<%=rsr.getString("user_yd")%>" size="10"></td>
</tr>
<tr>
<td height="48" colspan="2">地址:<input name="dz" type="text" id="dz" value="<%=rsr.getString("user_xxdz")%>" size="30"></td>
<td>
<input name="checkmail" type="checkbox" id="checkmail" value="yes">
企业邮局<br>
<br>
<input name="checkcn" type="checkbox" id="checkcn" value="yes">
国际域名
</td>
<td colspan="3">
<textarea name="bz" cols="60" rows="8" id="bz"></textarea> </td>
</tr>
<tr>
<td height="11"><input type="button" name="Submit" value="更 新" onClick="edit(<%=id%>)"></td>
<td><input type="button" name="Submit2" value="删 除" onClick="del(<%=id%>)"></td>
<td> </td>
<td><input type="button" name="Submit3" value="转 正" onclick="datacheck()"> </td>
<td><input type="button" name="Submit4" value="发 信" onClick="x(<%=id%>)"></td>
<td> </td>
</tr>
</table> </form>
<%
}
rsr.close();
String strupds = "UPDATE jsp8_host SET bid = '定单' where id = '"+id+"'";
stmt.executeUpdate(strupds);
stmt.close();
con.close();
ConBean.close();
%>
<script language="javascript">
function del(id)
{
myvalue=confirm("该操作不可恢复,确认要删除吗？");
if (myvalue== true)
window.location ="host-s.jsp?id="+id
}
</script>
<script language="javascript">
function edit(ide)
{
myvalue=confirm("该操作只能更新定单要继续吗？");
if (myvalue== true)
window.location ="edit.jsp?id="+ide
}
</script>
<script language="javascript">
function x(id)
{
myvalue=confirm("确认要给该用户发信吗？");
if (myvalue== true)
window.location ="x.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 + -