##druid plugin auto load，default 為數(shù)據(jù)源名字
##druid plugin auto load
db.default.url=jdbc:mysql://127.0.0.1/example?useUnicode=true&characterEncoding=UTF-8
db.default.user=dev
db.default.password=dev1010
db.default.dialect=mysql
#c3p0配置
c3p0.default.minPoolSize=3
c3p0.default.maxPoolSize=20
#druid配置
#druid.default.initialSize=10
#druid.default.maxPoolPreparedStatementPerConnectionSize=20
#druid.default.timeBetweenConnectErrorMillis=1000
#druid.default.filters=slf4j,stat,wall
#flyway database migration auto load
flyway.default.valid.clean=true
flyway.default.migration.auto=true
flyway.default.migration.initOnMigrate=true

public void configPlugin(PluginLoader pluginLoader) {
    C3p0DataSourceProvider cdsp = new C3p0DataSourceProvider("default");
    ActiveRecordPlugin activeRecordCdsp = new ActiveRecordPlugin(cdsp, true);
    //映射的model必須能被掃描到 
    activeRecordCdsp.addIncludePaths("cn.dreampie.orm");
    pluginLoader.add(activeRecordCdsp);
}

  //假設cn.dreampie.orm目錄下有個model叫User
  //使用table注解來映射指定的數(shù)據(jù)表，generatedKey是自增主鍵(自增方式分為數(shù)據(jù)庫自增和自定義生成器自增，如uuid)，primaryKey非自增主鍵，generated=true 表示使用自定義的生成器生成主鍵，cached 表示緩存
  @Table(name = "sec_user",generatedKey="id", primaryKey = "sid",generated=true, cached = true)
  public class User extends Model<User> {
    public static User dao = new User();
  }

@API("/users")
public class UserResource extends ApiResource {
  /**
   * 查詢一個user的集合
   */
  @GET
  public List<User> findAll() {
    //使用Record 達到相同的效果，而不需要編寫User.java
    //Record userDAO＝new Record("sec_user","id,sid",true,true);
    //userDAO.findAll();
    return User.dao.findAll();
  }
}