org.beetl.sql.clazz.kit.BeetlSQLException: com.microsoft.sqlserver.jdbc.SQLServerException: “`”附近有语法

男娘i 2023-10-04 21:31 3阅读 0赞

问题描述：

可以查询，但是不能在使用mapper.inster 插入数据时 出现问题

![e73bf53ff90e4b91b7eeb5a97e5e01e4.png][]

实体类

@Data
    @NoArgsConstructor
    @AllArgsConstructor
    @Table(name = "Emp")
    public class Emp {
    
    //        @AssignID
            @Column("empId")
            private String empId;
            @Column("empName")
            private String  empName;
            @Column("age")
            private Integer  age;
            @Column("gender")
            private Integer gender;
            @Column("hireDate")
            private String  hireDate; //入职时间
            @Column("deptName")
            private Integer deptName; // 部门
    
    }

mapper

public interface EmpMapper extends BaseMapper<Emp> {
    
        @Sql("select * from  [dbo].[Emp] WHERE  empId=?")
        @Select
        Emp queryEmpById(Integer id);
    
        /*
          分页查询
         select * from [dbo].[userInfo]
          order by  id
        offset (1-1)*10 rows
        fetch next 10 rows only;
      */
        @Template("select * from  [dbo].[Emp] order by id offset (#{page} - 1 )*(#{limit}) rows fetch next #{limit} rows only")
       @Select
       List<Emp> queryUserInfoPageList( int page, int limit);
    
       @Sql("select * from  Emp")
       @Select
        List<Emp> queryEmpList();
    }

testsql

![fae42eaadcb04847ad7666930d8da5ff.png][]

发现配置有问题：

pom 文件 要用下面的

<dependency>
                <groupId>com.ibeetl</groupId>
                <artifactId>beetlsql</artifactId>
                <version>3.19.3-RELEASE</version>
            </dependency>
            <dependency>
                <groupId>com.ibeetl</groupId>
                <artifactId>sql-saga-springkafa</artifactId>
                <version>3.1.0-RELEASE</version>
            </dependency>

不能用start

<dependency>-->
                版本bug-->
               <groupId>com.ibeetl</groupId>-->
               <artifactId>sql-springboot-starter</artifactId>-->
                <version>3.10.1-RELEASE</version>-->
          </dependency>-->

yml配置 要用org.beetl.sql.core.db.OracleStyle 不能用org.beetl.sql.core.db.MySqlStyle

>     beetlsql:
>       sqlManagers: sqlManager1
>       sqlManager1:
>         ds: datasource
>         basePackage: com.hu.mapper
>         #dbStyle: org.beetl.sql.core.db.MySqlStyle 配置错误 导致插入失败
>         dbStyle: org.beetl.sql.core.db.OracleStyle

pom

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.5.2</version>
            <relativePath/> 
        </parent>
        <groupId>com.hu</groupId>
        <artifactId>testq</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>testq</name>
        <description>testq</description>
        <properties>
            <java.version>11</java.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-freemarker</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-io</artifactId>
                <version>1.3.2</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context-support</artifactId>
                <version>5.1.7.RELEASE</version>
                <scope>compile</scope>
            </dependency>
    
             <dependency>
               <groupId>net.sourceforge.nekohtml</groupId>
                 <artifactId>nekohtml</artifactId>
             </dependency>
    
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
                <scope>runtime</scope>
                <optional>true</optional>
            </dependency>
    
    
    
    
    
    
    
            
            
    
    
    
    
    
    
    
    
    
    
    
    
    
    
            <dependency>
                <groupId>com.ibeetl</groupId>
                <artifactId>beetlsql</artifactId>
                <version>3.19.3-RELEASE</version>
            </dependency>
            <dependency>
                <groupId>com.ibeetl</groupId>
                <artifactId>sql-saga-springkafa</artifactId>
                <version>3.1.0-RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.zaxxer</groupId>
                <artifactId>HikariCP</artifactId>
                <version>4.0.3</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>com.microsoft.sqlserver</groupId>
                <artifactId>mssql-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>com.ibeetl</groupId>
                <artifactId>sql-core</artifactId>
                <version>3.19.3-RELEASE</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

yml

server:
      port: 8881
    spring:
        application:
          name: freemarker-demo
        freemarker:
          #指定HttpServletRequest的属性是否可以覆盖controller的model的同名项
          allow-request-override: true
          #req访问request
          request-context-attribute: req
          #后缀名freemarker默认后缀为.ftl，当然你也可以改成自己习惯的.html
          suffix: .ftlh
          #设置响应的内容类型
          content-type: text/html;charset=utf-8
          #是否允许mvc使用freemarker1
         # enabled: true
          #是否开启template caching
          cache: false
          #设定模板的加载路径，多个以逗号分隔，默认: [“classpath:/templates/”]
          template-loader-path: classpath:/templates
          #设定Template的编码
          charset: UTF-8
        datasource:
          url: jdbc:sqlserver://172.16.10.77:1433;database=test;encrypt=true;trustServerCertificate=true
          username: sa
          password: '000000'
          driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    beetlsql:
      sqlManagers: sqlManager1
      sqlManager1:
        ds: datasource
        basePackage: com.hu.mapper
    #    dbStyle: org.beetl.sql.core.db.MySqlStyle 配置错误 导致插入失败
        dbStyle: org.beetl.sql.core.db.OracleStyle

[e73bf53ff90e4b91b7eeb5a97e5e01e4.png]: https://img-blog.csdnimg.cn/e73bf53ff90e4b91b7eeb5a97e5e01e4.png
[fae42eaadcb04847ad7666930d8da5ff.png]: https://img-blog.csdnimg.cn/fae42eaadcb04847ad7666930d8da5ff.png