Spring+hibernate+DWR整合

首先，建一个web project,然后添加对hibernate和spring的支持，我们使用的是hibernate3.1和spring2.0,然后导入dwr.jar和commons-pool-1.3.jar(不知道myeclipse怎么搞的，添加Spring功能支持的时候就有了commons-dbcp.jar，居然没有其依赖的commons-pool-x.jar，只好单独添加了，另外，需要将Spring2.0 AOP Liberaries里的asm2.2.3.jar删除，因为好像和Hiberate中的生成代理用的asm.jar冲突，我把Spring2.0 AOP Liberaries排到最后仍然有冲突，所以只好删掉了，不知道大家遇到过这种情况么)。
我们使用myeclise自带的Derby数据库，在里面建一个表BOOK：
ID bigint primary key,autoincrement
NAME varchar(20)
ISBM varchar(20)
AUTHOR varchar(15)
然后利用myeclipse的hibernate反向工程生成领域模型：Book.java, DAO:BookDAO.jar, Book 的映射文件Book.hbm.xml：
生成的代码及配置文件如下:
Book.java:

2. package edu.jlu.fuliang.domain;
3. /** *//**
4.  * Book generated by MyEclipse Persistence Tools
5.  */
7. public class Book implements java.io. {
9.     // Fields
11.     private  id;
12.     private  name;
13.     private  isbm;
14.     private  author;
16.     // Constructors
18.     /** *//** default constructor */
19.     public Book() {
20.     }
22.     /** *//** minimal constructor */
23.     public Book( id,  name,  isbm) {
24.         this.id = id;
25.         this.name = name;
26.         this.isbm = isbm;
27.     }
29.     /** *//** full constructor */
30.     public Book( id,  name,  isbm,  author) {
31.         this.id = id;
32.         this.name = name;
33.         this.isbm = isbm;
34.         this.author = author;
35.     }
37.     // Property accessors
39.     public  getId() {
40.         return this.id;
41.     }
43.     public void setId( id) {
44.         this.id = id;
45.     }
47.     public  getName() {
48.         return this.name;
49.     }
51.     public void setName( name) {
52.         this.name = name;
53.     }
55.     public  getIsbm() {
56.         return this.isbm;
57.     }
59.     public void setIsbm( isbm) {
60.         this.isbm = isbm;
61.     }
63.     public  getAuthor() {
64.         return this.author;
65.     }
67.     public void setAuthor( author) {
68.         this.author = author;
69.     }
70.     public  toString(){
71.         return "[id=" + id + ",name=" + name + ",isbm=" + isbm + ",author=" + author + "]";
72.     }
73. }

edu.jlu.fuliang.dao.BookDAO.java:

