@Transactional
public void saveData(Object obj) {
}
@Cacheable
public Object getData() {
}
public void updateData(List<Object> dataList) {
}
public List<Object> getDataByPage(int page, int pageSize) {
}
public List<Object> getDataByCondition(String name, int age) {
Query query = new Query();
query.addCondition("name", "=", name)
.addCondition("age", ">", age);
return query.getResultList();
}
public Map<String, Integer> getCountByGroup() {
Query query = new Query();
query.addGroupBy("type")
.setProjection("type", "count(id)");
List<Object[]> resultList = query.getResultList();
Map<String, Integer> result = new HashMap<>();
for (Object[] row : resultList) {
result.put((String) row[0], (Integer) row[1]);
}
return result;
}
spring.datasource.url=jdbc:mysql://localhost:3306/mydb
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
<dependency>
<groupId>com.ujo</groupId>
<artifactId>ujo-orm</artifactId>
<version>1.0.0</version>
</dependency>
----------
