votebiz.java

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

package com.vote.biz;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.sql.DataSource;

import com.vote.dao.SelectDAO;
import com.vote.dao.VoteDAO;
import com.vote.dto.SelectDTO;
import com.vote.dto.VoteDTO;



public class VoteBIZ 
{
	public ArrayList queryVotes(DataSource ds) throws SQLException
	{
		Connection con = ds.getConnection();
		VoteDAO voteDAO = new VoteDAO();
		return voteDAO.AllVoteInfo(con);	
	}
	
	public ArrayList UserVoteInfo(DataSource ds,String Vote_admin_username) throws SQLException
	{
		Connection con = ds.getConnection();
		VoteDAO voteDAO = new VoteDAO();
		return voteDAO.UserVoteInfo(con, Vote_admin_username);
	}
	public ArrayList OneVoteInfo(DataSource ds,int Vote_id) throws SQLException
	{
		Connection con = ds.getConnection();
		VoteDAO voteDAO = new VoteDAO();
		return voteDAO.OneVoteInfo(con, Vote_id);
	}
	public int CreaterVote(DataSource ds, VoteDTO voteDTO) throws SQLException 
	{
		Connection con = ds.getConnection();
		VoteDAO voteDAO = new VoteDAO();
		return voteDAO.CreaterVote(con, voteDTO);	
	}
	public int AddVoteItem(DataSource ds, SelectDTO selectDTO) throws SQLException
	{
		Connection con = ds.getConnection();
		SelectDAO selectDAO = new SelectDAO();
		return selectDAO.AddVoteItem(con, selectDTO);
	}
	public ArrayList ShowVoteItem(DataSource ds, int Vote_id) throws SQLException
	{
		Connection con = ds.getConnection();
		SelectDAO selectDAO = new SelectDAO();
		return selectDAO.ShowVoteItem(con, Vote_id);
		
	}
	
	
}