1. package edu.jlu.fuliang.dao;
3. import java.util.;
4. import org.apache.commons.logging.;
5. import org.apache.commons.logging.;
6. import org.hibernate.LockMode;
7. import org.springframework.context.ApplicationContext;
8. import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
10. import edu.jlu.fuliang.domain.Book;
12. /** *//**
13.  * Data access object (DAO) for domain model class Book.
14.  * 
15.  * @see edu.jlu.fuliang.domain.Book
16.  * @author MyEclipse Persistence Tools
17.  */
19. public class BookDAO extends HibernateDaoSupport ...{
20.     private static final  log = .getLog(BookDAO.class);
21.     // property constants
22.     public static final  NAME = "name";
23.     public static final  ISBM = "isbm";
24.     public static final  AUTHOR = "author";
26.     protected void initDao() ...{
27.         // do nothing
28.     }
30.     public void save(Book transientInstance) ...{
31.         log.debug("saving Book instance");
32.         try ...{
33.             getHibernateTemplate().save(transientInstance);
34.             log.debug("save successful");
35.         } catch ( re) ...{
36.             log.error("save failed", re);
37.             throw re;
38.         }
39.     }
41.     public void delete(Book persistentInstance) ...{
42.         log.debug("deleting Book instance");
43.         try ...{
44.             getHibernateTemplate().delete(persistentInstance);
45.             log.debug("delete successful");
46.         } catch ( re) ...{
47.             log.error("delete failed", re);
48.             throw re;
49.         }
50.     }
52.     public Book findById(java.lang. id) ...{
53.         log.debug("getting Book instance with id: " + id);
54.         try ...{
55.             Book instance = (Book) getHibernateTemplate().get(
56.                     "edu.jlu.fuliang.domain.Book", id);
57.             return instance;
58.         } catch ( re) ...{
59.             log.error("get failed", re);
60.             throw re;
61.         }
62.     }
64.     public  findByExample(Book instance) ...{
65.         log.debug("finding Book instance by example");
66.         try ...{
67.              results = getHibernateTemplate().findByExample(instance);
68.             log.debug("find by example successful, result size: "
69.                     + results.size());
70.             return results;
71.         } catch ( re) ...{
72.             log.error("find by example failed", re);
73.             throw re;
74.         }
75.     }
77.     public  findByProperty( propertyName,  value) ...{
78.         log.debug("finding Book instance with property: " + propertyName
79.                 + ", value: " + value);
80.         try ...{
81.              queryString = "from Book as model where model."
82.                     + propertyName + "= ?";
83.             return getHibernateTemplate().find(queryString, value);
84.         } catch ( re) ...{
85.             log.error("find by property name failed", re);
86.             throw re;
87.         }
88.     }
90.     public  findByName( name) ...{
91.         return findByProperty(NAME, name);
92.     }
94.     public  findByIsbm( isbm) ...{
95.         return findByProperty(ISBM, isbm);
96.     }
98.     public  findByAuthor( author) ...{
99.         return findByProperty(AUTHOR, author);
100.     }
102.     public  findAll() ...{
103.         log.debug("finding all Book instances");
104.         try ...{
105.              queryString = "from Book";
106.             return getHibernateTemplate().find(queryString);
107.         } catch ( re) ...{
108.             log.error("find all failed", re);
109.             throw re;
110.         }
111.     }
113.     public Book merge(Book detachedInstance) ...{
114.         log.debug("merging Book instance");
115.         try ...{
116.             Book result = (Book) getHibernateTemplate().merge(detachedInstance);
117.             log.debug("merge successful");
118.             return result;
119.         } catch ( re) ...{
120.             log.error("merge failed", re);
121.             throw re;
122.         }
123.     }
125.     public void attachDirty(Book instance) ...{
126.         log.debug("attaching dirty Book instance");
127.         try ...{
128.             getHibernateTemplate().saveOrUpdate(instance);
129.             log.debug("attach successful");
130.         } catch ( re) ...{
131.             log.error("attach failed", re);
132.             throw re;
133.         }
134.     }
136.     public void attachClean(Book instance) ...{
137.         log.debug("attaching clean Book instance");
138.         try ...{
139.             getHibernateTemplate().lock(instance, LockMode.NONE);
140.             log.debug("attach successful");
141.         } catch ( re) ...{
142.             log.error("attach failed", re);
143.             throw re;
144.         }
145.     }
147.     public static BookDAO getFromApplicationContext(ApplicationContext ctx) ...{
148.         return (BookDAO) ctx.getBean("BookDAO");
149.     }
150. }

Book.hbm.xml:

1. "1.0" encoding="utf-8"?>
2. "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
3. "">
6.     <class name="edu.jlu.fuliang.domain.Book" table="BOOK" schema="CLASSICCARS">
7.         "id" type="java.lang.Long">
8.             "ID" />
9.             class="identity" />
10.         
11.         "name" type="java.lang.String">
12.             "NAME" length="20" not-null="true" />
13.         
14.         "isbm" type="java.lang.String">
15.             "ISBM" length="20" not-null="true" unique="true" />
16.         
17.         "author" type="java.lang.String">
18.             "AUTHOR" length="15" />
19.         
20.     class>

下面我们配置一下Spring，我们把applicationContext.xml分成了三个，分别是applicationContext-db.xml,applicationContext-dao.xml,applicationContext-service.我们看看如何配置：

applicationContext-db.xml:

