# oracle-upro-engine

**Repository Path**: wyh5215321/oracle-upro-engine

## Basic Information

- **Project Name**: oracle-upro-engine
- **Description**: upro适配oracle
- **Primary Language**: Java
- **License**: GPL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-01-14
- **Last Updated**: 2022-02-15

## Categories & Tags

**Categories**: Uncategorized

**Tags**: Java, 生成器, 存储过程, Oracle

## README

# oracle-upro-engine

#### 介绍
upro适配oracle  
简而言之：存储过程生成器

#### 使用说明

1. 引入依赖  
[upro代码拉取](https://gitee.com/wyh5215321/upro)
[oracle-upro-engine代码拉取](https://gitee.com/wyh5215321/oracle-upro-engine)
```xml
       <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>oracle-upro-engine</artifactId>
            <version>1.0-SNAPSHOT</version>
            <scope>runntime</scope>
        </dependency>
        <dependency>
            <groupId>com.wlzk</groupId>
            <artifactId>upro</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
```


2. 开始使用  
   upro.txt 文件在resource下面
```java
//        读取upro程序
        BufferedReader br=new BufferedReader(new FileReader("P:\\upro.txt"));
        String value="";
        StringBuffer stringBuffer = new StringBuffer();
        while((value=br.readLine())!=null) {
        stringBuffer.append(value + "\n");
        }
//        解析生成Procedure对象
        Parser parser = new Parser();
        Procedure procedure= parser.analyze(stringBuffer.toString());

//        加载生成器
        Class.forName("com.oracle.upro.OracleGenerater");
//          获取生成器
        Generate generate = BuilderManager.getGenerater();
//        加载存储过程
        generate.LoadProcedure(procedure);
//        进行转化
        generate.build("P:\\","test.txt");
```


#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request