popedomdao.java

简单的员工管理

package com.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import com.bean.DepBean;
import com.bean.PopedomBean;
import com.db.DBConnection;

public class PopedomDao 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 popedom";
		PreparedStatement ps=null;
		ResultSet rst=null;
		Vector vc=new Vector();
		
		try {
			ps=conn.prepareStatement(sql);
			rst=ps.executeQuery();
			while(rst.next())
			{
				PopedomBean pb=new PopedomBean();
				pb.setId(rst.getString(1));
				pb.setName(rst.getString(2));
				vc.add(pb);
			}
		} 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;
	}

}