一个基于Spring的Java快速开发框架,支持mysql、xml、json等的基本操作。
- Spring 5.1.5.RELEASE
- Mysql 5.1.26
- Dom4j 1.6.1
- Jackson 2.9.9
- Lombok 1.18.10
- Jdk 1.8
方法 | 说明 |
---|---|
boolean has(Serializable id) | 根据主键检查记录是否存在 |
E findById(Serializable id) | 根据主键查找对象 |
List findByIds(Collection<? extends Serializable> ids) | 根据主键批量查找对象 |
List find() | 查询所有的记录 |
List findByColumn(String column, Serializable value) | 根据指定字段查询记录 |
List findByColumn(String column, Collection<? extends Serializable> values) | 根据指定字段查询记录 |
List find(Conditions conditions) | 根据条件查询,条件的具体用法请看下面的案例 |
Paginator findByPage(Conditions conditions, Integer pageSize, Integer pageNumber) | 分页查询 |
Integer delete(Serializable id) | 根据主键删除 |
Integer delete(List<? extends Serializable> ids) | 根据主键删除 |
Integer delete(String column, Collection<? extends Serializable> values) | 根据字段删除 |
Integer insert(E entity) | 保存对象 |
Integer insert(List entitys) | 批量保存对象 |
Integer update(E entity) | 修改对象(根据主键修改) |
Integer update(String id, String key, Object value) | 修改 |
Integer update(List<? extends Serializable> ids, Map<String, Object> data) | 批量修改 |
Integer update(String id, Map<String, Object> data) | 修改 |
Integer update(List<? extends Serializable> ids, String key, Object value) | 修改 |
<dependency>
<groupId>io.github.yuanweiquan-007</groupId>
<artifactId>quick.start</artifactId>
<version>1.8</version>
</dependency>
@Bean
public JdbcTemplate jdbcTemplate() {
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource());
return jdbcTemplate;
}
也可以通过xml配置文件的方式注入
@Data
@Table("Orders")//定义表名
@MapUnderScoreToCamelCase//单表开启驼峰
public class Order implements Entity {
@Generated//设置自增属性
private Integer orderId;
@PrimaryKey//定义主键
private String orderCode;
@Column("remarks")//设置字段名
private String remark;
}
@Repository
public class OrderRepository extends JdbcRepository<Order> {
//nothing to do
}
//新增
Order order = new Order();
order.setOrderCode(String.valueOf(System.currentTimeMillis()));
order.setRemark(LocalDateTime.now().toString());
orderRepository.insert(order);
//修改
order.setRemard("remark");
orderRepository.update(order);
//查询
orderRepository.findById("1593238076676"));
//删除
orderRepository.delete("1593238076676");
如果需要执行复杂的sql,可以在Repository中通过内置的jdbcTemplate对象来执行对应的sql。
this.jdbcTemplate.query(sql, args);
如果要指定数据源,可以重写方法
/**
* 如果要指定JdbcTemplate,可以通过此方法修改
*
* @param jdbcTemplate
*/
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
Conditions conditions = new Conditions()
.equal("orderCode", "1593238616437")//等于
.lessThenOrEqual("orderId", 13)//小于
.greaterThen("orderId", 10)//大于
.desc("orderId")//降序
.asc("orderCode")//升序
.limit(10);//limit-分页
orderRepository.find(conditions).forEach(x -> {
logger.info("{}", x.toString());
});
String json = "{\n" +
" \"name\":\"quick.start\",\n" +
" \"version\":\"1.0\",\n" +
" \"details\":[\n" +
" {\n" +
" \"key\":\"key1\",\n" +
" \"value\":\"value1\"\n" +
" },\n" +
" {\n" +
" \"key\":\"ke2\",\n" +
" \"value\":\"value2\"\n" +
" }\n" +
" ]\n" +
"}";
Resolver resolver = Resolver.ofJson(json);
//解析字符串
String name = resolver.get("name");
System.out.println(name);
//解析数组
List<Map<String, Object>> list = resolver.getList("/details");
list.forEach(x -> {
System.out.println(x);
});
String xml = "<response>\n" +
" <code>200</code>\n" +
" <flag>success</flag>\n" +
" <message>成功</message>\n" +
" <orders>\n" +
" <order>\n" +
" <orderCode>12345678</orderCode>\n" +
" <createTime>2020-07-22 17:47:46</createTime>\n" +
" </order>\n" +
" <order>\n" +
" <orderCode>87654321</orderCode>\n" +
" <createTime>2020-07-22 17:48:13</createTime>\n" +
" </order>\n" +
" </orders>\n" +
"</response>";
Resolver resolver = Resolver.ofXml(xml);
//解析字符串
String code = resolver.get("/response/code");
System.out.println(code);
//解析数组
List<Map<String, Object>> list = resolver.getList("/response/orders/order");
list.forEach(x -> {
System.out.println(x);
});
@Test
public void test() throws Exception {
String xml = "<response>\n" +
" <code>200</code>\n" +
" <flag>success</flag>\n" +
" <message>订单成功!</message>\n" +
" <orders>\n" +
" <order>\n" +
" <orderCode></orderCode>\n" +
" <createTime>2020-07-22 17:47:41</createTime>\n" +
" </order>\n" +
" <order>\n" +
" <orderCode>87654321</orderCode>\n" +
" <createTime>111</createTime>\n" +
" </order>\n" +
" </orders>\n" +
"</response>";
Validator validator = Validator.ofXml(xml)
.set("version", "1.0").required().integer()
.set("payTime", "2016-11-11 10:12:12").date()
.set("remark", "").string().notEmpty()
.set("money", "545T").doubles()
.set("email", "777@qq").email()
.set("id", "1").empty()
.set("host", "1111").ip()
.set("mobile", "18141448961").mobile()
.set("phone", "0792-1548562").phone()
.set("/response/code").number().notEmpty()
.set("/response/message").string().notEmpty()
.set("/response/flag").string().notEmpty()
.set("/response/orders/order").list().forEach(childVal -> {
childVal.set("orderCode").string().notEmpty()
.set("createTime").date().required()
.end();
})
.end();
if (!validator.isValidate()) {
for (String errorMessage : validator.getErrorMessage()) {
System.out.println(errorMessage);
}
} else {
System.out.println("验证成功");
}
}
version必须为Int类型
remark不能为空
response.orders.order.createTime必须为时间类型(yyyy-MM-dd HH:mm:ss)
email邮箱格式错误
money必须为Double类型
response.orders.order.orderCode不能为空
id必须为空
host非正确的IP格式