package com.xaccp.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;
import java.util.Vector;
import com.xaccp.dbmanger.DBManager;
import com.xaccp.vo.DempVO;

public class DempDAO {
	//所有
	public List getAllTree(){
		Connection con=DBManager.createConnection();
		String sql="select * from demp";
		try {
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery(sql);
			List list=new Vector();
			while(rs.next()){
				DempVO dvo=new DempVO();
				dvo.setId(rs.getInt("id"));
				dvo.setFatherid(rs.getInt("fatherid"));
				dvo.setDemp(rs.getString("demp"));
				list.add(dvo);
			}
			rs.close();
			stmt.close();
			con.close();
			return list;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	//按id查找
	public DempVO findById(int id){
		Connection con=DBManager.createConnection();
		String sql="select * from demp where id=?";
		try {
			PreparedStatement ps=con.prepareStatement(sql);
			ResultSet rs=ps.executeQuery();
			DempVO dvo=new DempVO();
			if(rs.next()){
				dvo.setId(rs.getInt("id"));
				dvo.setFatherid(rs.getInt("fatherid"));
				dvo.setDemp(rs.getString("demp"));
			}
			rs.close();
			ps.close();
			con.close();
			return dvo;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
}