public void testStatementAddBatch() public void testConnCommit()

最新推荐文章于 2022-02-20 15:59:26 发布

okrensky888

最新推荐文章于 2022-02-20 15:59:26 发布

阅读量139

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/okrensky888/article/details/84011363

版权

JAVA 专栏收录该内容

16 篇文章 0 订阅

订阅专栏



   public void testStatementAddBatch()
    {
        Connection conn = null;
        Statement stmt = null;
        try
        {
            conn = getDBConnectionMsSqlBySuperAdmin();
            stmt = conn.createStatement();
            for(int i = 0; i < 100; i++)
            {
                String sql = " sql " + i;
                stmt.addBatch(sql);
            }
            stmt.executeBatch();
        }
        catch(SQLException e)
        {
            e.printStackTrace();
        }
        finally
        {

        }
    }

//    private boolean insertIntoSpecialDataTableFromList(List insertSqlList, String[] cts, PreparedStatement pstmt, Connection connection)
//    {
//        boolean isExecuteCorrect = false;
//        try
//        {
//            for(int i = 3; i < insertSqlList.size(); i++)
//            {
//                String recorder = (String)insertSqlList.get(i);
//                String[] rs = recorder.split(ResBackupUtil.SPLIT_TAG);
//                for(int k = 0; k < rs.length; k++)
//                {
//                    setObject(pstmt, k + 1, cts[k], rs[k]);
//                }
//                pstmt.addBatch();
//                if(i % FLUSH_COUNT == 0 || i == insertSqlList.size() - 1)
//                {
//                    pstmt.executeBatch();
//                    connection.commit();
//                }
//
//            }
//            isExecuteCorrect = true;
//        }
//        catch(SQLException e)
//        {
//            logger.error(e.getMessage(), e);
//        }
//        return isExecuteCorrect;
//    }

//    public void insertGroupInfoListIntoLocationMapping()
//    {
//        clearLocationMappingTable();
//
//        String sql = "insert into LocationMapping values(?,?)";
//        Connection connN3 = null;
//        PreparedStatement ps = null;
//        try
//        {
//            DataUpgradeContext context = DataUpgradeContexManager.getDataUpgradeContex();
//            connN3 = DbUtil.getUepDatabaseConnection("n3common", context);
//            ps = connN3.prepareStatement(sql);
//            executeBatchInsert(ps);
//        }
//        catch(SQLException e)
//        {
//            e.printStackTrace();
//        }
//        catch(DataUpgradeException e)
//        {
//            e.printStackTrace();
//        }
//        finally
//        {
//            DbUtil.closeDB(connN3, ps, null);
//        }
//    }
//
//    private void executeBatchInsert(PreparedStatement ps) throws SQLException
//    {
//        for(int i = 0; i < groupInfoList.size(); i++)
//        {
//            GroupInfo groupInfo = groupInfoList.get(i);
//            ps.setString(1, groupInfo.getOid());
//            ps.setString(2, groupInfo.getName());
//            System.out.println("insert into LocationMapping:" + groupInfo.getName());
//            ps.addBatch();
//            if((i + 1) % FLUSH_COUNT == 0 || (i + 1) == groupInfoList.size())
//            {
//                ps.executeBatch();
//            }
//        }
//
//    }

    public void testConnCommit()
    {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try
        {
            conn = getDBConnectionMsSqlBySuperAdmin();
            conn.setAutoCommit(false);
            for(int i = 0; i < 100; i++)
            {
                String sql = " sql " + i;
                pstmt = conn.prepareStatement(sql);
                pstmt.execute();
                // pstmt.executeQuery();
                // pstmt.executeUpdate();
            }
            conn.commit();
        }
        catch(Exception e)
        {
            if(conn != null)
            {
                try
                {
                    conn.rollback();
                }
                catch(SQLException e1)
                {
                    e.printStackTrace();
                }
            }
        }
        finally
        {
            if(pstmt != null)
            {
                try
                {
                    pstmt.close();
                }
                catch(SQLException e)
                {
                    e.printStackTrace();
                }
            }
            if(conn != null)
            {
                try
                {
                    conn.setAutoCommit(true);
                    conn.close();
                }
                catch(SQLException e)
                {
                    e.printStackTrace();
                }

            }
        }

    }