Mybatis java.sql.SQLSyntaxErrorException

问题原因

我一般出现该问题的原因为：在拼接别人的SQL语句字段没有加，

解决方式：

将Java控制台中的错误信息，放置到一个能够良好显示的编辑器中，然后查看错误信息即可。

09-26 17:03:41.693 [http-nio-9801-exec-8] ERROR druid.sql.Statement - [statementLogError,149] - {conn-10005, pstmt-20002} execute error. insert into xhpc_charging_pile
         ( charging_station_id,
     
                name,
     
                national_standard,
   
                power,
    
                auxiliary_power_supply,
    
                input_voltage,
 
                max_voltage,

                min_voltage,

                max_electric_current,

                min_electric_current,

                serial_number,

                type,

                program_version,

                network_link_type,

                gun_number,
                    
                communication_protocol_version,
                    
                communication_operator,       
            
                sim_card,
                   
                rate_model_id,
                
                brand_model
                    
                production_date      
            
                connector_type
          
                current ) 
         values ( ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,
                ?,       
                ?        
                ?           
                ?                  
                ? )
java.sql.SQLSyntaxErrorException: 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 'production_date connector' at line 69

可以看到在后面的字段中，因为没有加,区分开来，从而导致SQL语句语法错误。