# framework

**Repository Path**: martin-promaster/framework

## Basic Information

- **Project Name**: framework
- **Description**: No description available
- **Primary Language**: Java
- **License**: GPL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-03-05
- **Last Updated**: 2023-05-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# light component implementing database connection pool

## local installation

```shell
call %MAVEN_HOME%/bin/mvn install:install-file -Dfile=SRC/ybits-common/target/ybits-common-0.0.5.jar -DgroupId=cn.ybits -DartifactId=ybits-common -Dversion=0.0.5 -Dpackaging=jar -DgeneratePom=true -DcreateChecksum=true
```

## Usage

```java
try {
    SqlStore sqlStore = new SqlStore();
    sqlStore.createSqlHelper("mysql", "pms_db", "database.xml");
    SqlResultSet rs = sqlStore.get("pms_db").doQuery("select * from sm_user;");

    while (rs.next()) {
        System.out.println(rs.getString("USER_NAME"));
    }
} catch (NullPointerException e) {
    e.printStackTrace();
}
```

## Configuration
databaase.xml under resource directory. It will be loaded when SqlStore and SqlHelp do query or do exec.
```xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">  
<properties>  
  <comment>Default database configuration file</comment>  
 
  <entry key="sql.connectiopool.size">5</entry>
  <entry key="sql.mysql.url">localhost:3306</entry>
  <entry key="sql.mysql.schema">mysql_schema</entry>
  <entry key="sql.mysql.username">root</entry>
  <entry key="sql.mysql.password">root</entry>
  <entry key="sql.mysql.usessl">false</entry>
  <entry key="sql.mysql.autoreconnect">true</entry>
  
</properties>  
```