package com.qiming.jspch20.model.manager;

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

import com.qiming.jspch20.model.dao.DAOFactory;
import com.qiming.jspch20.model.dao.IDepartmentDAO;
import com.qiming.jspch20.model.dao.IUserInfoDAO;
import com.qiming.jspch20.model.utils.DButils;
import com.qiming.jspch20.vo.DepartmentVO;
import com.qiming.jspch20.vo.UserInfoVO;

public class BaseDataManager {

	private IUserInfoDAO userdao =DAOFactory.getUserInfoDAO();
	private IDepartmentDAO depdao=DAOFactory.getDepartmentDAO();
	
	public void adddata(){
		UserInfoVO user=new UserInfoVO();
		DepartmentVO dep=new DepartmentVO();
		List<DepartmentVO> departList =new ArrayList<DepartmentVO>();
		DButils dbutils =null;	
		try {
			dbutils =new MyDButils(true,departList);
			depdao.findDepartmentVO(dbutils);
			userdao.addUserInfo(user, dbutils);
			depdao.findDepartmentVO(dbutils);
			dbutils.commit(true);
		} catch (SQLException e) {
			try {
				if(dbutils!=null){
				  dbutils.commit(false);
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			if(dbutils!=null){
				dbutils.free();
			}
		}
	}
	
	
	class MyDButils extends DButils{

		private  List<DepartmentVO> departList;
		public MyDButils(boolean requriedTx,final List<DepartmentVO> departList) throws SQLException {
			super(requriedTx);
			this.departList = departList;
		}
		
		@Override
		public void mapData(ResultSet rst) throws SQLException{
			
			while(rst.next()){
				////
				DepartmentVO depart=new DepartmentVO();
				//setvalues;
				departList.add(depart);
			}
		}
		
		
		
	}
	
}