【JavaDebug（二）】之Mysql语法异常java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； chec

Myth丶恋晨 2023-10-09 13:19 23阅读 0赞

### 本文章由公号【开发小鸽】发布！欢迎关注！！！ ###

**老规矩–妹妹镇楼：**

![20200721223424816.JPG][]

### 一. 异常 ###

#### （一）异常描述 ####

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 ''id',name,age) values(14,'dd',24)' at line 1

#### （二）解决问题 ####

在用JDBC连接Mysql时，总是报异常，通过查看异常提示，可以看到是SQL的语法问题：

right syntax to use near ‘‘id’,name,age)

我尝试着将字段名称里的单引号都消去了，结果没有报异常。

**可以看到，异常提示中 near ’ 已经提示我们了是单引号的问题！！！**

### 二. 代码 ###

package JDBC;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class InsertTest {
        
        public static void main(String[] args) {
        
            Statement stm = null;
            Connection con = null;
    
            try {
        
                //1.注册驱动
                Class.forName("com.mysql.cj.jdbc.Driver");
                //2.定义SQL
                String sql = "insert into student(id,name,age) values(14,'dd',24)";
                //3.获取Connection对象
                con = DriverManager.getConnection("jdbc:mysql:///heima", "root", " ");
                //4.获取执行SQL的对象Statement
                stm = con.createStatement();
                //5.执行SQL
                int count = stm.executeUpdate(sql);
                //6.处理结果
                System.out.println(count);
                if(count > 0){
        
                    System.out.println("添加成功！");
                }
                else{
        
                    System.out.println("添加失败！");
                }
            } catch (ClassNotFoundException | SQLException e) {
        
                e.printStackTrace();
            }finally {
        
                //释放资源
                //判断空指针异常
                if(stm != null){
        
                    try {
        
                        stm.close();
                    } catch (SQLException e) {
        
                        e.printStackTrace();
                    }
                }
    
                if(con != null){
        
                    try {
        
                        con.close();
                    } catch (SQLException e) {
        
                        e.printStackTrace();
                    }
                }
    
            }
    
        }
    }

[20200721223424816.JPG]: https://img-blog.csdnimg.cn/20200721223424816.JPG