holderdao.java~1~

来自「这是java编写宠物医院项目」· JAVA~1~ 代码 · 共 82 行

 package holder;
 import java.sql.*;
 import java.util.*;
 import jdbc.*;

public class HolderDAO {
    public HolderDAO() {
    }
    public Collection holde_select(){
        ArrayList al =new ArrayList(10);
        try{
            Statement stmt=JDBC.getConnection().createStatement();
            ResultSet rs=stmt.executeQuery("select * from holder_info");
            while(rs.next()){
                HolderVO hvo=new HolderVO();
                hvo.setId(rs.getInt(1));
                hvo.setName(rs.getString(2));
                hvo.setSex(rs.getString(3));
                hvo.setAge(rs.getInt(4));
                hvo.setAddress(rs.getString(5));
                hvo.setTime(rs.getString(6));
                al.add(hvo);
            }
            rs.close();
            stmt.close();
        }catch(SQLException ex){
            ex.printStackTrace();
        }
        return al;
    }


//    public Map holde_select() {
//        Map map = null;
//        Statement stmt = null;
//        ResultSet rs = null;
//        try{
//            stmt = JDBC.getConnection().createStatement();
//            rs = stmt.executeQuery("select * from Holder_info");
//            if (rs.next()){
//                map = new HashMap();
//                do{
//                    HolderVO hvo=new HolderVO();
//                    hvo.setId(rs.getInt(1));
//                    hvo.setName(rs.getString(2));
//                    hvo.setSex(rs.getString(3));
//                    hvo.setAge(rs.getInt(4));
//                    hvo.setAddress(rs.getString(5));
//                    hvo.setTime(rs.getString(6));
//                    map.put(rs.getObject(1),hvo);
//                }while(rs.next());
//            }
//        }catch(SQLException ex){
//            ex.printStackTrace();
//        }finally{
//            if(stmt!=null){
//                try{
//                    stmt.close();
//                }catch(SQLException ex1){
//                }
//            }
//            if(rs!=null){
//                try{
//                    rs.close();
//                }catch(SQLException ex2){
//                }
//            }
//        }
//        return map;
//    }
    public static void main(String[] args){
        System.out.println("sdfgdfsgdfg.........");
        HolderDAO dao=new HolderDAO();
        Iterator it=dao.holde_select().iterator();
        while(it.hasNext()){
        System.out.println(it.next().toString());
        }
    }

}