QyOrm Gitee传送门
支持功能:
- AutoGenerate根据数据库表自动生成类的定义代码
- 外键
- 实例化
- 联合查询、特殊查询
- Json的读取和保存
- QT GUI常见input widget 的双向绑定 以下是使用的例子
手动 类的定义:
//model.h
class User : public QyOrm::Table
{
Q_OBJECT
public:
TABLE(User)
PRIMARYKEY(QyOrm::StringField,uid)
UNIQUE(QyOrm::StringField,pwd)
NOTNULL(QyOrm::StringField,name)
};
//使用.cpp
for(User* user : QyOrmSelect(User())){// 全部查询 <=> select * from User
//for(User* user : QyOrmSelect(User().setField("uid", QString("001")))){// 条件查询 <=> select * from User where uid='001'
qDebug() << user->uid.get() << user->pwd.get() << user->name.get(); //打印值
user->name.set("赵一"); // 修改一条记录 <=> update User set name='赵一' where uid='001'
user->remove(); // 删除一条记录 <=> delete from User where uid='001'
}
User user;
user.uid = "005";
user.pwd = "005";
user.name = "孙五";
user.insert(); // 插入一条记录 <=> insert into User values('005', '005', '孙五')
user.remove(); // 删除一条记录 <=> delete from User where uid='005' and pwd='005' and name='孙五'
User().setField("uid", QString("005")).remove(); // 删除一条记录 <=> delete from User where uid='005'
测试结果:
GIF运行演示