<dependency>
    <groupId>com.github.maskwerewolf</groupId>
    <artifactId>flower-mysql</artifactId>
    <version>2.0</version>
</dependency>

 Number insert(Object object) 
 
 int insertBatch(List<?> objectList)

     int update(Query query, Update update, Class<?> entityClass) 
     
     int update(Query query, Update update, String tableName) 

 <T> List<T> find(Query query, Class<T> entityClass) 
 <T> List<T> find(Select select, Query query, Class<T> entityClass)
 List<Map<String, Object>> findForMaps(Query query, Class<?> entityClass) 
 List<Map<String, Object>> findForMaps(Select select, Query query, Class<?> entityClass)
 <T> T findOne(Query query, Class<T> entityClass)
 Map<String, Object> findForMap(Query query, Class<?> entityClass) 
 Map<String, Object> findForMap(Query query, String tableName) 
 <T> T findOne(Select select, Query query, Class<T> entityClass) 

     long count(Query query, String tableName) 
     long count(Query query, Class<?> entityClass) 

 int delete(Query query, Class<?> entityClass)
  
 int delete(Query query, String tableName) 

User user = Jdbc.findOne(Query.query("id=? ",arg1), User.class);

 Query query = new Query();
 if(null != name){
  query.and("name=?",name);
 }
 or like this
query.andIfAbsent("name=?",name);


 query.page(page).limit(limit);
 query.order("..........")
  

 List<User> user = Jdbc.find(query,User.class);
 
 
Jdbc.update(Query.query("id=?",""),Update.setIfAbsent("nickname","value").inc("age",1),User.class)

>sql: update user set nickname=? ,age = age+1 where id = ?