# jsql

**Repository Path**: jfinal/jsql

## Basic Information

- **Project Name**: jsql
- **Description**: JFINAL的SQL插件
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 0
- **Created**: 2016-04-30
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#jsql简介
----------------
##概要
1. SQL与JAVA代码分离
2. XML配置
3. JS语法的SQL模板引擎,简单易学

##语法
1. <%=%> ,例如：name = <%=name%>,将转换成 name = ? ,并将参数变量添加到Args中
2. <%-%> ,例如：name = <%-name%>,将转换成 name = ? ,并将参数变量转义后添加到Args中
3. <%+%> ,例如：name = <%+name%>,将转换成 name = 'jfinal'

##配置步骤
1. 主配置文件JSql-Config.xml
```
<?xml version="1.0" encoding="UTF-8"?>
<jsqlconfig>
    <jsqlpath path="/JSql-User.xml" />
</jsqlconfig>
```

2. SQL配置文件JSql-User.xml
```
<?xml version="1.0" encoding="UTF-8"?>
<jsql namespace="user">
    <sql id="getusers">
    <![CDATA[
        select * from user t where 1 =1 and
        <%if(typeof(state) != 'undefined'){%>
            t.state = <%=state%>
        <%}%>
        <%if(typeof(ids) != 'undefined'){%>
            and t.id in (<%for(var i=0;i<ids.length;i++){%> <%=ids[i]%> <%if(i < ids.length-1){%> , <%}%> <%}%>)  
        <%}%>
        order by name desc
    ]]>
    </sql>
</jsql>
```

3. JAVA初始化
```
new JSqlPlugin("/JSql-Config.xml").start();
```

4. 调用SQL
```
Map<String, Object> m = new HashMap<String, Object>();
SqlArgs sqlArgs = JSqlKit.getSqlArgs("user.getusers",m);
```

5. 执行SQL语句
```
Db.find(sqlArgs.getSql(), sqlArgs.getArgs().toArray());
```