首先声明一点,工具是不会有错的,肯定你个吊毛的错,对 ,就是我,先来看下我的错
SQL: insert into t_administrative (a_id, s_id, a_import_tzzl, a_import_tz_remark, a_import_file_route, a_expert_lzzl, a_expert_lz_remark, a_expert_file_route, a_risk_pgzl, a_risk_pgremark, a_risk-file_route, ssh_zl, ssh_remark, ssh_file_route, a_node_status, a_del_status) values (?,?,?, ?,?,?, ?,?,?, ?,?,?, ?,?,?, ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '-file_route, ssh_zl,
ssh_remark, ssh_file_route, a_node_status,
a_de' at line 4
insert 增加的时候报错,刚开始看一直因为是sql语句的问题,知道最后确定不是sql问题,回去看自己建立的表(自己建立的垃圾)
file-route.正确的应该是file_route.。好了,重新生成就可以了。