JFinal Tables自动生成对应Model及Model代码& JUnit 测试单元的编写

      这几天在研究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;
	@Before
	public 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();
	}

	@After
	public 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
	}
	@Test
	public 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