com.github.maskwerewolf:flower-mysql

flower jdbc framework

License	The Apache License, Version 2.0
Categories	MySQL Data Databases
GroupId	com.github.maskwerewolf
ArtifactId	flower-mysql
Last Version	2.0
Release Date	May 24, 2019
Type	jar
Description	flower jdbc framework

Download flower-mysql

Filename	Size
flower-mysql-2.0.pom
flower-mysql-2.0.jar	22 KB
flower-mysql-2.0-sources.jar	12 KB
flower-mysql-2.0-javadoc.jar	131 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.github.maskwerewolf/flower-mysql/ -->
<dependency>
    <groupId>com.github.maskwerewolf</groupId>
    <artifactId>flower-mysql</artifactId>
    <version>2.0</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.github.maskwerewolf/flower-mysql/
implementation 'com.github.maskwerewolf:flower-mysql:2.0'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.github.maskwerewolf/flower-mysql/
implementation ("com.github.maskwerewolf:flower-mysql:2.0")

Apache Buildr

'com.github.maskwerewolf:flower-mysql:jar:2.0'

Apache Ivy

<dependency org="com.github.maskwerewolf" name="flower-mysql" rev="2.0">
  <artifact name="flower-mysql" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.github.maskwerewolf', module='flower-mysql', version='2.0')
)

Scala SBT

libraryDependencies += "com.github.maskwerewolf" % "flower-mysql" % "2.0"

Leiningen

[com.github.maskwerewolf/flower-mysql "2.0"]

Dependencies

compile (4)

Group / Artifact	Type	Version
org.springframework : spring-jdbc Optional	jar	5.1.6.RELEASE
ch.qos.logback : logback-classic Optional	jar	1.2.3
org.slf4j : jcl-over-slf4j Optional	jar	1.7.25
org.slf4j : slf4j-api Optional	jar	1.7.25

Project Modules

There are no modules declared in this project.

flower-jdbc2.0

maven

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

insert

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

update

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

select

 <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) 

count

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

delete

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

example

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 = ?

Versions

Version
2.0 May 24, 2019
1.0 May 23, 2017