java 多线程操作数据库

import java.io.*;

import java.sql.*;

public class ToOracle {

public static void main(String[] args) {

int n = 10;//每个线程执行的个数

//System.out.println("start action!!!!!!");

ToOracle ac = new ToOracle();

ThreadRun[] testrun = new ThreadRun[21];

for (int i = 1; i <= 21; i++) {

testrun[i] = ac.new ThreadRun();

testrun[i].TRun(n);

System.out.println("线程" + i + "已经启动");

}

//testrun[1] = ac.new ThreadRun();

//testrun[1].TRun(10);

for (int i = 1; i <= 21; i++) {

testrun[i].TExit();

}

}

class ThreadRun {

String blobname = "D:\eclipse\test\test1.txt"; //blob文件名

String clobname = "D:\eclipse\test\test2.txt"; //clob文件名

String in = "insert into ";

String in1 = "(order_id,ric_code,siz,price,trade_datetime,status,testblob,testclob) values(9,′asdfjkl′,21,123.34567,sysdate,′nill逆耳′,?,?)";

String tablename = "orders1";

String sqlstr = ""; // sql 语句

ThreadUseExtends thread = new ThreadUseExtends(blobname, clobname,

sqlstr);

public void TRun(int n) {

sqlstr = in + tablename + in1;