实验5jsp.docVIP

实验五 1.//查看所有成员的信息 public ListMember findALL() throws Exception{ ListMember all=new ArrayListMember(); String sql=select userid,password,password1,name,sex,dept,email,interest1,interest2,note from member; this.ps=this.conn.prepareStatement(sql); ResultSet rs=this.ps.executeQuery(); Member member=null; while(rs.next()){ member=new Member(); member.setUserid(rs.getString(1)); member.setPassword(rs.getString(2)); member.setPassword1(rs.getString(3)); member.setName(rs.getString(4)); member.setSex(rs.getString(5)); member.setDept(rs.getString(6)); member.setEmail(rs.getString(7)); String[] interest=new String[2]; interest[0]=rs.getString(8); interest[1]=rs.getString(9); member.setInterest(interest); member.setNote(rs.getString(10)); all.add(member); } rs.close(); this.ps.close(); this.conn.close(); return all; } 2.admin_select.jsp %@ page contentType=text/html pageEncoding=gb2312% %@ page import=java.sql.*% html body %! public static final String DBDRIVER=org.gjt.mm.mysql.Driver; public static final String DBURL=jdbc:mysql://localhost:3306/sw0825; public static final String DBUSER=root; public static final String DBPASS=mysqladmin; % % Connection conn=null; PreparedStatement pstmt=null; ResultSet rs=null; % % try{ request.setCharacterEncoding(gb2312); Class.forName(DBDRIVER); conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS); String sql=select userid,password,password1,name,sex,dept,email,interest1,interest2,note from member; pstmt=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=pstmt.executeQuery(); % center table border=1 width=80% caption所有人的报名信息/caption tr td用户名/td td密码/td td确认密码/td td姓名/td td性别/td td学院/td td邮箱/td td爱好1/td td爱好2/td td备注/td /tr % String str=request.getParameter(page); if(str==null){ str=0; } int pagesize=2; rs.last(); int recordCount=rs.getRow(); int maxPage=(