# SQLParser

**Repository Path**: eliyanfei/SQLParser

## Basic Information

- **Project Name**: SQLParser
- **Description**: 类似于mybatis的SQL解析，仅供参考学习
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 4
- **Forks**: 0
- **Created**: 2018-07-25
- **Last Updated**: 2022-07-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQLParser
v1.0.0
- 实现解析sql.xml配置文件
- 通过代理的方式获取单条SQL配置进行解析
- 动态生成Java类，变量，方法，进行sql里面if判断
- 查询数据，返回List<Map<String,Object>>数据集合。
- 暂时没有实现缓存和线程池的问题

v1.0.1
- 修改包结构
- SqlParam 加入Bean对象值转HashMap
- 加入Oracle和MySQL的分页查询
- 加入增删改支持
- 加入缓存

v1.0.2
-- 加入Bean对象返回类型

# Demo

```
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/sql.xsd">
	<sqls namespace="area" dbname="aaa">
		<sql id="edit" query="false" desc="编辑某个区域">
			<![CDATA[
				update tbl_area 
					set  type =? ,name =?
						where id=?
			]]>
		</sql>
		<sql id="delete" query="false" desc="删除某个区域">
			<![CDATA[
				delete from  tbl_area  where id=?
			]]>
		</sql>
		<sql id="get" returnType="com.bean.AreaBean" query="true" desc="获取某个区域">
			<![CDATA[
				select  * from  tbl_area  where id=?
			]]>
		</sql>
		<sql id="list" desc="查询所有区域" returnType="java.util.HashMap">
			<![CDATA[
				select province,city,type,name,id
				from  tbl_area t1 
				where 1=1 $where
					 order by province,city
			]]>
			<if test="city != null and city.trim() != ''">
				and city like #{city}
			</if>
			<if test="province != null and province.trim() != ''">
				and province like #{province}
			</if>
			<if test="name != null and name.trim() != ''">
				and name like '%#{name}%' </if>
			<if test="name != null and name.trim() != ''">
				and name like '%#{name}%' </if>
		</sql>
		<sql id="tree" desc="区域数结构" returnType="java.util.HashMap">
			<![CDATA[
				select t.*,p.province_name,c.city_name from tbl_area t 
            left join tbl_province p on p.province_id=t.province
            left join tbl_city c on c.city_id=t.city
            where c.city_id=?
			]]>
		</sql>

	</sqls>
</config>
```
```
<?xml version="1.0" encoding="UTF-8"?>
<config>
	<db name="aaa" type="oracle" belongs="哪些省用这些库">
		<param key="driverClassName">oracle.jdbc.driver.OracleDriver</param>
		<param key="url">jdbc:oracle:thin:@10.190.2.201:1521/orcl</param>
		<param key="username">a</param>
		<param key="password">b</param>
	</db>

	<db name="bbb" type="oracle" belongs="哪些省用这些库">
		<param key="driverClassName">oracle.jdbc.driver.OracleDriver</param>
		<param key="url">jdbc:oracle:thin:@10.190.2.201:8093/orcl</param>
		<param key="username">a</param>
		<param key="password">b</param>
	</db>
	
</config>
```
# Code
- 启动的时候加载
```
	SQLFactory.getConfig().loadConfig(new File("config").getAbsolutePath(), "aaa");
```
- 使用
```
private ISqlService service = (ISqlService) new SqlProxy().getInstance(ISqlService.class);


SqlParam sqlParam = new SqlParam("wo_close");
sqlParam.addParams(paramsMap.get("id"));
service.execute(sqlParam);

具体方法参考ISqlService
```