java投票程序开发项目总结_JavaWeb项目开发案例精粹-第2章投票系统-003Dao层

1 packagecom.sanqing.daoImpl;2

3 importjava.sql.Connection;4 importjava.sql.PreparedStatement;5 importjava.sql.ResultSet;6 importjava.sql.SQLException;7 importjava.util.ArrayList;8 importjava.util.List;9

10 importcom.sanqing.bean.Vote;11 importcom.sanqing.dao.VoteDAO;12 importcom.sanqing.util.DBConnection;13 importcom.sanqing.util.Page;14

15 public class VoteDAOImpl implementsVoteDAO{16

17 public voidaddVote(Vote vote) {18 Connection conn = DBConnection.getConnection(); //获得连接对象

19 String addSQL = "insert into " +

20 "tb_vote(voteName,channelID) values(?,?)";21 PreparedStatement pstmt = null; //声明预处理对象

22 try{23 pstmt = conn.prepareStatement(addSQL); //获得预处理对象并赋值

24 pstmt.setString(1, vote.getVoteName()); //设置投票名称

25 pstmt.setInt(2, vote.getChannelID()); //设置频道ID

26 pstmt.executeUpdate(); //执行添加

27 } catch(SQLException e) {28 e.printStackTrace();29 } finally{30 DBConnection.close(pstmt); //关闭预处理对象

31 DBConnection.close(conn); //关闭连接对象

32 }33 }34

35 public void deleteVote(intvoteID) {36 Connection conn = DBConnection.getConnection(); //获得连接对象

37 String deleteSQL = "delete from tb_vote where voteID=?";38 PreparedStatement pstmt = null; //声明预处理对象

39 try{4