Spring与Hibernate Dao中操作数据库的另外方式

1. // search Person Object
2.     /**
3.      * @param firstname
4.      * @param lastname
5.      * @return
6.      */
7.     public List searchPerson(final String firstname, final String lastname) {
8.         return getHibernateTemplate().executeFind(new HibernateCallback() {
9.             public Object doInHibernate(Session session)
10.                     throws HibernateException, SQLException {
11.                 List list = new ArrayList();
13.                 String sql = " select  pid,firstname,lastname   from person where  firstname like  '"
14.                         + firstname
15.                         + "%' and lastname like '"
16.                         + lastname
17.                         + "%' order by  lastname;";
20.                 PreparedStatement pstmt = null;
21.                 Connection conn = null;
22.                 ResultSet rs = null;
24.                 try {
26.                     conn = session.connection();
27.                     pstmt = conn.prepareStatement(sql);
28.                     rs = pstmt.executeQuery();
30.                     while (rs != null && rs.next()) {
32.                         String pid = rs.getString(1);
33.                         String firstname = rs.getString(2);
34.                         String lastname = rs.getString(3);
35.                         Person person = new Person();
36.                         person.setPid(pid);
37.                         person.setFirstname(firstname);
38.                         person.setLastname(lastname);
40.                         list.add(person);
42.                     }
44.                 } catch (Exception e) {
45.                     log.error(e);
46.                 } finally {
47.                     try {
48.                         if (rs != null)
49.                             rs.close();
50.                     } catch (Exception e) {
51.                         log.error(e);
52.                     } finally {
53.                         try {
54.                             if (pstmt != null)
55.                                 pstmt.close();
56.                         } catch (Exception e) {
57.                             log.error(e);
58.                         }
60.                     }
61.                 }
62.                 return list;
63.             }
64.         });
65.     }