Mybatis && mysql 字段名是关键字报错

爱被打了一巴掌 2021-06-11 15:10 1614阅读 0赞

![753930-20160322134903448-1342671392.png][]

![复制代码][copycode.gif]

DROP TABLE IF EXISTS `bas_dictionary`;
    CREATE TABLE `bas_dictionary` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(20) NOT NULL COMMENT '字典名称',
      `key` varchar(50) NOT NULL COMMENT '代码',
      `value` varchar(20) NOT NULL COMMENT '字典值',
      `comment` varchar(100) DEFAULT NULL COMMENT '备注',
      `order` int(2) DEFAULT '99' COMMENT '排序',
      `create_time` datetime NOT NULL COMMENT '创建时间',
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='字典表';

![复制代码][copycode.gif]

遇到的问题：

SELECT order from bas_dictionary

[SQL]SELECT order from bas_dictionary
    
    [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order from bas_dictionary' at line 1

解决办法：

添加 反引号（Esc键下面的~键）

SELECT `order` from bas_dictionary

引出的问题：

mybatis-generator 如何生成带有反引号的mapper.xml

![复制代码][copycode.gif]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
      PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
      "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
      <classPathEntry location="./mysql-connector-java-5.1.37.jar" />
    
      <context id="OracleTables" targetRuntime="MyBatis3">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
    
        <commentGenerator>
          <property name="suppressAllComments" value="false" />
          <property name="suppressDate" value="true" />
        </commentGenerator>
    
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
            connectionURL="jdbc:mysql://localhost:3306/hhpf"
            userId="root"
            password="root123">
        </jdbcConnection>
    
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    
        
        <javaModelGenerator targetPackage="com.zno.pojo" targetProject="./">
          <property name="enableSubPackages" value="true" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
        
        <sqlMapGenerator targetPackage="com.zno.dao"  targetProject="./">
          <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.zno.dao"  targetProject="./">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
        
        
        <table schema="" tableName="bas_dictionary" domainObjectName="BasDictionary" delimitAllColumns="true"></table>
     
      </context>
    </generatorConfiguration>

![复制代码][copycode.gif]

关键点：

delimitAllColumns="true"

参考文档：

[http://mbg.cndocs.tk/][http_mbg.cndocs.tk]

![ExpandedBlockStart.gif][]

![复制代码][copycode.gif]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
      PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
    
    
     
    
    
    <context id="mysql" defaultModelType="hierarchical" targetRuntime="MyBatis3Simple" >
    
        
        <property name="autoDelimitKeywords" value="false"/>
        
        <property name="javaFileEncoding" value="UTF-8"/>
        
        <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
        
        <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
    
        
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
    
        
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql:///pss" userId="root" password="admin">
            
        </jdbcConnection>
    
        
        <javaTypeResolver type="org.mybatis.generator.internal.types.JavaTypeResolverDefaultImpl">
            
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
    
    
        
        <javaModelGenerator targetPackage="com._520it.mybatis.domain" targetProject="src/main/java">
            
            <property name="constructorBased" value="false"/>
    
            
            <property name="enableSubPackages" value="true"/>
    
            
            <property name="immutable" value="false"/>
    
            
            <property name="rootClass" value="com._520it.mybatis.domain.BaseDomain"/>
    
            
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
    
    
        
        <sqlMapGenerator targetPackage="com._520it.mybatis.mapper" targetProject="src/main/resources">
            
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
    
    
        
        <javaClientGenerator targetPackage="com._520it.mybatis.mapper" type="ANNOTATEDMAPPER" targetProject="src/main/java">
            
            <property name="enableSubPackages" value="true"/>
    
            
        </javaClientGenerator>
    
        
        <table tableName="userinfo" >
    
            
            <property name="constructorBased" value="false"/>
    
            
            <property name="ignoreQualifiersAtRuntime" value="false"/>
    
            
            <property name="immutable" value="false"/>
    
            
            <property name="modelOnly" value="false"/>
    
            
    
            
    
            
    
            
    
            
    
            
            <property name="selectAllOrderByClause" value="age desc,username asc"/>
    
            
            <property name="useActualColumnNames" value="false"/>
    
    
            
    
            
    
    
             
             <columnOverride column="username">
                 
                 <property name="property" value="userName"/>
    
                 
    
                 
    
                 
    
                 
             </columnOverride>
    
             
        </table>
    
    </context>
    
    </generatorConfiguration>

![复制代码][copycode.gif]

[753930-20160322134903448-1342671392.png]: /images/20210527/2035db3361254170846868c7ea8f59db.png
[copycode.gif]: /images/20210527/0eb07dc9d8ff455cabca558501b4ed6e.png
[http_mbg.cndocs.tk]: http://mbg.cndocs.tk/
[ExpandedBlockStart.gif]: /images/20210527/b2abe2b023a544ae97d1915a9e1450cf.png