这几天在研究JFinal,对ActiveRecord有点兴趣，但其运行必须先将Table对应的Model注册才行， 通过JFinal提供的Model生成工具对数据库批量生成Model, 生成器的调用：
package autogen;import javax.sql.DataSource;import com.freestyle.app.config.db.OMSDatasource;
import com.freestyle.common.db.mybatis.MybatisUtils;
import com.jfinal.kit.PathKit;
import com.jfinal.plugin.activerecord.dialect.PostgreSqlDialect;
import com.jfinal.plugin.activerecord.generator.Generator;public class JFinalModelGenerator {private static DataSource getDataSource() {return OMSDatasource.getDatasource();}public static void main(String[] args) {MybatisUtils.closeSession(MybatisUtils.getSession());String baseModelPackageName="com.freestyle.app.study1.model.base";String baseModelOutDir=PathKit.getWebRootPath()+"/src/main/java/com/freestyle/app/study1/model/base";String modelPackageName="com.freestyle.app.study1.model";String modelOutputDir=baseModelOutDir+"/..";Generator generator=new Generator(getDataSource(),baseModelPackageName,baseModelOutDir,modelPackageName,modelOutputDir);//generator.setGenerateChainSetter(false);generator.addExcludedTable("");generator.setGenerateDaoInModel(true);generator.setGenerateChainSetter(true);generator.setGenerateDataDictionary(false);generator.setDialect(new PostgreSqlDialect());generator.addExcludedTable("hibernate_sequences");generator.generate();}public JFinalModelGenerator() {// TODO Auto-generated constructor stub}}
跑了完，Model&baseModel都出来了。
为了能脱离web环境测试ActiveRecord,我写了一个JFinal DB的测试基类:
package test.package1;import org.junit.After;
import org.junit.Before;import com.freestyle.app.config.db.OMSDatasource;
import com.freestyle.app.study1.model._MappingKit;
import com.freestyle.common.db.mybatis.MybatisUtils;
import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
import com.jfinal.plugin.activerecord.dialect.PostgreSqlDialect;public class JFinalBaseTestUnit {protected static ActiveRecordPlugin activeRecord;@Beforepublic void setUp() throws Exception {MybatisUtils.closeSession(MybatisUtils.getSession());activeRecord=new ActiveRecordPlugin(OMSDatasource.getDatasource());activeRecord.setDialect(new PostgreSqlDialect());activeRecord.setDevMode(true);activeRecord.setShowSql(true);_MappingKit.mapping(activeRecord);activeRecord.start();}@Afterpublic void tearDown() throws Exception {activeRecord.stop(); }}
现在测试下TaUser表的调用，新建一个测试单元base on JFinalBaseTestUnit:
package test.package1;import org.junit.Test;import com.freestyle.app.study1.model.TaUser;public class TestJFinalDemo extends JFinalBaseTestUnit {public TestJFinalDemo() {// TODO Auto-generated constructor stub}@Testpublic void testTaUser() {TaUser dao=TaUser.dao;for (TaUser item:dao.find("select * from ta_user where fa_login like ?", "sale%")) {System.out.println(item.toString());}}}pageNumber : 1
pageSize : 10
totalPage : 3
totalRow : 23