java数据库提交模板,简单的连接数据库的java程序模板

import java.sql.*;

import java.io.*;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.SQLException;

public class perftest

{

public staticvoidmain(String arr[]) throws Exception

{

System.out.println("start");

DriverManager.registerDriver(neworacle.jdbc.driver.OracleDriver());

Connection

conn=DriverManager.getConnection

("jdbc:oracle:thin:@LLWP0JKR8KXJJ6J:1521:muphy", "eoda", "foo");

Integer iters= new Integer(arr[0]);

Integer commitCnt= new Integer(arr[1]);

conn.setAutoCommit(false);

doInsert(conn,1, 1);

Statement stmt=conn.createStatement();

stmt.execute("begin dbms_monitor.session_trace_enable(waits=>true); end;");

doInsert(conn, iters.intValue(), commitCnt.intValue());

conn.close();

}

staticvoid doInserts(Connection con, int count, intcommitCount )

throws Exception

{

PreparedStatement ps=con.prepareStatement

("insert into test " +

"(id, code, descr, insert_user, insert_date)"

+ " values (?,?,?, user, sysdate)");int rowcnt = 0;int committed = 0;for (int i = 0; i < count; i++)

{

ps.setInt(1,i);

ps.setString(2,"PS - code" +i);

ps.setString(3,"PS - desc" +i);

ps.executeUpdate();

rowcnt++;if ( rowcnt ==commitCount )

{

con.commit();

rowcnt= 0;

committed++;

}

}

con.commit();

System.out.println

("pstatement rows/commitcnt = " + count + " / " +committed );

}

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值