📄 admin_0005fuserlist_0002ejsp_jsp.java
字号:
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class admin_0005fuserlist_0002ejsp_jsp extends HttpJspBase {
static {
}
public admin_0005fuserlist_0002ejsp_jsp( ) {
}
private static boolean _jspx_inited = false;
public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
String _value = null;
try {
if (_jspx_inited == false) {
synchronized (this) {
if (_jspx_inited == false) {
_jspx_init();
_jspx_inited = true;
}
}
}
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/admin_userlist.jsp";from=(0,48);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/admin_userlist.jsp";from=(1,31);to=(36,0)]
out.write("\r\n\r\n<html>\r\n<head>\r\n<title>BBS管理系统</title>\r\n<style type=\"text/css\">\r\n<!--\r\nbody {\r\n\tbackground-color: #FFCC99;\r\n}\r\n.style3 {\r\n\tfont-size: 20px;\r\n\tcolor: #FFFFCC;\r\n}\r\n-->\r\n</style>\r\n</head>\r\n<body bgcolor=\"#ffffff\">\r\n<form name=\"form1\" method=\"post\" action=\"\">\r\n<table width=\"820\" border=\"0\" align=\"center\" >\r\n<tr bgcolor=\"#CC6600\">\r\n<td colspan=\"10\" align=\"center\"><span class=\"style3\">会员显示列表</span></td>\r\n</tr>\r\n<tr align=\"center\" bgcolor=\"#FFCC66\" >\r\n<td width=\"75\">用户名</td>\r\n<td width=\"67\">等级</td>\r\n<td width=\"73\">呢称</td>\r\n<td width=\"53\">性别</td>\r\n<td width=\"109\">注册时间</td>\r\n<td width=\"102\">E-mail</td>\r\n<td width=\"100\">个人主页</td>\r\n<td width=\"90\">QQ</td>\r\n<td width=\"104\">最后登录</td>\r\n<td width=\"68\">操作</td>\r\n</tr>\r\n");
// end
// begin [file="/admin_userlist.jsp";from=(36,2);to=(47,0)]
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:bbs","","");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from user");
while(rs.next()){
int userid=rs.getInt(1);
// end
// HTML // begin [file="/admin_userlist.jsp";from=(47,2);to=(49,4)]
out.write("\r\n<tr align=\"center\">\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(49,7);to=(49,22)]
out.print(rs.getString(2));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(49,24);to=(50,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(50,7);to=(50,23)]
out.print(rs.getString(23));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(50,25);to=(51,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(51,7);to=(51,22)]
out.print(rs.getString(4));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(51,24);to=(52,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(52,7);to=(52,22)]
out.print(rs.getString(5));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(52,24);to=(53,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(53,7);to=(53,23)]
out.print(rs.getString(12));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(53,25);to=(54,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(54,7);to=(54,22)]
out.print(rs.getString(8));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(54,24);to=(55,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(55,7);to=(55,22)]
out.print(rs.getString(9));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(55,24);to=(56,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(56,7);to=(56,23)]
out.print(rs.getString(10));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(56,25);to=(57,4)]
out.write("</td>\r\n<td>");
// end
// begin [file="/admin_userlist.jsp";from=(57,7);to=(57,23)]
out.print(rs.getString(13));
// end
// HTML // begin [file="/admin_userlist.jsp";from=(57,25);to=(59,30)]
out.write("</td>\r\n<td>\r\n<a href=admin_user.jsp?userid=");
// end
// begin [file="/admin_userlist.jsp";from=(59,33);to=(59,39)]
out.print(userid);
// end
// HTML // begin [file="/admin_userlist.jsp";from=(59,41);to=(60,29)]
out.write(">修改</a>\r\n<a href=admin_del.jsp?userid=");
// end
// begin [file="/admin_userlist.jsp";from=(60,32);to=(60,38)]
out.print(userid);
// end
// HTML // begin [file="/admin_userlist.jsp";from=(60,40);to=(64,0)]
out.write(">删除</a>\r\n</td>\r\n\r\n</tr>\r\n");
// end
// begin [file="/admin_userlist.jsp";from=(64,2);to=(64,3)]
}
// end
// HTML // begin [file="/admin_userlist.jsp";from=(64,5);to=(67,0)]
out.write("\r\n</table>\r\n</form>\r\n");
// end
// begin [file="/admin_userlist.jsp";from=(67,2);to=(81,0)]
}catch(Exception e){
out.println(e.getMessage());
}finally{
try{
if(rs!=null)
rs.close();
if(rs!=null)
stmt.close();
if(conn!=null)
conn.close();
}catch(SQLException sqle){
out.println(sqle.getMessage());}
}
// end
// HTML // begin [file="/admin_userlist.jsp";from=(81,2);to=(85,0)]
out.write("\r\n\r\n</body>\r\n</html>\r\n");
// end
} catch (Throwable t) {
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -