【根据官网任务异常不能成功捕捉 _数据库】

根据官网任务异常不能成功捕捉

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

数据库

详细描述

源码

import Util.C3P0ConnUtil;
import org.apache.log4j.Logger;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Test {
    @org.junit.Test
    public void test() {
        Logger logger=Logger.getLogger(Test.class);

        Connection connection = C3P0ConnUtil.getConnection();
        System.out.println(connection);
        for (int i = 0; i < 100000; i++) {
            try {
                PreparedStatement stmt = connection.prepareStatement("insert into person (name,age,QQ) values ('loop', '18', '77967')");
//                PreparedStatement stmt = connection.prepareStatement("delete from person where QQ = '20111111'");
                stmt.execute();
                System.out.println("插入成功");
            } catch (SQLException e) {
                e.printStackTrace();
                System.out.println("报错 " + e);
            }
            C3P0ConnUtil.closeconn(connection);
        }
//        logger.info("gyggg");
    }
}

编辑于2024-11-16