日系框架之seasar2（S2JPA之TopLink）

官方网页：http://s2toplink.seasar.org/ja/

接上例http://blog.csdn.net/kunshan_shenbin/archive/2008/09/12/2917360.aspx，并作如下修改：

MySql上新建数据库s2toplinkjpa，并执行如下DDL:

1. SET FOREIGN_KEY_CHECKS=0;
2. -- ----------------------------
3. -- Table structure for dept
4. -- ----------------------------
5. CREATE TABLE `dept` (
6.   `deptno` int(11) NOT NULL,
7.   `active` bit(1) NOT NULL,
8.   `dname` varchar(255) default NULL,
9.   `loc` varchar(255) default NULL,
10.   `versionNo` int(11) NOT NULL,
11.   PRIMARY KEY  (`deptno`)
12. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14. -- ----------------------------
15. -- Table structure for emp
16. -- ----------------------------
17. CREATE TABLE `emp` (
18.   `empno` bigint(20) NOT NULL,
19.   `city` varchar(255) default NULL,
20.   `zip` varchar(255) default NULL,
21.   `comm` float default NULL,
22.   `ename` varchar(255) default NULL,
23.   `hiredate` date default NULL,
24.   `job` varchar(255) default NULL,
25.   `mgr` smallint(6) default NULL,
26.   `sal` float default NULL,
27.   `tstamp` datetime default NULL,
28.   `deptno` int(11) default NULL,
29.   PRIMARY KEY  (`empno`),
30.   KEY `FK110A8F5074ABE` (`deptno`),
31.   CONSTRAINT `FK110A8F5074ABE` FOREIGN KEY (`deptno`) REFERENCES `dept` (`deptno`)
32. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34. -- ----------------------------
35. -- Records 
36. -- ----------------------------
37. INSERT INTO `dept` VALUES ('10', '', 'ACCOUNTING', 'NEW YORK', '0');
38. INSERT INTO `dept` VALUES ('20', '', 'RESEARCH', 'DALLAS', '0');
39. INSERT INTO `dept` VALUES ('30', '', 'SALES', 'CHICAGO', '0');
40. INSERT INTO `dept` VALUES ('40', '', 'OPERATIONS', 'BOSTON', '0');
41. INSERT INTO `emp` VALUES ('7369', 'LAS VEGAS', '110', null, 'SMITH', '1980-12-17', 'CLERK', '7902', '800', '2000-01-01 00:00:00', '20');
42. INSERT INTO `emp` VALUES ('7499', 'MIAMI', '120', '300', 'ALLEN', '1981-02-20', 'SALESMAN', '7698', '1600', '2000-01-01 00:00:00', '30');
43. INSERT INTO `emp` VALUES ('7521', 'WASHINGTON', '130', '500', 'WARD', '1981-02-22', 'SALESMAN', '7698', '1250', '2000-01-01 00:00:00', '30');
44. INSERT INTO `emp` VALUES ('7566', 'IOWA CITY', '140', null, 'JONES', '1981-04-02', 'MANAGER', '7839', '2975', '2000-01-01 00:00:00', '20');
45. INSERT INTO `emp` VALUES ('7654', 'LOS ANGELES', '150', '1400', 'MARTIN', '1981-09-28', 'SALESMAN', '7698', '1250', '2000-01-01 00:00:00', '30');
46. INSERT INTO `emp` VALUES ('7698', 'LOS ANGELES', '160', null, 'BLAKE', '1981-05-01', 'MANAGER', '7839', '2850', '2000-01-01 00:00:00', '30');
47. INSERT INTO `emp` VALUES ('7782', 'WASHINGTON', '170', null, 'CLARK', '1981-06-09', 'MANAGER', '7839', '2450', '2000-01-01 00:00:00', '10');
48. INSERT INTO `emp` VALUES ('7788', 'NEW YORK', '180', null, 'SCOTT', '1982-12-09', 'ANALYST', '7566', '3000', '2005-01-18 13:09:32', '20');
49. INSERT INTO `emp` VALUES ('7839', 'SEATTLE', '190', null, 'KING', '1981-11-17', 'PRESIDENT', null, '5000', '2000-01-01 00:00:00', '10');
50. INSERT INTO `emp` VALUES ('7844', 'NEW YORK', '210', '0', 'TURNER', '1981-09-08', 'SALESMAN', '7698', '1500', '2000-01-01 00:00:00', '30');
51. INSERT INTO `emp` VALUES ('7876', 'SANTA FE', '220', null, 'ADAMS', '1983-01-12', 'CLERK', '7788', '1100', '2000-01-01 00:00:00', '20');
52. INSERT INTO `emp` VALUES ('7900', 'NEW YORK', '230', null, 'JAMES', '1981-12-03', 'CLERK', '7698', '950', '2000-01-01 00:00:00', '30');
53. INSERT INTO `emp` VALUES ('7902', 'SANTA FE', '240', null, 'FORD', '1981-12-03', 'ANALYST', '7566', '3000', '2000-01-01 00:00:00', '20');
54. INSERT INTO `emp` VALUES ('7934', 'IOWA CITY', '250', null, 'MILLER', '1982-01-23', 'CLERK', '7782', '1300', '2000-01-01 00:00:00', '10');

变更jar包一览如下：

aopalliance-1.0.jar
commons-logging-1.1.jar
ejb3-persistence.jar
geronimo-annotation_1.0_spec-1.0.jar
geronimo-ejb_3.0_spec-1.0.jar
geronimo-interceptor_3.0_spec-1.0.jar
geronimo-j2ee_1.4_spec-1.0.jar
javassist-3.4.GA.jar
jboss-archive-browsing-5.0.0alpha-200607201-119.jar
jta-1.1.jar
junit-3.8.2.jar
log4j-1.2.13.jar
mysql-connector-java-5.1.6-bin.jar
ognl-2.6.9-patch-20070908.jar
poi-3.0-FINAL.jar
s2-extension-2.4.29.jar
s2-framework-2.4.29.jar
s2-tiger-2.4.29.jar
s2toplink-jpa-1.0.1.jar
toplink-essentials-2.0.1-09d.jar

 

修改jdbc.dicon

1. <?xml version="1.0" encoding="UTF-8"?>
2. <!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container 2.4//EN" 
3.     "http://www.seasar.org/dtd/components24.dtd">
4. <components namespace="jdbc">
6.     <include path="jta.dicon"/>
7.     <include path="jdbc-extension.dicon"/>
9.     <component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/>
10.     <component class="org.seasar.extension.jdbc.impl.ConfigurableStatementFactory">
11.         <arg>
12.             <component class="org.seasar.extension.jdbc.impl.BasicStatementFactory"/>
13.         </arg>
14.         <property name="fetchSize">100</property>
15.     </component>
17.     <component name="xaDataSource"
18.         class="org.seasar.extension.dbcp.impl.XADataSourceImpl">
19.         <property name="driverClassName">
20.             "com.mysql.jdbc.Driver"
21.         </property>
22.         <property name="URL">
23.             "jdbc:mysql://localhost:3306/s2toplinkjpa"
24.         </property>
25.         <property name="user">"root"</property>
26.         <property name="password">"root"</property>
27.     </component>
29.     <component name="connectionPool"
30.         class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl">
31.         <property name="timeout">600</property>
32.         <property name="maxPoolSize">10</property>
33.         <property name="allowLocalTx">true</property>
34.         <destroyMethod name="close"/>
35.     </component>
37.     <component name="dataSource" class="org.seasar.extension.dbcp.impl.DataSourceImpl"/>
39. </components>

jpa.dicon文件:

1. <?xml version="1.0" encoding="UTF-8"?>
2. <!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container 2.4//EN" 
3.     "http://www.seasar.org/dtd/components24.dtd">
4. <components>
6.     <include path="s2toplink-jpa.dicon"/>
8.     <component name="persistenceUnitProvider" class="org.seasar.framework.jpa.impl.ContainerPersistenceUnitProvider">
9.         <property name="unitName">"s2toplinkjpaUnit"</property>
10.         <property name="providerClassName">"oracle.toplink.essentials.PersistenceProvider"</property>
11.     </component>
13.     <component name="entityManagerFactory" class="javax.persistence.EntityManagerFactory">
14.         persistenceUnitProvider.entityManagerFactory
15.     </component>
17.     <component name="entityManager" class="org.seasar.framework.jpa.impl.TxScopedEntityManagerProxy">
18.         <aspect pointcut="createNamedQuery">
19.             <component class="org.seasar.toplink.jpa.aop.interceptors.S2TopLinkEntityManagerInterceptor"/>
20.         </aspect>
21.     </component>
22.     
23. </components>

persistence.xml:

1. <?xml version="1.0" encoding="UTF-8"?>
2. <persistence xmlns="http://java.sun.com/xml/ns/persistence"
3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4.     xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
5.     http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
6.     version="1.0">
8.     <persistence-unit name="s2toplinkjpaUnit" transaction-type="RESOURCE_LOCAL">
9.         <provider>oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider</provider>
10.         <jta-data-source>jdbc/dataSource</jta-data-source>
11.         <class>examples.entity.Department</class>
12.         <class>examples.entity.Employee</class>
13.         <properties>
14.             <property name="toplink.target-server" value="org.seasar.toplink.jpa.platform.server.S2ServerPlatform"/>
15.             <property name="toplink.target-database" value="MySQL4"/>
16.             <!-- 
17.                 toplink.target-database:
18.                 Auto（默认）、Attunity、Cloudscape、Database、DB2、DB2Mainframe、DBase、Derby、HSQL、Informix、JavaDB、MySQL4、Oracle、PointBase、PostgreSQL、SQLAnyWhere、SQLServer、Sybase和TimesTen。
19.              -->
20.             <property name="toplink.logging.level" value="WARNING"/>
21.             <property name="toplink.cache.shared.default" value="false"/>
22.             <!--  
23.                 <property name="toplink.ddl-generation" value="create-tables"/>
24.                 <property name="toplink.create-ddl-jdbc-file-name" value="import.sql"/>
25.             -->
26.         </properties>
27.     </persistence-unit>
28. </persistence>

修改DepartmentDaoImpl.java

1. package examples.dao;
3. import javax.ejb.Stateless;
4. import javax.persistence.EntityManager;
5. import javax.persistence.PersistenceContext;
7. import examples.entity.Department;
9. @Stateless
10. public class DepartmentDaoImpl implements DepartmentDao {
12.     @PersistenceContext(unitName = "s2toplinkjpaUnit")
13.     EntityManager em;
15.     public DepartmentDaoImpl() {
16.     }
18.     public Department getDepartment(int id) {
19.         
20.         return em.find(Department.class, id);
21.     }
22. }

其他文件无需修改。

测试代码部分：

DepartmentClient.java无需修改。

EntityManagerFactoryClient.java

1. package examples.work;
3. import java.util.List;
5. import javax.persistence.EntityManager;
6. import javax.persistence.EntityManagerFactory;
8. import oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl;
9. import oracle.toplink.essentials.threetier.ServerSession;
11. import org.seasar.framework.container.S2Container;
12. import org.seasar.framework.container.factory.S2ContainerFactory;
13. import org.seasar.framework.jpa.PersistenceUnitManager;
15. import examples.entity.Department;
17. public class EntityManagerFactoryClient {
19.     private static final String PATH = "app.dicon";
21.     public static void main(String[] args) {
23.         S2Container container = S2ContainerFactory.create(PATH);
24.         container.init();
25.         try {
26.             EntityManagerFactory emf = (EntityManagerFactory) container.getComponent(EntityManagerFactory.class);
27.             EntityManager em = emf.createEntityManager();
28.             Department department = (Department) em.find(Department.class, 10);
29.             System.out.println(department.getDeptno());
30.             
31.             PersistenceUnitManager pum = PersistenceUnitManager.class.cast(container.getComponent(PersistenceUnitManager.class));
32.             emf = pum.getEntityManagerFactory("s2toplinkjpaUnit");
33.             em = emf.createEntityManager();
34.             
35.             EntityManagerImpl entityManagerImpl = EntityManagerImpl.class.cast(em.getDelegate());
36.             ServerSession session = entityManagerImpl.getServerSession();
37.             List<?> list = session.readAllObjects(Department.class);
38.             for (int i = 0; i < list.size(); i++) {
39.                 System.out.println(((Department)list.get(i)).getDname());
40.             }
41.             
42.             department = (Department) em.find(Department.class, 10);
43.             System.out.println(department.getDeptno());
44.         } finally {
45.             container.destroy();
46.         }
47.     }
48. }

EntityManagerClient.java

1. package examples.work;
3. import java.util.List;
4. import java.util.Vector;
6. import javax.ejb.TransactionAttribute;
7. import javax.ejb.TransactionAttributeType;
8. import javax.persistence.EntityManager;
9. import javax.persistence.EntityManagerFactory;
10. import javax.persistence.EntityTransaction;
12. import oracle.toplink.essentials.expressions.Expression;
13. import oracle.toplink.essentials.expressions.ExpressionBuilder;
14. import oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl;
15. import oracle.toplink.essentials.queryframework.ReportQuery;
16. import oracle.toplink.essentials.queryframework.ReportQueryResult;
17. import oracle.toplink.essentials.sessions.DatabaseSession;
19. import org.seasar.framework.container.S2Container;
20. import org.seasar.framework.container.factory.S2ContainerFactory;
22. import examples.entity.Department;
23. import examples.entity.Employee;
25. public class EntityManagerClient {
27.     private static final String PATH = "app.dicon"; 
28.     
29.     
30.     public static void main(String[] args) {
31.         
32.         S2Container container = S2ContainerFactory.create(PATH);
33.         container.init();
34.         try {
35.             EntityManagerFactory emf = (EntityManagerFactory) container.getComponent(EntityManagerFactory.class);
36.             EntityManager em = emf.createEntityManager();
37.             
38.             Department department = (Department)em.find(Department.class, 10);
39.             updateDepartment(em, department);
40.             
41.             EntityManagerImpl entityManagerImpl = EntityManagerImpl.class.cast(em.getDelegate());
42.             DatabaseSession session = entityManagerImpl.getServerSession();
43.             Expression expression = new ExpressionBuilder().get("deptno").equal(20);
44.             department = (Department)session.readObject(Department.class, expression);
45.             System.out.println(department.getDname());
46.                 
47.             List<?> list = session.readAllObjects(Department.class);
48.             System.out.println(list.size());
49.             
50.             ExpressionBuilder empBuilder = new ExpressionBuilder(); 
51.             ReportQuery subQuery = new ReportQuery(Employee.class, empBuilder);
52.             subQuery.addMaximum("sal");
53.             subQuery.setSelectionCriteria(empBuilder.get("department").get("loc").equalsIgnoreCase("CHICAGO"));
54.             Vector<ReportQueryResult> results = new Vector<ReportQueryResult>();
55.             results = (Vector)session.executeQuery(subQuery);
56.             for (int i = 0; i < results.size(); i++) {
57.                 System.out.println(results.get(i).getResults());
58.             }
59.             
60.             ExpressionBuilder builder = new ExpressionBuilder();    
61.             expression = builder.get("ename").likeIgnoreCase("%la%");
62.             expression.and(builder.get("sal").between(2000, 3000));
63.             Vector<Employee> emps = new Vector<Employee>();   
64.             emps = session.readAllObjects(Employee.class, expression);
65.             for (int i = 0; i < emps.size(); i++) {
66.                 System.out.println(emps.get(i).getEname() + "/t" +emps.get(i).getSal());
67.             }
68.         } finally {
69.             container.destroy();
70.         }
71.     }
72.     
73.     @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
74.     public static void updateDepartment(EntityManager em, Department department){
75.         
76.         System.out.println(department.getDname());
77.         department.setDname(department.getDname() + "XXX");
78.         EntityTransaction tx = em.getTransaction();
79.         tx.begin();
80.         em.persist(department);
81.         em.flush();
82.         tx.commit();
83.     }
84. }

关于toplink:

http://www.javaresearch.org/article/11552.htm

http://www.oracle.com/technology/global/cn/sample_code/tech/java/codesnippet/toplink/index.html