JDBC

最新推荐文章于 2025-07-30 16:12:42 发布

最新推荐文章于 2025-07-30 16:12:42 发布 · 99 阅读

文章标签：

#数据库

JDBC 专栏收录该内容

1 篇文章

订阅专栏

http://download.oracle.com/javase/tutorial/jdbc/basics/prepared.html

PreparedStatement stmt = null;
            Connection conn = null;
            try {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                conn = DriverManager.getConnection(
                        "jdbc:oracle:thin:@10.225.115.44:1521:test",
                        "PIPEADMIN", "PIPEADMIN");


                String sqlStr;
                for(int i = 0; i < iurFolder.list().length; i++) {

                    iurFile = new File(fileNames[i]);
                    sqlStr = "insert into t_iur(iur_id,queue_id,pcc,iur_file_name)" +
                            " values(sq_t_iur.nextval,'queue001','pcc001',?)";
                    stmt = conn.prepareStatement(sqlStr);
                    stmt.setString(0, fileNames[i]);
                    stmt.executeUpdate(sqlStr);
                }