2024-02-01 11:15
@绿色的小苹果 你说的这个需求,以前我有分享过:https://jfinal.com/share/2404
我们是日志入库了,定期清理
2023-09-21 13:38
DruidPlugin dp = new DruidPlugin("jdbc:sqlite:db/acc.db", null, null);
dp.set(1, 1, 1);//并发必须1
dp.setDriverClass("org.sqlite.JDBC");
ActiveRecordPlugin arp = new ActiveRecordPlugin(dp);
arp.setDialect(new Sqlite3Dialect());
dp.start();
arp.start();
//------------初始化表结构------------------
Db.update( """
CREATE TABLE IF NOT EXISTS ta (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
aid INT NOT NULL,
bid INT NOT NULL,
cid INT NOT NULL
)
""");
Db.save("ta", new Record().set("aid",2).set("bid",1).set("cid",1));
List<Record> list = Db.findAll("ta");
System.out.println(list);
//--------------重新映射Model关系---------------------
arp.stop();
arp.addMapping("ta","aid", Ta.class);
arp.start();
new Ta().set("aid",2).set("bid",1).set("cid",1).save();
List<Ta> all = Ta.dao.findAll();
System.out.println(all);
dp.stop();
2023-09-21 13:25
@xinyin025 我gitee拉取下来,sqlite-jdbc改为3.7.2 运行正常