1. "1.0" encoding="UTF-8"?>
3.     xmlns=""
4.     xmlns:xsi=""
5.     xsi:schemaLocation=" /spring-beans-2.0.xsd">
7.     "dataSource"
8.         class="org.apache.commons.dbcp.BasicDataSource">
9.         "driverClassName"
10.             value="org.apache.derby.jdbc.ClientDriver">
11.         
12.         "url"
13.             value="jdbc:derby://localhost:1527/myeclipse;create=true">
14.         
15.         "username" value="classiccars">
16.         "password" value="myeclipse">
17.     
18.     "sessionFactory"
19.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
20.         "dataSource">
21.             "dataSource" />
22.         
23.         "hibernateProperties">
24.             
25.                 "hibernate.dialect">
26.                     org.hibernate.dialect.DerbyDialect
27.                 
28.                 "hibernate.show_sql">
29.                    true
30.                 
31.             
32.         
33.         "mappingResources">
34.             
35.                 edujlufuliangdomainBook.hbm.xml
36.             
37.         
38.     

applicationContext-dao.xml:

1. "1.0" encoding="UTF-8"?>
3.     xmlns=""
4.     xmlns:xsi=""
5.     xsi:schemaLocation=" /spring-beans-2.0.xsd">
6.     
7.     "bookDAO" class="edu.jlu.fuliang.dao.BookDAO">
8.         "sessionFactory">
9.             "sessionFactory" />
10.         
11.     

接下来我们来写我们的Service层：

edu.jlu.fuliang.service.BookManageService.java

1. package edu.jlu.fuliang.service;
2. import java.util.;
4. import edu.jlu.fuliang.domain.Book;
6. public interface BookManageService {
7.     public <Book> getAllBooks();
8.     public <Book> getBookByName( name);
9.     public void updateBook(Book book);
10.     public void addBook(Book book);
11.     public void deleteBook(long id);
12. }

edu.jlu.fuliang.service.impl.BookManageServiceImpl.java:

1. package edu.jlu.fuliang.serviceImpl;
3. import java.util.;
5. import org.apache.commons.logging.;
6. import org.apache.commons.logging.;
8. import edu.jlu.fuliang.dao.BookDAO;
9. import edu.jlu.fuliang.domain.Book;
10. import edu.jlu.fuliang.service.BookManageService;
12. public class BookManageServiceImpl implements BookManageService{
13.     private static final  log = .getLog(BookManageServiceImpl.class);
14.     private BookDAO bookDAO;
15.     @Override
16.     public void addBook(Book book) {
17.         bookDAO.save(book);
18.     }
20.     @Override
21.     public void deleteBook(long id) {
22.         Book book = bookDAO.findById(id);
23.         bookDAO.delete(book);
24.     }
26.     @Override
27.     public <Book> getAllBooks() {
28.         return bookDAO.findAll();
29.     }
31.     @Override
32.     public <Book> getBookByName( name) {
33.         return bookDAO.findByName(name);
34.     }
36.     @Override
37.     public void updateBook(Book book) {
38.         log.info(book);
39.         bookDAO.attachDirty(book);
40.     }
42.     public BookDAO getBookDAO() {
43.         return bookDAO;
44.     }
46.     public void setBookDAO(BookDAO bookDAO) {
47.         this.bookDAO = bookDAO;
48.     }
49. }

然后我们来配置Service和事务:

applicationContext-service.xml:

1. "1.0" encoding="UTF-8"?>
3.     xmlns=""
4.     xmlns:xsi=""
5.     xsi:schemaLocation=" /spring-beans-2.0.xsd">
7.     "bookManageServiceTarget" class="edu.jlu.fuliang.serviceImpl.BookManageServiceImpl">
8.         "bookDAO">
9.             "bookDAO"/>
10.         
11.     
12.     "transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
13.         "sessionFactory" ref="sessionFactory"/>
14.     
15.     "bookManageService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
16.         "transactionManager" ref="transactionManager"/>
17.         "target" ref="bookManageServiceTarget"/>
18.         "transactionAttributes">
19.             
20.                 "add*">PROPAGATION_REQUIRED
21.                 "delete*">PROPAGATION_REQUIRED
22.                 "update*">PROPAGATION_REQUIRED
23.                 "get*">PROPAGATION_REQUIRED,readOnly
24.             
25.         
26.     

