JFinal-DbHelper 是简化的JFinal数据库操作,透明操作Redis,让你全心安心做你的业务,数据缓存,统统把你解决掉。
核心组件DbHelperKit:封装了JFinalDbKit,直接使用Map来装数据库的每一行数据;
DbHelperTx:简化了Tx操作;
DataRecordModel:数据库表的工具Model,继承这个Model,加上和数据库字段一样的属性;
DBService:提供了常见的CRUD,可以简单的CRUD同时把数据也“偷偷”的写到了Redis哦;
怎样使用假设你的表是这样的:CREATETABLE`user`( `id`bigint(20)unsignedNOTNULLAUTO_INCREMENT, `name`varchar(255)DEFAULTNULL, PRIMARYKEY(`id`), KEY`id`(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4
创建一个Model:User,她是这样的:
@Table(name = User.TABLE)public class User extends DataRecordModel<User> {private static final long serialVersionUID = 7098160284590588258L;public static final String TABLE = "user";public static final String TABLE_AS = "u";// SQL Fieldspublic static final String ID = "id";public static final String NAME = "name";//SQL Field Aspublic static final String ID_AS = "id";public static final String NAME_AS = "name";@Table.PrimaryKey@Table.Column(name = User.ID, as = User.ID_AS, originType = Table.ColumnOriginType.BIGINT)public String id;@Table.Column(name = User.NAME, as = User.NAME_AS, originType = Table.ColumnOriginType.STRING)public String name;}接下来你再创建一个Service,她是这样的:
public class UserService extends DBService { private static final long serialVersionUID = -6341896364271284419L; //这里放自定义的其他方法}4.在加上一个RedisCacheService,她是这样的:
public class UserRedisService extends RedisCacheService { private static final long serialVersionUID = 8673372135373269417L; //这里放自定义的其他方法}5.完成了上面的工作,你就可以开始使用了哦:
//设置产品 name ProductKit.PRODUCT_NAME = "zcq"; User user = new User(); user.name = "BruceZCQ"; //save UserService userService = new UserService(); boolean ret = userService.save(user); System.out.println("save =="+ret); //find id = 6 user.id = "6"; Map<String, Object> find = userService.findOne(user); System.out.println("find =="+find); //find to User User otherUser = user.parser(find); System.out.println("other user == "+otherUser); //findall Object all = userService.findAll(user); System.out.println("findall =="+all); //update BruceZCQ to newName user.name = "newName"; ret = userService.update(user); System.out.println("update =="+ret); //delete id = 10 user.id = "10"; ret = userService.delete(user); System.out.println("delete=="+ret);
评论