sql2java: 轻量级数据库(SQL)访问代码(java)生成器

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 8

fchp/sql2java

forked from 10km/sql2java

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

New file Create Diagram file

master

Branches (17)

Tags (223)

Manage

master

more32

dev

datasupport-lang3-optimize

huangpu-patch

5.3.10-patch

patch-5.5.0

aocache

spring-boot-starter

more32-spring-boot-starter

4.4.2-patch

manager-refact-flag

datesupport

autotab

3.3.x

serial

multi

sql2java-5.6.9

sql2java-5.6.8

sql2java-3.35.0-huangpu-patch

sql2java-5.6.7

sql2java-3.35.0

sql2java-5.6.6

sql2java-5.6.5

sql2java-5.6.4

sql2java-5.3.10-patch1

sql2java-5.6.3

sql2java-5.6.2

sql2java-5.6.1

sql2java-5.6.0

sql2java-5.6.0-alpha8

sql2java-5.6.0-alpha7

sql2java-5.6.0-alpha6

sql2java-5.6.0-alpha5

sql2java-5.5.0-patch2

sql2java-5.6.0-alpha4

sql2java-5.5.0-patch

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

New file Create Diagram file

Branches 17

Tags 223

contribute

Sync branch

Create Pull Request

known more

See difference Through Pull Request Sync

Sync branch

Through Pull Request Sync

A Pull Request will be created to the current
branch and will be merged in to complete the sync

10km [maven-release-plugin] prepare for next de... 0e68192

858 commits

File empty ...

src

.gitignore

README.md

pom.xml

README

# sql2java-redis
## 引入依赖

maven下引入sql2java-redis项目依赖

```xml
		<dependency>
			<groupId>com.gitee.com</groupId>
			<artifactId>sql2java-redis</artifactId>
			<version>3.11.0</version>
		</dependency>
```
sql2java-redis 实现指定的数据库表基于Redis的只读缓存,用于不藕合的系统之间基于Redis的数据库表信息共享。

负责提供数据的系统作为数据提供者使用[RedisCache](src/main/java/gu/sql2java/redis/cache/RedisCache.java)实现将指定的表实时同步到Redis,

作为数据消费者的系统则使用[RedisCacheReader](src/main/java/gu/sql2java/redis/cache/RedisCacheReader.java)从Redis中以表的主键或唯一键字段检索获取JSON格式的数据库表记录

## JDK requirement

JDK 要求 1.8

## 快速入门

```java
public class RedisCacheTest implements Constant{

@BeforeClass
	public static void setUpBeforeClass() throws Exception {
		TableManagerInitializer.INSTANCE.init();
 /** 数据提供者角色 */
		/** 创建表缓存 */
		RedisCaches.createCache(DeviceBean.class, "id")
 /** 启动缓存 */
 .start();
 System.out.println("primary key cache loaded");
 /** 创建表缓存(主键和唯一键) */
		//RedisCaches.createCaches(DeviceBean.class, "id","physical_address")
 // /** 启动缓存 */
 // .start();
	}

@Test
	public void test() {
		/** 数据消费者角色 */
 /** 创建缓存读取实例 */
		RedisCacheReader reader = RedisCaches.createCacheReader("DeviceBean", "id");
 /** 从REDIS中根据主键获取表记录 */
		JSONObject json = reader.get(2);
		assertNotNull(json);
		SimpleLog.log("{} :{}",String.valueOf(json.get("id")),
				JSON.toJSONString(json, true));
	}

}
```

## 输出字段配置

### columns

创建RedisCache时,如果并不希望将所有字段都暴露出来,可以通过 `RedisCache.columns`方法配置数据库对象转换为JSON时的输出字段

`RedisCache.columns`方法参数说明:

| 参数名 | 说明 |
| ------- | ------------------------------------------------------------ |
| include | 为true时columns为需要输出的字段白名单,只有在名单中的字段才会被输出,否则为输出字段黑名单,在名单中的字段不会被输出 |
| columns | 白名单/黑名单字段名列表 |

示例:

```java
/** 创建主键为索引的RedisCache */
RedisCache.createCache(DeviceBean.class)
 		/** 输出除 token_time 之外的所有字段 */
			.columns(false, "token_time")
			.start();
```

### jsonFields

对于保存JSON格式数据的字段如果希望该字段被解析为JSON对象需要通过`RedisCache.jsonFields`指定字段的ID或字段名

示例:

```java
/** 创建唯一键 physical_address 为索引的RedisCache */
RedisCache.createCache(DeviceBean.class,"physical_address")
 		/** 指定 props,device_detail 为JSON字段 */
			.jsonFields("props","device_detail")
			.start();
```

### setJsonFormater

`RedisCache.setJsonFormater`方法允许应用层提供完全自定义的数据库对象转换为JSON实现方式,使用这种方式,则忽略`columns,jsonFields`方法提供的参数