FastQuery: a framework for fast data operations

FastQuery fast operation data layer framework

FastQuery is based on Java language. Its mission is to simplify the Java operation data layer. As a developer, you only need to design and write the DAO interface, which is dynamically generated and implemented by ASM internally, and executes quickly. Therefore, the code is concise and elegant, thus greatly improving development efficiency.

The main features of FastQuery are as follows:

1. Elegant design, simple configuration, easy to use.
2. ASM is used to dynamically generate bytecodes, so preprocessing before compilation is supported, which can minimize errors during runtime and significantly improve the robustness of the program.
3. Supports secure query to prevent SQL injection.
4. Support integration with mainstream connection pool frameworks, such as c3p0, dbcp, etc.
5. Support @Query query, use @Condition to implement dynamic where condition query.
6. The query result set supports JSON type
7. Support AOP, injection interception only requires a few simple annotations, such as: @Before, @After

Operating environment requirements

JDK 1.8+

Configuration Files

jdbc-config.xml

Used to configure support for jdbc. Note: If a connection pool is used, this configuration file can be omitted.

 <? xml   version = "1.0"   encoding = "UTF-8" ?>  
 < jdbc-config >     
         <!-- Configure *** data sources -->  
         < named-config   name = "xk_db" >     
         < property   name = "driverClass" > com.mysql.jdbc.Driver </ property >     
         < property   name = "url" > jdbc:mysql://192.168.1.1:3306/xk? user = xk & password = abc123 </ property >  
         </ named-config >  
 
         <!-- Configure the second data source -->  
         < named-config   name = "shtest_db" >     
         < property   name = "driverClass" > com.mysql.jdbc.Driver </ property >    <!-- jdbc driver -->  
         < property   name = "databaseName" > dbname </ property >    <!-- Name of the database -->  
         < property   name = "user" > username </ property >    <!-- Database User Name -->  
         < property   name = "password" > userpasswd </ property >    <!-- Password of the database user -->    
         < property   name = "portNumber" > 3306 </ property >     <!-- Port -->  
         < property   name = "serverName" > 192.168.1.1 </ property >   <!-- Database host address -->  
     </ named-config >  
 </ jdbc-config >  

c3p0-config.xml

Support c3p0 configuration, please refer to the c3p0 official website for detailed configuration: http://www.mchange.com/projects/c3p0/ .

 <? xml   version = "1.0"   encoding = "UTF-8" ?>  
 < c3p0-config >     
 <!-- 
     < default-config >     
         < property   name = "driverClass" > com.mysql.jdbc.Driver </ property >     
         < property   name = "jdbcUrl" > jdbc:mysql://... </ property >  
         < property   name = "user" > root </ property >     
         < property   name = "password" > 123*** </ property >     
         < property   name = "initialPoolSize" > 10 </ property >     
         < property   name = "maxIdleTime" > 30 </ property >     
         < property   name = "maxPoolSize" > 20 </ property >     
         < property   name = "minPoolSize" > 5 </ property >     
         < property   name = "maxStatements" > 200 </ property >     
     </ default-config >    
 -- >      
     < named-config   name = "xk-c3p0" >     
         < property   name = "driverClass" > com.mysql.jdbc.Driver </ property >     
         < property   name = "jdbcUrl" > jdbc:mysql://192.168.1.1:3306/xk </ property >     
         < property   name = "user" > xk </ property >     
         < property   name = "password" > abc123 </ property >     
         < property   name = "acquireIncrement" > 50 </ property >     
         < property   name = "initialPoolSize" > 100 </ property >     
         < property   name = "minPoolSize" > 50 </ property >     
         < property   name = "maxPoolSize" > 1000 </ property >  
         < property   name = "maxStatements" > 0 </ property >     
         < property   name = "maxStatementsPerConnection" > 5 </ property >        
         </ named-config >    
 </c3p0-config>​​  

fastquery.json

Configure the scope of the data source

 // @author xixifeng ([email protected])
 // Configuration must follow standard json syntax.
 [
 // The optional values ​​currently supported by config are "jdbc", "c3p0"
 {
 "config": "c3p0", // indicates that c3p0 is responsible for providing the data source
 "dataSourceName": "xk-c3p0", // data source name
 "basePackages": [ // The scope of this data source
            "org.fastquery.example.StudentDBService"
 ]
 }, 
 
 /*
 Configure another data source scope
 */
 {
 "config" : "jdbc", // indicates that the jdbc driver is responsible for providing the data source
        "dataSourceName": "shtest_db",
 "basePackages": [ // The scope of this data source
            "org.fastquery.example.DataAcquireDbService"
 ]
 }
 ]

A complete introductory example

• Prepare an entity

 public class Student
 {
 private String no;
 private String name;
 private String sex;
 private Integer age;
 private String dept;
 // getter /setter omitted...
 }

• DAO Interface

 public interface StudentDBService extends QueryRepository {
 @Query("select * from student")
 JSONArray findAll();
 @Query("select * from student")
 Student[] find();
 }

• Use DAO interface.

 StudentDBService studentDBService = FQuery .getRepository(StudentDBService.class);
 JSONArray jsonArray = studentDBService .findAll();
 Student[] students = studentDBService .find();