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