📄 select.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body background="pictures/ptwd_1280X1024.jpg">
<%
StringBuffer register=new StringBuffer();
String conDriver="com.mysql.jdbc.Driver";
String constr="jdbc:mysql://localhost:3306/liaotian";
String username="fan";
String pass="fan";
Class.forName(conDriver);
Connection cons=DriverManager.getConnection(constr,username,pass);
Statement stem=cons.createStatement();
ResultSet rs=null;
String qq=request.getParameter("qq");
String sql="select * from register where qq='"+qq+"'";
rs=stem.executeQuery(sql);
if(rs.next()){
register.append("<tr bgcolor=#ffffff>\n");
register.append("<td align=center>"+rs.getString("qq")+"</td>");
register.append("<td align=center>"+rs.getString("password")+"</td>");
register.append("<td>"+rs.getString("password1")+"</td>");
register.append("<td>"+rs.getString("nickname")+"</td>");
register.append("<td>"+rs.getString("sex")+"</td>");
register.append("<td>"+rs.getString("email")+"</td>");
register.append("<td>"+rs.getString("register")+"</td>");
register.append("</tr>");
}
else{
response.sendRedirect("chazhao.jsp");
}
%>
<table width="80%" border="0" align="center" cellpadding=5 cellspacing=1 bgcolor=#000000>
<tr align="center" bgcolor="#FFFFFF">
<td width="15%">qq号</td>
<td width="15%">密码</td>
<td width="15%">确认密码</td>
<td width="10%">昵称</td>
<td width="15%">性别</td>
<td width="15%">电邮</td>
<td width="15%">注册时间</td>
</tr>
<%=register%>
</table>
<center>
查找成功，请<a href="xianshi.jsp">返回操作</a>.
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -