📄 searchuser.jsp~6~
字号:
<%@ 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>searchuser</title>
<style type="text/css">
<!--
.style3 {font-family: "黑体"; font-size: 9px; }
-->
</style>
</head>
<body>
<form name="form1" method="post" action="">
<table width="80%" border="0" align="center" cellpadding="4" cellspacing="1" id="table">
<tr>
<td width="45%" align="right">ID:</td>
<td><input name="searchuserid" type="text" id="searchuserid" size="15" maxlength="12"></td>
</tr>
<tr>
<td colspan="2" align="center"><input name="searchuserenter" type="submit" id="searchuserenter" value="enter">
<input name="searchuserreset" type="reset" id="searchuserreset" value="reset"></td>
</tr>
</table>
</form>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<center>
<%
try{
if(request.getParameter("searchuserenter")!=null){
String id = request.getParameter("searchuserid");
Connection conn=Library.getConn();
PreparedStatement pstmt=conn.prepareStatement("select * from user where id ='" + id + "'");
ResultSet rs = pstmt.executeQuery();
out.println("<p>results below:</p>");
while (rs.next()){
out.println("<p>ID = " + rs.getString("id") + " </p>");
out.println("<p>Course = " + rs.getString("course") + " </p>");
out.println("<p>Number = " + rs.getString("studentnumber") + " </p>");
out.println("<p>Code = " + rs.getString("code") + " </p>");
out.println("<p>Phone = " + rs.getString("phone") + " </p>");
out.println("<p>Email = " + rs.getString("email") + " </p>");
out.println("<p>Oicq = " + rs.getString("oicq") + " </p>");
out.println("<p>Maxbook = " + rs.getString("maxbook") + " </p>");
}
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -