Hibernate Synchronizer
下載地址:
http://sourceforge.net/project/showfiles.php?group_id=99370

備份一下主鍵id映射:??
int????????? native?????????? int primary key identity(1,1)
String??? uuid.hex?????? varchar(n)/char(n) primary key
int????????? assigned?????? int primary key

//分頁
Criteria criteria = session.createCriteria(Article.class);
criteria.setFirstResult(first);
criteria.setFetchSize(recordsNum);
//criteria.setMaxResults(recordsNum);
//分組和統計
criteria.setProjection(Projections.groupProperty("age"));
//多條件的分組統計
ProjectionList pList = Projections.projectionList();
pList.add(Projections.groupProperty("age"));
pList.add(Projections.rowCount());
criteria.setProjection(pList);
//排序
criteria.addOrder(Order.desc("id"));
criteria.addOrder(Order.asc("id"));

????Article?article? = ? new ?Article();
???? // ????article.setId(3);
????????article.setTitle( " mytitle " );
????????article.setContent( " mycontent " );
????????Configuration?c? = ? new ?Configuration();
????????c.configure();
????????SessionFactory?sf? = ?c.buildSessionFactory();
????????Session?s? = ?sf.openSession();
????????s.beginTransaction();
????????s.save(article);
????????s.flush();
???????? try {
????????????s.connection().commit();
????????} catch (Exception?e) {
????????????System.out.println( " Exceptionee.. " );
????????}
????????s.close();

Resource?ac? = ? new ?ClassPathResource( " /applicationContext.xml " );
????????XmlBeanFactory?xbf? = ? new ?XmlBeanFactory(ac);
????????IManagerArticleDao?dao? = ?(IManagerArticleDao)xbf.getBean( " DAO " );