votedao.java

一个非常好的投票系统,可以用来参考扩展成商用投票系统

package com.vote.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.ArrayList;

import com.vote.dto.VoteDTO;
import com.vote.interfacer.VoteInterface;
import com.vote.vo.VoteVO;

public class VoteDAO implements VoteInterface {

	public int CreaterVote(Connection con, VoteDTO voteDTO) throws SQLException {
		// TODO Auto-generated method stub
		String strSQL="insert into vote_info(Vote_title,Vote_admin_username,Vote_type,Vote_mode,Vote_time)" +
				" values(?,?,?,?,?)";
		PreparedStatement ps = con.prepareStatement(strSQL);
		int nIndex = 1;
		ps.setString(nIndex++, voteDTO.getVote_title());
		ps.setString(nIndex++, voteDTO.getVote_admin_username());
		ps.setString(nIndex++, voteDTO.getVote_type());
		ps.setString(nIndex++, voteDTO.getVote_mode());
		ps.setString(nIndex++, voteDTO.getVote_time());
		return ps.executeUpdate();
	}

	public int DeleteVote(Connection con, int Vote_id) {
		// TODO Auto-generated method stub
		return 0;
	}

	public ArrayList OneVoteInfo(Connection con, int Vote_id) throws SQLException {
		// TODO Auto-generated method stub
		String strSQL=" select * from vote_info where Vote_id= ?";
		PreparedStatement ps = con.prepareStatement(strSQL);
		
		int nIndex = 1;
		ps.setInt(nIndex++,  Vote_id);
		ResultSet rs = ps.executeQuery();
		ArrayList alist = new ArrayList();
		while(rs!=null&&rs.next())
		{
			VoteVO voteVO = new VoteVO();
			voteVO.setVote_title(rs.getString("vote_title"));
			voteVO.setVote_type(rs.getString("vote_type"));
			alist.add(voteVO);
		}
		ps.close();
		rs.close();
		con.close();
		return  alist;
	}
	public ArrayList AllVoteInfo(Connection con) throws SQLException {
		// TODO Auto-generated method stub
		String strSQL=" select * from vote_info ";
		PreparedStatement ps = con.prepareStatement(strSQL);
		System.out.println(strSQL);
		
		ResultSet rs = ps.executeQuery();
		ArrayList alist = new ArrayList();
		while(rs!=null&&rs.next())
		{
			VoteVO voteVO = new VoteVO();
			voteVO.setVote_id(rs.getInt("vote_id"));
			voteVO.setVote_title(rs.getString("vote_title"));
			voteVO.setVote_admin_username(rs.getString("vote_admin_username"));
			voteVO.setVote_mode(rs.getString("vote_mode"));
			voteVO.setVote_type(rs.getString("vote_type"));
			voteVO.setVote_time(rs.getString("vote_time"));
			voteVO.setVote_file_path(rs.getString("vote_file_path"));
			alist.add(voteVO);
		}
		return  alist;
	}

	public int PublishVote(Connection con, int Vote_id) {
		// TODO Auto-generated method stub
		return 0;
	}

	public int UpdateVote(Connection con, int Vote_id) {
		// TODO Auto-generated method stub
		return 0;
	}

	public ArrayList UserVoteInfo(Connection con, String Vote_admin_username) throws SQLException {
		// TODO Auto-generated method stub
		String strSQL=" select * from vote_info where Vote_admin_username = ? ";
		PreparedStatement ps = con.prepareStatement(strSQL);
		ps.setString(1, Vote_admin_username);
		System.out.println(strSQL);
		ResultSet rs = ps.executeQuery();
		ArrayList alist = new ArrayList();
		while(rs!=null&&rs.next())
		{
			VoteVO voteVO = new VoteVO();
			voteVO.setVote_id(rs.getInt("vote_id"));
			voteVO.setVote_title(rs.getString("vote_title"));
			voteVO.setVote_admin_username(rs.getString("vote_admin_username"));
			voteVO.setVote_mode(rs.getString("vote_mode"));
			voteVO.setVote_type(rs.getString("vote_type"));
			voteVO.setVote_time(rs.getString("vote_time"));
			voteVO.setVote_file_path(rs.getString("vote_file_path"));
			alist.add(voteVO);
		}
		return  alist;
	}



}