最后我们来把dwr整合进来:

我们在web.xml添加ContextLoaderListener来加载applicationContext-db.xml,applicationContext-dao.xm,applicationContext-service.xml,以及配置DwrServlet:

web.xml:

1. "1.0" encoding="UTF-8"?>
2. "2.4" 
3.     xmlns="" 
4.     xmlns:xsi="" 
5.     xsi:schemaLocation=" 
6.     http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
7.  
8.      contextConfigLocation
9.      classpath:applicationContext-*.xml
10.  
11.  
12.      class>
13.        org.springframework.web.context.ContextLoaderListener 
14.      class>
15.  
16.  
17.      dwr-invoker
18.      class>org.directwebremoting.servlet.DwrServletclass>
19.      
20.          debug
21.          true
22.      
23.  
24.  
25.      dwr-invoker
26.      /dwr/*
27.  

在dwr.xml中配制bean的创建方式,类型转换,以及Service要暴露的接口:

2.     
3.         
4.         
5.             
6.             
7.             
8.             
9.             
10.             
11.         
12.    

最后,我们编写jsp页面index.jsp:

3.     
4.     
5.     
7.     
8.         var bookCache = ...{};
9.         var currentBook = null;
10.         
11.         function loadAllBooks(){
12.             BookManageService.getAllBooks(handleGetAllBooks,handleGetAllBooksError);
13.         }
14.         function handleGetAllBooks(books){
15.             dwr.util.removeAllRows("booksBody",{ filter:function(tr) ...{
16.       return (tr.id != "pattern");
17.       }});
19.             var book,id;
20.             for(var i = 0; i < books.length; i++){
21.                 book = books[i];
22.                 id = book.id;
23.             
24.                 dwr.util.cloneNode("pattern", { idSuffix:id });
25.                 dwr.util.setValue("t_name" + id, book.name);
26.                 dwr.util.setValue("t_isbm" + id, book.isbm);
27.                 dwr.util.setValue("t_author" + id,book.author);
28.                $("pattern" + id).style.display = "block";
29.                bookCache[id] = book;
30.             }
31.         }
32.         function handleGetAllBooksError(msg){
33.             alert("Error: " + msg);
34.         }
35.         
36.         function addBook(){
37.             var book = ...{name:null,isbm:null,author:null};
38.             dwr.util.getValues(book);
39.             dwr.engine.beginBatch();
40.                  BookManageService.addBook(book);
41.                  loadAllBooks();
42.               dwr.engine.endBatch();
43.         }
44.         
45.         function editBook(btId){
46.             currentBook = bookCache[btId.substring(4)];
47.             dwr.util.setValues(currentBook);
48.         }
49.         
50.         function updateBook(){
51.             var book = {id:null,name:null,isbm:null,author:null}; 
52.             dwr.util.getValues(book);
53.             book.id = currentBook.id;
54.             BookManageService.updateBook(book,handleUpdateBook,handleUpdateBookError);
55.         }
56.         
57.         function handleUpdateBook(){
58.             alert("Update book successfully!");
59.             loadAllBooks();
60.         }
61.         
62.         function handleUpdateBookError(msg){
63.             alert("Error: " + msg);
64.         }
65.         
66.         function deleteBook(btId){
67.             var i = confirm("Are you sure to delete the book?");
68.             if(i == true)
69.                 BookManageService.deleteBook(btId.substring(6),handleDeleteBook,handleDeleteBookError);
70.         }
71.         
72.         function handleDeleteBook(){
73.           alert("The book has been delete successfully!");
74.           loadAllBooks();
75.         }
76.         
77.         function handleDeleteBookError(msg){
78.           alert("Error: " + msg);
79.         }
80.     
84.     
85.         

    Add book

86.         
                
                  
                
                
                  
                  
                 
                
                
                   
                   
               
               
                   
                     
                     
                   
               
           

    Name:
    ISBN:
    Author:

87.     

    

---

    

        

          

              

                  Name

                  ISBN

                  Author

                  Action