admindao.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.AdminDTO;
import com.vote.interfacer.AdminInterface;
import com.vote.vo.AdminVO;

public class AdminDAO implements AdminInterface {

	public ArrayList AdminLevel(Connection con, String Vote_admin_username) throws SQLException {
		// 判断管理员的级别
		String strSQL="select Vote_admin_level from admin where Vote_admin_username=?";
		PreparedStatement ps = con.prepareStatement(strSQL);
		int nIndex = 1;
		ps.setString(nIndex++, Vote_admin_username);
		ResultSet rs = ps.executeQuery();
		con.close();
		return null;
	}

	public int DelAdmin(Connection con, int Vote_admin_id) throws SQLException {
		//删除管理员 
		String strSQL="delete from admin where Vote_admin_id=?";
		PreparedStatement ps = con.prepareStatement(strSQL);
		int nIndex = 1;
		ps.setInt(nIndex++, Vote_admin_id);
		con.close();
		return ps.executeUpdate();
	}

	public ArrayList Login(Connection con, AdminDTO adminDTO) throws SQLException {
		//管理员登陆
		String strSQL=" select * from admin where Vote_admin_username=? and Vote_admin_password=?";
		PreparedStatement ps = con.prepareStatement(strSQL);
		AdminVO avo = new AdminVO();
		System.out.println(strSQL);
		int nIndex = 1;
		ps.setString(nIndex++, adminDTO.getLogin());
		ps.setString(nIndex++,adminDTO.getPassword() );
		ResultSet rs = ps.executeQuery();
		ArrayList alist = new ArrayList();
		while(rs!=null&&rs.next())
		{
			
			avo.setVote_admin_id(rs.getInt("Vote_admin_id"));
			avo.setVote_admin_username(rs.getString("Vote_admin_username"));
			avo.setVote_admin_level(rs.getInt("Vote_admin_level"));
			avo.setVote_admin_password(rs.getString("vote_admin_password"));
			avo.setVote_admin_ip(rs.getString("Vote_admin_ip"));
			avo.setVote_admin_registtime(rs.getString("Vote_admin_registtime"));
			avo.setVote_admin_logincount(rs.getInt("Vote_admin_logincount"));
			alist.add(avo);
		}
		ps.close();
		rs.close();
		con.close();
		return alist;
	}

	public int Reg(Connection con, AdminDTO adminDTO) throws SQLException {
		// 普通管理注册
		String strSQL="insert into admin(Vote_admin_username,Vote_admin_password) value(?,?)";
		PreparedStatement ps = con.prepareStatement(strSQL);
		int nIndex = 1;
		ps.setString(nIndex++, adminDTO.getLogin());
		ps.setString(nIndex++, adminDTO.getPassword());
		con.close();
		return ps.executeUpdate();
	}

	public int grantAdmin(Connection con, int Vote_admin_id) throws SQLException {
		// 给普通管理员授权
		String strSQL="update admin set Vote_admin_level=2 where Vote_admin_id = ?";
		PreparedStatement ps = con.prepareStatement(strSQL);
		int nIndex = 1;
		ps.setInt(nIndex++, Vote_admin_id);
		con.close();
		return ps.executeUpdate();
	}



}