admin_manager.java

这是基于jsp的任务管理系统

package cn.project.bit.business;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Vector;
import cn.project.bit.DBQuery.DataProcess;
import cn.project.bit.Object.Admin;



public class Admin_Manager {

	
	public static boolean CheckAdmin(String admin_name,String admin_password)
	{
		try
		{
			admin_name=new String(admin_name.getBytes("ISO8859_1"));
		
	
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query = "select count(*) from admin where admin_name='"+admin_name+
						"' and admin_password='"+admin_password+"'";
		
		int count = DataProcess.nCount(query);
		
		
		if(count>0)
		{
			return true;
		}
		else
			return false;
	}
	
	public static boolean HasAdmin(String username)
	{
		
		
		String query = "select count(*) from admin where admin_name='"+username+"'";

		int count = DataProcess.nCount(query);


		if(count>0)
		{
			return true;
		}
		else
			return false;
	}
	
	public static void add_Admin(String admin_name,String admin_password)
	{
	
		String query = "insert into admin(admin_name,admin_password) values('"+admin_name+
						"','"+admin_password+"')";
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Edit_Admin(int ID,String admin_name,String admin_password)
	{
		
		
		String query = "update admin set admin_name='"+admin_name+
		"',admin_password='"+admin_password+"' where admin_id="+ID;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Delete_Admin(int ID)
	{
		String query =  "delete from admin where admin_id="+ID;
		System.out.println(query);
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	
	public static Admin getAdmin(int ID)
	{
		String query = "select * from admin where admin_id="+ID;
		
		Connection con = DataProcess.getConnection();
		
		Admin ad = Admin.getInstance();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			if(rs.next())
			{				
				int admin_id=rs.getInt("admin_id");
				String admin_name = rs.getString("admin_name");
				
				String admin_password = rs.getString("admin_password");
								
				
				ad.setId(admin_id);
				
				ad.setAdmin_name(admin_name);
				
				ad.setAdmin_password(admin_password);
				
				
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return ad;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
	}

	public static ArrayList getAdmin()
	{
		String query = "select * from admin";
		
		Connection con = DataProcess.getConnection();
		
		ArrayList al = new ArrayList();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{				
				int admin_id=rs.getInt("admin_id");
				
				String admin_name = rs.getString("admin_name");
				
				
				String admin_password = rs.getString("admin_password");
				
				Admin ad = Admin.getInstance();
				
				ad.setId(admin_id);
				ad.setAdmin_name(admin_name);
				
				ad.setAdmin_password(admin_password);
				
				al.add(ad);
				System.out.println("admin_id="+admin_id);
				System.out.println("admin_name="+admin_name);
			System.out.println("admin_password="+admin_password);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return al;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
		
		
	}
	
}