package cn.handson.beans;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.faces.context.FacesContext;
import javax.servlet.http.HttpServletRequest;

import cn.handson.util.ConnectionFactory;

public class Employee extends ConnectionFactory {
	private Integer empid;
	private String empname;
	private Integer empage;
	public Integer getEmpid() {
		return empid;
	}
	public void setEmpid(Integer empid) {
		this.empid = empid;
	}
	public String getEmpname() {
		return empname;
	}
	public void setEmpname(String empname) {
		this.empname = empname;
	}
	public Integer getEmpage() {
		return empage;
	}
	public void setEmpage(Integer empage) {
		this.empage = empage;
	}
	
	public Employee(){
		FacesContext context=FacesContext.getCurrentInstance();
		HttpServletRequest request=(HttpServletRequest)context.getExternalContext().getRequest();
		String id=request.getParameter("empid");
		if(id!=null){
			System.out.println(id);
			getEmployee(id);
		}
	}
	public Employee(int i){

	}
	
	public String add(){
		try{
			String sql="insert into Employee values('"+empname+"',"+empage+")";
			executeUpdate(sql);
			closeCon();
		}catch(Exception e){
			e.printStackTrace();
		}
		return "success";
	}
	
	public String modify(){
		try{
			String sql="update Employee set empname='"+empname+"',empage="+empage+" where empid="+empid;
			executeUpdate(sql);
			closeCon();
		}catch(Exception e){
			e.printStackTrace();
		}
		return "success";
	}
	
	public String del(){
		try{
			String sql="delete from Employee where empid="+empid;
			executeUpdate(sql);
			closeCon();
		}catch(Exception e){
			e.printStackTrace();
		}
		return "success";
	}
	
	public List<Employee> getList(){
		List<Employee> list=new ArrayList<Employee>();
		
		try{
			String sql="select * from Employee";
			ResultSet rs=executeQuery(sql);
			while(rs.next()){
				Employee emp=new Employee(1);
				emp.setEmpid(rs.getInt("empid"));
				emp.setEmpname(rs.getString("empname"));
				emp.setEmpage(rs.getInt("empage"));
				list.add(emp);
			}
			closeCon(rs);
		}catch(Exception e){
			e.printStackTrace();
		}		
		return list;
	}
	
	public String selectByid(){
		FacesContext context=FacesContext.getCurrentInstance();
		HttpServletRequest request=(HttpServletRequest)context.getExternalContext().getRequest();
		String id=request.getParameter("empid");
		System.out.println(id);
		getEmployee(id);
		return "success";
	}
	
	private void getEmployee(String empid){
		try{
			String sql="select * from Employee where empid="+empid;
			ResultSet rs=executeQuery(sql);
			while(rs.next()){
				this.empid=rs.getInt("empid");
				this.empname=rs.getString("empname");
				this.empage=rs.getInt("empage");
			}
			closeCon(rs);
		}catch(Exception e){
			e.printStackTrace();
		}
	}

}