insert报错:SQLException: ORA-01008: 并非所有变量都已绑定||SQLSyntaxErrorException: ORA-00917:缺失逗号

最新推荐文章于 2024-06-26 10:59:58 发布

三岁时超帅哦

最新推荐文章于 2024-06-26 10:59:58 发布

阅读量967

点赞数 1

分类专栏：报错文章标签： sql 缺失逗号

本文链接：https://blog.youkuaiyun.com/nbcsdn/article/details/99744026

版权

报错专栏收录该内容

12 篇文章

订阅专栏

package fun.no2;

import java.sql.*;

public class Jdbc {

    /**
     * @param args
     */
    private static final String URL="jdbc:oracle:thin:@localhost:1521:xe";
    private static final String DRIVER="oracle.jdbc.OracleDriver";
    private static final String USER="hr";
    private static final String PASSWORD="hr";
    public static void main(String[] args) {
        Connection conn=null;
        PreparedStatement stmt=null;
        try {
            Class.forName(DRIVER);
            conn=DriverManager.getConnection(URL, USER, PASSWORD);
//            String sql="insert into jobs values('zt_1234','zhuguan',5000,1000)";
            String sql="insert into jobs values(job_id=?,job_title=?,min_salary=?,max_salary=?)";
            stmt=conn.prepareStatement(sql);

            stmt.setString(1,"zt_3345");
            stmt.setString(2,"zhuguan");
            stmt.setInt(3,5000);
            stmt.setInt(4,10000);

            int rs=stmt.executeUpdate(sql);
            System.out.println(rs);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }finally {
            try{
                if(stmt!=null) {
                    stmt.close();
                    stmt=null;
                }
                if(conn!=null) {
                    conn.close();
                    conn=null;
                }
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

删除第二个sql即可
在这里插入图片描述
正确的：

    package fun.no2;

    import java.sql.*;

    public class Jdbc {

        /**
         * @param args
         */
        private static final String URL="jdbc:oracle:thin:@localhost:1521:xe";
        private static final String DRIVER="oracle.jdbc.OracleDriver";
        private static final String USER="hr";
        private static final String PASSWORD="hr";
        public static void main(String[] args) {
            Connection conn=null;
            PreparedStatement stmt=null;
            try {
                Class.forName(DRIVER);
                conn=DriverManager.getConnection(URL, USER, PASSWORD);
    //            String sql="insert into jobs values('zt_1234','zhuguan',5000,1000)";
    //            String sql="insert into jobs values(job_id=?,job_title=?,min_salary=?,max_salary=?)";
    //            String sql="insert into jobs(job_id,job_title,min_salary,max_salary) values(?,?,?,?)";
                String sql="insert into jobs values(?,?,?,?)";
                stmt=conn.prepareStatement(sql);

                stmt.setString(1,"zt_45");
                stmt.setString(2,"zhuguan");
                stmt.setInt(3,5000);
                stmt.setInt(4,10000);

                int rs=stmt.executeUpdate();
                System.out.println(rs);
            } catch (ClassNotFoundException | SQLException e) {
                e.printStackTrace();
            }finally {
                try{
                    if(stmt!=null) {
                        stmt.close();
                        stmt=null;
                    }
                    if(conn!=null) {
                        conn.close();
                        conn=null;
                    }
                }catch(SQLException e) {
                    e.printStackTrace();
                }
            }
        }

    }

愿你心如花木，向阳而生