📄 while1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<% request.setCharacterEncoding("gb2312"); %>
<jsp:useBean id="con" scope="page" class="project3.qusbean"></jsp:useBean>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询信息</title>
<style type="text/css">
<!--
.style1 {
font-size: 24px;
font-family: "华文行楷";
font-weight: bold;
}
.style3 {
font-size: 12px;
font-family: "黑体";
}
.style4 {font-size: 14px}
-->
</style>
</head>
<body>
<td width="63"> </td>
<td width="80"> </td>
<td width="56"> </td>
<td width="88"> </td>
<td width="232"> </td>
<td width="98"> </td>
<table width="709" height="172" border="0" align="center" background="background.jpg">
<tr>
<td height="35" colspan="7"> </td>
</tr>
<tr>
<td height="35" colspan="7"><div align="center"><span class="style1">查询信息</span>
<hr noshade>
</div></td>
</tr>
<tr>
<td height="25" colspan="7"><div align="center">
<form action="while1.jsp" method="post">
<span class="style3"><span class="style4">姓名查询</span>：</span><span class="style2">
<input name="textfield" type="text" size="20">
<input type="submit" name="Submit" value="查询">
<input type="reset" name="reset" value="取消">
</form>
</span></div></td>
</tr>
<tr bordercolor="#EFF8F7">
<td height="23"><div align="center">用户id</div></td>
<td><div align="center">用户名</div></td>
<td><div align="center">密码</div></td>
<td><div align="center">电子邮件</div></td>
<td><div align="center">
<p>真实姓名<br>
</p>
</div></td>
<td><div align="center">性别</div></td>
<td><div align="center">年龄</div></td>
</tr>
<tr>
<td width="62" height="2"> </tr>
<%
ResultSet rs=null;
String text=request.getParameter("textfield");
if(text==null||text.equals("")){
text="";
}else{
text="where 用户名='"+text+"'";
}
rs=con.executeQuery("select * from associator "+text);
while(rs.next())
{
%>
<tr>
<td height="27"><div align="center"><b><%=rs.getString("用户id")%></b></div></td>
<td><div align="center"><b><%=rs.getString("用户名")%></b></div></td>
<td><div align="center"><b><%=rs.getString("密码")%></b></div></td>
<td><div align="center"><b><%=rs.getString("电子邮件")%></b></div></td>
<td><div align="center"><b><%=rs.getString("真实姓名")%></b></div></td>
<td><div align="center"><b><%=rs.getString("性别")%></b></div></td>
<td><div align="center"><b><%=rs.getString("年龄")%></b></div></td>
</tr>
<%
}
%>
</table>
<p></p>
<%
rs.close();
con.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -