depdao.java

简单的员工管理

package com.dao;

import java.util.Vector;

import com.bean.DepBean;
import com.db.*;
import java.sql.*;


public class DepDao implements IDao {

	public boolean delete(String id) {
		// TODO Auto-generated method stub
		return false;
	}

	public Object findById(String id) {
		// TODO Auto-generated method stub
		return null;
	}

	public boolean save(Object ob) {
		// TODO Auto-generated method stub
		return false;
	}


	public boolean update(Object ob) {
		// TODO Auto-generated method stub
		return false;
	}

	public Vector findAll() {
		DBConnection dbconn=DBConnection.getDBConnection();
		Connection conn=dbconn.getConn();
		String sql="select * from dep";
		PreparedStatement ps=null;
		ResultSet rst=null;
		Vector vc=new Vector();
		
		try {
			ps=conn.prepareStatement(sql);
			rst=ps.executeQuery();
			while(rst.next())
			{
				DepBean db=new DepBean();
				db.setId(rst.getString(1));
				db.setName(rst.getString(2));
				vc.add(db);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(rst!=null)
				{
					rst.close();
				}
				if(ps!=null)
				{
					ps.close();
				}
				if(conn!=null)
				{
					conn.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return vc;
	}

}