jfinal配置rails的数据表

鉴于rails的部署太可怕，所以有了使用rails的建表工具和migration，用jfinal来开发的想法，在此贴一下需要注意的地方

 

maven配置

<dependency>
      <groupId>com.jfinal</groupId>
      <artifactId>jfinal</artifactId>
      <version>2.2</version>
    </dependency>

    <!-- http://mvnrepository.com/artifact/com.mchange/c3p0 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>

    <!-- http://mvnrepository.com/artifact/org.postgresql/postgresql -->
    <dependency>
      <groupId>org.postgresql</groupId>
      <artifactId>postgresql</artifactId>
      <version>9.4.1208</version>
    </dependency>

 

resources下面的db.config

jdbcUrl = jdbc:postgresql://localhost:5432/my_rails_development
user = mmc
password = mmc

 

jfinal的model生成器

public static DataSource getDataSource() {
        Prop p = PropKit.use("db.config");
        C3p0Plugin c3p0Plugin = new C3p0Plugin(p.get("jdbcUrl"), p.get("user"), p.get("password"));
    //设置pgsql的DriverClass
        c3p0Plugin.setDriverClass("org.postgresql.Driver");
        c3p0Plugin.start();
        return c3p0Plugin.getDataSource();
    }

//设置pgsql的Dialect
gernerator.setDialect(new PostgreSqlDialect());  
gernerator.addExcludedTable("schema_migrations");

 

项目代码里面config

public void configPlugin(Plugins me) {

        Prop p = PropKit.use("db.config");
        C3p0Plugin cp = new C3p0Plugin(p.get("jdbcUrl"), p.get("user"), p.get("password"),"org.postgresql.Driver");
        cp.start();

        me.add(cp);

        ActiveRecordPlugin arp = new ActiveRecordPlugin(cp);
        arp.setDialect(new PostgreSqlDialect());
        _MappingKit.mapping(arp);
        me.add(arp);
    }

 

HelloController.java

public class HelloController extends Controller {

    public void index()
    {
        List<Users> users = Users.dao.find("select * from users;");
        String name = users.get(0).getName();
        renderText(name);
    }
}