# sea-sqlparser

**Repository Path**: seaxlab/sea-sqlparser

## Basic Information

- **Project Name**: sea-sqlparser
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-01-05
- **Last Updated**: 2026-01-05

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Sea SQL Parser

> 基于jdbcTemplate实现SQL DML相关操作

## 优势

- 基于spring-jdbc jdbcTemplate实现
- 减少对ORM的依赖
- 以编程方式方式手动控制
- 目前仅支持MySQL类

## 使用

````
  <groupId>io.github.seaxlab</groupId>
  <artifactId>sea-sqlparser</artifactId>
  <version>x.y.z</version>
````

## 示例

### 新增

````
    InsertModel insertModel = new InsertModel("t_user");
    SqlUtil.set(insertModel, "user_id", "1");
    SqlUtil.set(insertModel, "user_name", "2");

    log.info("{}", insertModel.toSql());
    log.info("{}", insertModel.getValues());
````

### 更新

````
    UpdateModel updateModel = new UpdateModel("frm_tenant_config");
    //
    SqlUtil.set(updateModel, "code", "new code");
    SqlUtil.set(updateModel, "name", "new name");
    //
    SqlUtil.eq(updateModel, "tenant_id", "merchant01");
    SqlUtil.eq(updateModel, "code", "abc");
    SqlUtil.eq(updateModel, "parent_code", "123");
    SqlUtil.eq(updateModel, "name", Arrays.asList("abc", "def"));
    SqlUtil.eq(updateModel, "deleted", 0);
````

### 删除

````
    DeleteModel deleteModel = new DeleteModel("frm_tenant_config");
    //
    SqlUtil.eq(deleteModel, "tenant_id", "merchant01");
    SqlUtil.eq(deleteModel, "code", "abc");
    SqlUtil.eq(deleteModel, "id", Arrays.asList(1, 2, 3, 4));
    SqlUtil.eq(deleteModel, "deleted", 0);
````

### 查询

````
    QueryModel queryModel = new QueryModel("frm_tenant_config");

    queryModel.setColumns(Arrays.asList("id", "tenant_id", "parent_code", "parent_name",
      "code", "name", "value", "extra", "remark"));
    SqlUtil.eq(queryModel, "tenant_id", "merchant01");
    SqlUtil.eq(queryModel, "code", "abc");
    SqlUtil.eq(queryModel, "parent_code", "123");
    SqlUtil.eq(queryModel, "name", Arrays.asList("abc", "def"));
    SqlUtil.eq(queryModel, "deleted", 0);
````

### 其他示例

- `com.github.seaxlab.sqlparser.SqlUtilTest`