大学生社团管理系统JSP

package net.cl.model; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Collection; import net.cl.common.DbConn; import net.cl.view.MemberVo; public class MemberOp { DbConn db; public void insertVo(MemberVo vo) { db = new DbConn(); PreparedStatement pst = null; try { String sql = "insert into member(memberName,memberLoginName,memberpassword,memberSex,memberBirthday,memberDepartment,memberTel,memberMail) values(?,?,?,?,?,?,?,?)"; pst = db.getConn().prepareStatement(sql); pst.setString(1, vo.getMemberName()); pst.setString(2, vo.getMemberLoginName()); pst.setString(3, vo.getMemberPassword()); pst.setString(4, vo.getMemberSex()); pst.setString(5, vo.getMemberBirthday()); pst.setString(6, vo.getMemberDepartment()); pst.setString(7, vo.getMemberTel()); pst.setString(8, vo.getMemberMail()); pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (pst != null) { try { pst.close(); pst = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public void deleteVo(int id) { db = new DbConn(); Statement stmt = null; try { stmt = db.getConn().createStatement(); String sql = "delete from member where memberID=" + id; stmt.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (stmt != null) { try { stmt.close(); stmt = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public void updateVo(MemberVo vo) { db = new DbConn(); PreparedStatement pst = null; try { String sql = "update member set memberName=?,memberLoginName=?,memberpassword=?,memberSex=?,memberBirthday=?,memberDepartment=?,memberTel=?,memberMail=? where memberID=?"; pst = db.getConn().prepareStatement(sql); pst.setString(1, vo.getMemberName()); pst.setString(2, vo.getMemberLoginName()); pst.setString(3, vo.getMemberPassword()); pst.setString(4, vo.getMemberSex()); pst.setString(5, vo.getMemberBirthday()); pst.setString(6, vo.getMemberDepartment()); pst.setString(7, vo.getMemberTel()); pst.setString(8, vo.getMemberMail()); pst.setInt(9, vo.getMemberID()); pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (pst != null) { try { pst.close(); pst = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public Collection<MemberVo> selectAll() { Collection<MemberVo> cl = new ArrayList<MemberVo>(); db = new DbConn(); MemberVo vo = null; Statement stmt = null; try { stmt = db.getConn().createStatement(); String sql = "select memberID,memberName,memberLoginName,memberpassword,memberSex,memberBirthday,memberDepartment,memberTel,memberMail from member"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { vo = new MemberVo(); vo.setMemberID(rs.getInt(1)); vo.setMemberName(rs.getString(2)); vo.setMemberLoginName(rs.getString(3)); vo.setMemberPassword(rs.getString(4)); vo.setMemberSex(rs.getString(5)); vo.setMemberBirthday(rs.getString(6)); vo.setMemberDepartment(rs.getString(7)); vo.setMemberTel(rs.getString(8)); vo.setMemberMail(rs.getString(9)); cl.add(vo); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (stmt != null) { try { stmt.close(); stmt = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return cl; } public MemberVo selectOne(int id) { MemberVo vo = null; db = new DbConn(); Statement stmt = null; try { stmt = db.getConn().createStatement(); String sql = "select memberID,memberName,memberLoginName,memberpassword,memberSex,memberBirthday,memberDepartment,memberTel,memberMail from member where memberID=" + id; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { vo = new MemberVo(); vo.setMemberID(rs.getInt(1)); vo.setMemberName(rs.getString(2)); vo.setMemberLoginName(rs.getString(3)); vo.setMemberPassword(rs.getString(4)); vo.setMemberSex(rs.getString(5)); vo.setMemberBirthday(rs.getString(6)); vo.setMemberDepartment(rs.getString(7)); vo.setMemberTel(rs.getString(8)); vo.setMemberMail(rs.getString(9)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (stmt != null) { try { stmt.close(); stmt = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return vo; } public MemberVo selectOne1(String name) { MemberVo vo = null; db = new DbConn(); Statement stmt = null; try { stmt = db.getConn().createStatement(); String sql = "select memberID,memberName,memberLoginName,memberpassword,memberSex,memberBirthday,memberDepartment,memberTel,memberMail from member where memberLoginName='" + name + "'"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { vo = new MemberVo(); vo.setMemberID(rs.getInt(1)); vo.setMemberName(rs.getString(2)); vo.setMemberLoginName(rs.getString(3)); vo.setMemberPassword(rs.getString(4)); vo.setMemberSex(rs.getString(5)); vo.setMemberBirthday(rs.getString(6)); vo.setMemberDepartment(rs.getString(7)); vo.setMemberTel(rs.getString(8)); vo.setMemberMail(rs.getString(9)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (stmt != null) { try { stmt.close(); stmt = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return vo; } public boolean verVo(MemberVo vo) { boolean b = false; db = new DbConn(); Statement stmt = null; ResultSet rs = null; System.out.println(" eee"); String sql = "select memberPassword from member where memberLoginName ='" + vo.getMemberLoginName() + "'"; try { stmt = db.getConn().createStatement(); rs = stmt.executeQuery(sql); while (rs.next()) { String pwd = rs.getString(1); if (pwd.equals(vo.getMemberPassword())) { b = true; } else { b = false; } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (stmt != null) { try { stmt.close(); stmt = null; db.closeConn(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return b; } public boolean verLoginName(String s) { boolean b = false; db = new DbConn(); Statement stmt = null; ResultSet rs = null; System.out.println(" eee"); String sql = "select memberLoginName from member where memberLoginName =" + s; try { stmt = db.getConn().createStatement(); rs = stmt.executeQuery(sql); while (rs.next()) { String lnm = rs.getString(1); if (lnm.equals(s)) { b = true; } else { b = false; } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (stmt != null) {