Jfinal's ActiveRecord Development example

Jfinal Original DB + Record mode example
Jfinal is equipped with the ActiveRecord plug-in, in addition to the implementation of similar rails Activerecrod functions, but also implemented a
DB + record mode, in which the developer can easily manipulate the database without even having to write the model.
The following is the sample code: // 创建name属性为James,age属性为25的User对象并添加到数据库 new User().set( "name" , "James" ).set( "age" , 25 ).save(); // 删除id值为25的User User.me.deleteById( 25 ); // 查询id值为25的User将其name属性改为James并更新到数据库 User.me.findById( 25 ).set( "name" , "James" ).update(); // 查询id值为25的user, 且仅仅取name与age两个字段的值 User user = User.me.findById( 25 , "name, age" ); // 获取user的name属性 String userName = user.getStr( "name" ); // 获取user的age属性 Integer userAge = user.getInt( "age" ); // 查询所有年龄大于18岁的user List<User> users = User.me.find( "select * from user where age > 18" ); // 分页查询sex为1并且年龄大于18的user,当前页号为1,每页10个user Page<User> userPage = User.me.paginate( 1 , 10 , "select *" , "from user where sex=? and age>?" , 1 , 18 );

Jfinal's ActiveRecord Development example