SimpleQuery
介绍
基于JAVA的轻量级ORM框架(A lightweight ORM framework for JAVA)。
- 无复杂配置项
- 支持多数据源
- 支持联表查询
- 基于对象实现增删改操作
项目地址:https://github.com/mmy-project/SimpleQuery 扣扣交流群:838121506
-
CREATE TABLE `tb_employee` ( `ep_id` int(10) AUTO_INCREMENT, `ep_name` varchar(20), `ep_createOn` datetime, PRIMARY KEY (`ep_id`) );
<dependency> <groupId>com.mumayuan</groupId> <artifactId>mmy-simple-query</artifactId> <version>1.0.1</version> </dependency>
@Setter @Getter @Table("tb_employee") public class Employee extends BaseEntity { @PrimaryKey("ep_id") private long id; @Column("ep_name") private String name; @Column("ep_createOn") private Date createOn; @ResultColumn("name_id") private String nameId; }
// 创建数据源,如:c3p0、druid等 DataSource dataSource = getDataSource(); // 给数据源起个名字,方便多数据源切换 GlobalConfig.addDataSource("mysql", dataSource);
SimpleQueryFactory factory = new DefaultSimpleQueryFactory("mysql"); SimpleQuery simpleQuery = factory.createSimpleQuery();
Employee employee = new Employee(); // 主键自动忽略 employee.setId(2L); employee.setName("Tom"); employee.setCreateOn(new Date()); // 查询字段自动忽略 employee.setNameId("Tom" + 2L); int insertCount = simpleQuery.insert(employee);
// 使用Sql对象需要初始化Comment对象 Sql sql = new Sql(); sql.initComment("simpleQuery", "Demo", "main", "查询测试"); sql.appendSql("SELECT *,CONCAT(ep_name,ep_id) `name_id` FROM tb_employee"); List<Employee> employees = simpleQuery.select(Employee.class, sql);
Employee employee2 = employees1.get(0); employee2.setName("Jack"); employee2.setCreateOn(new Date()); int updateCount = simpleQuery.update(employee2);
int deleteCount = simpleQuery.delete(employee2);
-
** 栗子暂且举到这里,欢迎大家入群多多交流。 **