# enjoy-sql

**Repository Path**: linbq-b7/enjoy-sql

## Basic Information

- **Project Name**: enjoy-sql
- **Description**: enjoy-sql = JFinal enjoy + JFinal sqlkit
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: https://gitee.com/linbq-b7/enjoy-sql
- **GVP Project**: No

## Statistics

- **Stars**: 4
- **Forks**: 1
- **Created**: 2017-12-20
- **Last Updated**: 2021-11-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

enjoy-sql = JFinal enjoy + JFinal sqlkit

1.让低版本JFinal使用enjoy的sql管理功能。

2.同时也支持非JFinal项目使用。

使用方式：
maven引入
```
<dependency>
    <groupId>com.lastB7</groupId>
    <artifactId>enjoy-sql</artifactId>
    <version>3.3.4</version>
</dependency>
```

初始化插件
```
me.add(new EnjoySqlPlugin());
```
添加sql文件，支持从jar中读取sql文件
在resources目录下添加 sql 文件夹

![输入图片说明](https://gitee.com/uploads/images/2017/1223/145444_1e63b933_869245.png "屏幕截图.png")


调用

任意非web下调用：获取sql魔板中的sql语句
```
    public static void main(String[] args) {
        new EnjoySqlPlugin().start();

        List list = new ArrayList();
        list.add(2);
        list.add(5);
        String ids = StringUtils.join(list.toArray(), ",");

        Kv kv = new Kv();
        kv.set("ids", ids);
        kv.set("title", "test");
        kv.set("content", "test 1");
        SqlPara sqlPara = SqlUtil.getSqlPara("blog.queryList",kv);
//        System.out.println(sqlPara);
        String[] sql = PageSqlKit.parsePageSql(sqlPara.getSql());
        System.out.println("select:"+sql[0]);
        System.out.println("select:"+sql[1]);
        System.out.println(sqlPara);
    }

```

```
Sql:   SELECT
    id,
    title,
    content
  FROM
    blog
  WHERE 1=1
    AND title LIKE ?
    AND id IN (?,?)
    AND content = ?

Para: [%test%, 2, 5, test 1]
```

JFinal下调用
```
    public void configPlugin(Plugins me) {
        // 配置C3p0数据库连接池插件
        C3p0Plugin C3p0Plugin = createC3p0Plugin();
        me.add(C3p0Plugin);

        // 配置ActiveRecord插件
        ActiveRecordPlugin arp = new ActiveRecordPlugin(C3p0Plugin);
        me.add(arp);

        // 所有配置在 MappingKit 中搞定
        _MappingKit.mapping(arp);

        // 配置enjoy-sql插件
        me.add(new EnjoySqlPlugin());
    }
```

```
    public void queryList() {
        String ids = this.getPara("ids");
        String title = this.getPara("title");
        String content = this.getPara("content");

        Kv kv = new Kv();
        kv.set("ids", ids);
        kv.set("title", title);
        kv.set("content", content);

        SqlPara sqlPara = SqlUtil.getSqlPara("blog.queryList", kv);
        String[] sql = PageSqlKit.parsePageSql(sqlPara.getSql());

        Page<Record> page = Db.paginate(1, 10, sql[0], sql[1], sqlPara.getPara());
        setAttr("page", page);
        renderJson();
    }
```

浏览器输入：http://127.0.0.1:8080/blog/queryList?ids=1,4  进行访问。

具体可参考/Demo/jfinal2.2_demo

EnjoySqlPlugin.java实现代码，可在https://gitee.com/linbq-b7/enjoy-sql/tree/master/plugin 中获取


// todo spring demo