📄 liulan.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,demo.chat.bean.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%@ include file="page.jsp"%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><%
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 stmt = cons.createStatement();
Statement stmt1 = cons.createStatement();
String upd="select count(*) as a from register";
ResultSet up=stmt1.executeQuery(upd);
if(up.next()){
maxRowCount=up.getInt("a");
}
String sql="select * from register";
ResultSet rs=stmt.executeQuery(sql);
while(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>");
}
%>
<body background="pictures/44.jpg">
<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>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -