javaweb程序设计综合测评A卷.zip

package com.vip.Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.vip.Model.Vip; import com.vip.Utils.DBUtils; public class VipDao { Connection conn =null; ResultSet rs=null; PreparedStatement smt=null; //查询所有的VIP用户信息 public List<Vip> queryAllVip(){ conn = DBUtils.getConn(); String sql = "select * from tb_vip"; try { smt = conn.prepareStatement(sql); rs = smt.executeQuery(); List<Vip> vipList = new ArrayList<Vip>(); if(rs!=null) { while(rs.next()) { vipList.add(new Vip(rs.getInt("id"), rs.getString("phone"), rs.getString("name"), rs.getString("gender"), rs.getDate("openDate"), rs.getDouble("balance"))); } } return vipList; } catch (SQLException e) { e.printStackTrace(); }finally { DBUtils.CloseConn(conn, rs, smt); } return null; } //添加VIP用户信息 public boolean addVipInfo(Vip vip) { conn = DBUtils.getConn(); String sql = "insert into tb_vip values(null,?,?,?,?,?)"; try { smt = conn.prepareStatement(sql); smt.setString(1, vip.getPhone()); smt.setString(2, vip.getName()); smt.setString(3, vip.getGender()); smt.setDate(4, vip.getOpenDate()); smt.setDouble(5, vip.getBalance()); //执行sql语句 int result = smt.executeUpdate(); if(result>0) { return true; } } catch (SQLException e) { e.printStackTrace(); }finally { DBUtils.CloseConn(conn, rs, smt); } return false; } }