List<Person> list = new ArrayList<>();

Person p = new Person();

try {

            Class.forName("oracle.jdbc.driver.OracleDriver");

            con = DriverManager.getConnection(dbURL, userName, userPwd);

            System.out.println("加载数据库驱动成功！");

            System.out.println("数据库连接成功！");

            st = con.createStatement();

            rs = st.executeQuery(sql);
            while (rs.next()) {

　　　　　　　　　 Person p = new Person();
                p.setId(rs.getString("code"));
                p.setName(rs.getString("name"));
                p.setCode(rs.getString("code"));
                p.setCardid(rs.getString("cardid"));
                p.setSex(rs.getString("sex"));
                p.setBirthday( rs.getString("birthday"));
                p.setPhone(rs.getString("phone"));
                p.setCorp_code(rs.getString("corp_code"));
                p.setDept_code(rs.getString("dept_code"));
                p.setPk_psndoc(rs.getString("pk_psndoc"));

         　　　　list.add(p);

    　　　　}
}catch(Exception e){
    //System.out.println("找不到驱动程序类，加载驱动失败！");
    e.printStackTrace();
}