基于String JPA加上前端查询语句灵活自定义结果。
源码地址：https://github.com/mytun/sqlDemo

根据url数据自动查询数据库数据

可以根据URL传递搜索条件自动查询数据库数据

1
2
3
4
5
6
7
@Test
void getTestSql() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("query","name$=$测试人员")
            .param("sort","name$asc")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}

普通查询

1
2
3
4
5
6
@Test
void getTestSimple() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("query","name$=$测试人员")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}

多表查询

1
2
3
4
5
6
@Test
void getTestMoreTable() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("query","role.id$=$'111'")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}

多条件 and

1
2
3
4
5
6
@Test
void getTestManyConditionsAnd() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("query","name$=$测试人员,role.id$=$'111',+")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}

多条件 or

1
2
3
4
5
6
@Test
void getTestManyConditionsOr() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("query","name$=$测试人员,role.id$=$'111',-")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}

多条件 and 和 or

多条件查询按照后缀表达式生成查询语句

例如： (id=’123222’ and (name=’xasd’ or phone=’123456’ )) or (name=’123’ and phone=’2222’)
语句则：id$=$’123222’,name$=$’xasd’,phone$=$’123456’,-,+,name$=$’123’,phone$=$’2222’,+,-

1
2
3
4
5
6
@Test
void getTestManyConditionsAndOr() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("query","name$=$测试人员,role.id$=$'111',-,name$=$测试人员,role.id$=$'111',-,+")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}

排序

1
2
3
4
5
6
@Test
void getTestSort() throws Exception {
    MvcResult mvcResult =  mockMvc.perform(MockMvcRequestBuilders.get("/user/search")
            .param("sort","name$asc,role.name$desc")).andReturn();
    System.out.println(mvcResult.getResponse().getContentAsString(StandardCharsets.UTF_8));
}