S2俱乐部会员信息管理系统（参考答案）

package com.thunder.dao.impl; import com.thunder.dao.BaseDao; import com.thunder.dao.MembersInfoDao; import com.thunder.entity.MembersInfo; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; /** * @author Think */ public class MembersInfoDaoImpl extends BaseDao implements MembersInfoDao { @Override public List<MembersInfo> query() throws Exception { connection = super.getConnection(); String sql = "select * from membersinfo"; List<MembersInfo> list = new ArrayList<MembersInfo>(); preparedStatement = connection.prepareStatement(sql); resultSet = preparedStatement.executeQuery(); selectGetAll(list); //关闭文档流 super.closeAll(connection, preparedStatement, resultSet); return list; } private void selectGetAll(List<MembersInfo> list) throws SQLException { MembersInfo membersInfo; while (resultSet.next()) { membersInfo = new MembersInfo(); membersInfo.setId(resultSet.getInt("MID")); membersInfo.setName(resultSet.getString("MNAME")); membersInfo.setGender(resultSet.getString("MGENDER")); membersInfo.setAge(resultSet.getInt("MAGE")); membersInfo.setAddress(resultSet.getString("MADDRESS")); membersInfo.setEmail(resultSet.getString("MEMAIL")); list.add(membersInfo); } } @Override public MembersInfo getInfoById(Integer id) throws Exception { connection = super.getConnection(); String sql = "select * from membersinfo where MID = ?"; MembersInfo membersInfo = null; preparedStatement = connection.prepareStatement(sql); preparedStatement.setInt(1, id); resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { membersInfo = new MembersInfo(); membersInfo.setId(resultSet.getInt("MID")); membersInfo.setName(resultSet.getString("MNAME")); membersInfo.setGender(resultSet.getString("MGENDER")); membersInfo.setAge(resultSet.getInt("MAGE")); membersInfo.setAddress(resultSet.getString("MADDRESS")); membersInfo.setEmail(resultSet.getString("MEMAIL")); } //关闭文档流 super.closeAll(connection, preparedStatement, resultSet); return membersInfo; } @Override public void updateInfo(MembersInfo membersInfo) { String sql = "UPDATE membersinfo SET MNAME=?,MGENDER=?,MAGE=?,MADDRESS=?,MEMAIL=? WHERE MID=?;"; this.executeUpdate(sql, membersInfo.getName(), membersInfo.getGender(), membersInfo.getAge(), membersInfo.getAddress(), membersInfo.getEmail(), membersInfo.getId()); } }