com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

最新推荐文章于 2024-05-12 15:33:22 发布

So_Band

最新推荐文章于 2024-05-12 15:33:22 发布

阅读量950

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/So_Band/article/details/81120861

版权

java 专栏收录该内容

54 篇文章 1 订阅

订阅专栏

Exception in thread “main” 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 ‘5,’2’,null)’ at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
at jdbc2.ExecuteDML.createTable(ExecuteDML.java:35)
at jdbc2.ExecuteDML.main(ExecuteDML.java:43)

看到这个错误了么？锤爆自己的狗头，肯定是你数据库写错了，在连接的时候记得加入空格。
使用DML语句来执行插入语句
public int insertData(String sql) throws Exception {
//加载驱动
Class.forName(“com.mysql.jdbc.Driver”);

    try(
            //获取数据库连接
            Connection conn = DriverManager.getConnection(url, user, pass);
            //使用Connection来创建一个Statement对象
            Statement stmt = conn.createStatement();
            ){
        //执行DML语句，
        return stmt.executeUpdate(sql);//返回几句受了影响
        }

}

使用DDL语句来创建表
public void createTable(String sql) throws Exception {
//加载驱动
Class.forName(“com.mysql.jdbc.Driver”);

    try(
            //获取数据库连接
            Connection conn = DriverManager.getConnection(url, user, pass);
            //使用Connection来创建一个Statement对象
            Statement stmt = conn.createStatement();
            ){
        //执行DDL语句，创建数据库
        stmt.executeUpdate(sql);
    }

}