- 论坛徽章:
- 0
|
- for (int j = QiShiHaoMa; j < QiShiHaoMa + count; j++) {
- proRandom randomM = new proRandom();//产生随机数
- if (arrayList1.contains(j)) {
- String JX = String.valueOf(arrayList2.get(j)) + "Բ";
- String SQL = "insert into XinXi(fapysxx_dm,fapysxx_hm,fapysxx_mm,fapysxx_jx,fapysxx_qh) values(" +
- DaiMa + "," + j + "," + randomM.createInteger() + "," +
- JX + "," + QH + ")";
- databaseCon3.executeUpdate(SQL);
- }
- else {
- String SQL = "insert into XinXi(fapysxx_dm,fapysxx_hm,fapysxx_mm,fapysxx_jx,fapysxx_qh) values(" +
- DaiMa + "," + j + "," + randomM.createInteger() + ",'" +
- defaultJX + "'," + QH + ")";
- databaseCon3.executeUpdate(SQL);
- }
- //---------------------------在MySQL里可以这样,但在SQL Server我就不清楚了--------------------------------
- String SQL = "insert into XinXi(fapysxx_dm,fapysxx_hm,fapysxx_mm,fapysxx_jx,fapysxx_qh) values";
- for (int j = QiShiHaoMa; j < QiShiHaoMa + count; j++) {
- proRandom randomM = new proRandom();//产生随机数
- if (arrayList1.contains(j)) {
- String JX = String.valueOf(arrayList2.get(j)) + "Բ";
- SQL += "(" + DaiMa + "," + j + "," + randomM.createInteger() + "," +JX + "," + QH + "),";
- }else {
- SQL +="(" +
- DaiMa + "," + j + "," + randomM.createInteger() + ",'" +
- defaultJX + "'," + QH + "),";
- }
- }
- //此处加一行代码处理掉SQL里的最后一个 ',' 号
- databaseCon3.executeUpdate(SQL);
复制代码
------------------------
不过对于二百万的记录不知我这种方法是否有用,应该是占内存太大了!!!
[ 本帖最后由 tsgx8848 于 2006-10-18 11:49 编辑 ] |
|