package com.dao;


import java.sql.*;
import java.util.ArrayList;

import com.data.*;
import com.db.*;
import com.tools.Pageable;

public class AdminDao {
	//增加管理員信息
	public static boolean Add_Admin(String adminname,String adminpwd){
		String query="insert into admin(adminname,adminpwd) values('"+adminname+"','"+adminpwd+"')";
		
		return	DataProcess.ExeQuery(query);
			
	}
	//修改管理員信息
	public static boolean Edit_Admin(String adminname,String adminpwd,int admin_id){
		String query="update admin set adminname='"+
		              adminname+"',adminpwd='"+adminpwd+"'where admin_id="+admin_id;
		
		return	DataProcess.ExeQuery(query);
			
	}
	//刪除管理員信息
    public static boolean Delete_Admin(int admin_id){
    	String query="delete from admin where admin_id="+admin_id;
    	
		return	DataProcess.ExeQuery(query);
    }
    //根據id獲取用戶信息
    public static Admin getAdmin(int admin_id){
    	String sql="select * from admin where admin_id="+admin_id;
        Connection con=DataProcess.getConnection(); 
        Statement pStmt=null;
    	ResultSet rs=null;
        Admin admin=new Admin();
        try{
        	pStmt=con.createStatement();
        	rs=pStmt.executeQuery(sql);
        	if(rs.next()){
        		String adminname=rs.getString("adminname");
        		String adminpwd=rs.getString("adminpwd");
        	    admin.setAdmin_id(admin_id);
        	    admin.setAdminname(adminname);
        	    admin.setAdminpwd(adminpwd);
        	    System.out.println("查詢的密碼"+adminpwd);
        	}
        	
        	return admin;
        }catch(Exception e){
        	e.printStackTrace();
        	return null;
        }finally{
        	try {
				rs.close();
			    pStmt.close();
        	    con.close();
        	} catch (SQLException e) {
				
				e.printStackTrace();
			}
        }
    }
    
     //根據名稱獲取用戶信息   	
    public static Admin getAdmin(String name){
    	String sql="select * from admin where adminname='"+name+"'";
        Connection con=DataProcess.getConnection(); 
        Statement pStmt=null;
    	ResultSet rs=null;
        Admin admin=null;
        try{
        	pStmt=con.createStatement();
        	rs=pStmt.executeQuery(sql);
        	
        	if(rs.next()){
        		admin=new Admin();
        		int  admin_id=rs.getInt("admin_id");
        		String adminpwd=rs.getString("adminpwd");
        	    admin.setAdmin_id(admin_id);
        		admin.setAdminname(name);
        	    admin.setAdminpwd(adminpwd);
        	    System.out.println("查詢的密碼"+adminpwd);
        	}
        	
        	return admin;
        }catch(Exception e){
        	e.printStackTrace();
        	return null;
        }finally{
        	try {
				rs.close();
			    pStmt.close();
        	    con.close();
        	} catch (SQLException e) {
				
				e.printStackTrace();
			}
        }
    }
   
}