今天在往数据库中插入数据时遇到了线程阻塞问题:
代码是这样的,使用批处理最优时间的方式,向数据库中插入多条数据:
public class TransTest {
private String driver = "oracle.jdbc.OracleDriver";
private String url = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
private String user = name;
private String pass = password;
Connection conn = null;
Statement st = null;
PreparedStatement prs = null;
public static void main(String[] args) throws SQLException {
TransTest test = new TransTest();
test.test4();
}
/*1.事物自己管理
*2.使用批处理
*3.使用PreparedStatement
*
* */
public void test4() {
try {
int num=0;
Class.forName(driver);
conn = DriverManager.getConnection(u