exceltodb.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

				int cols = sheet.getColumns();//得到总列数
				for(int j=0;j<rows;j++){
					String[] colValue = new String[cols];
					for(int k=0;k<cols;k++){
						colValue[k] = sheet.getCell(k,j).getContents().trim();
 					}
					l.add(colValue);
				}
				
				if(l.size()!=0){
					OutputStream os = null; 
					WritableWorkbook wwb = null;
					WritableSheet ws = null;
					for(int j=0;j<l.size();j++){
						if(j%pageRows==0){
							if(wwb!=null){
								wwb.write();
								wwb.close();
								os.close();
							}
							os = new FileOutputStream(url1+num+".xls");
							num++;
							wwb = Workbook.createWorkbook(os);
							ws = wwb.createSheet("sheet1", 0);
						}
						String[] tvalue = (String[])l.get(j);
						for(int k=0;k<tvalue.length;k++){
							Label labelvalue = new Label(k,j%pageRows,tvalue[k]);
							ws.addCell(labelvalue);
						}
					}
					wwb.write();
					wwb.close();
					os.close();
				}
			}
			return true;
		}catch (Exception ex){
	    	ex.printStackTrace();
	      	return false;
		}
	}
	
	//查找在str2中存在，但在str1中不存在的元素
	public static List compareStr(String[] str1, String[] str2){
		List l = new ArrayList();
		for(int i=0;i<str2.length;i++){
			boolean flag = false;  //true:存在 false:不存在
			for(int j=0;j<str1.length;j++){
				if(str2[i].equals(str1[j])){
					flag = true;
					break;
				}
			}
			if(!flag)l.add(str2[i]);
		}
		return l;
	}
	
	public static void main(String args[]){
		ExcelToDB cc = new ExcelToDB();
		cc.isDebug = false;
		cc.sql = "insert into aaazhiye values(?,?,?,?,?)";
		cc.excelPath = "E:/work/feizhigao/test/1.xls";
		cc.startcol = 0;
		cc.startrow = 2;
		cc.endcol = 5;
		System.out.println("导入"+cc.FromExcelToOracle());
//		for(int i=2;i<=2;i++){
//			cc.excelPath = "E:/work/feizhigao/test/新建文件夹/"+i+".xls";
//			System.out.println(i+"导入"+cc.FromExcelToOracle());
//		}
		
//		ExcelToDB cc = new ExcelToDB();
//		cc.excelPath = "E:/work/feizhigao/test/agent.xls";
//		System.out.println(cc.formatExcel());
		
//		ExcelToDB cc = new ExcelToDB();
//		String str1 = "01200201,01200381,01201115,01201528,01201812,01202031,01202114,01202377,01202688,01203045,01203188,01203226,01203966,01204667,01204906,01206054,01206943,01206957,01208596,01209210,01211925,01212861,01212975,01213680,01214195,01214364,01215086,01215201,01215255,01215766,01216064,01216137,01217473,01217722,01218504,01218716,01219649,01221720,01225141,01225570,01226011,01226786,01226877,01227729,01228219,01228547,01228620,01229627,01229985,01230062,01232537,01233206,01233431,01233523,01233881,01235963,01236154,01236309,01236906,01237100,01237755,01238069,01238098,01238911,01238917,01242187,01243033,01243601,01244398,01246419,01246636,01246838,01247153,01247263,01250901,01250993,01251184,01251380,01251647,01252398,01252706,01252711,01253713,01253920,01254042,01254147,01254828,01255100,01256066,01256257,01256729,01256781,01270409,01279553,01287465,01288574,01288661,01289888,36007017,36009606,36014819,19201636,19201806,19203819,19204157,19204848,24253334,28200053,28202524,28202698,28204798,28204800,28205361,28206427,28215355,28216807,28216839,28219842,28220109,28220191,28220198,28228871,28228880,28231348,28232351,28232704,29200137,29202399,342A1533,22200954,22201485,22206415,22208106,22237359,22239727,22276242,22292889,22299862,21204638,21209039,21210688,21210931,21235803,21235939,21241075,21245699,21255248,21255380,21270301,23203092,23233277,26206153,26206703,26206922,26208877,26220090,262A1113,262U0291,20200124,20251829,03201013,03203015,03205585,03247205,032A6967,032A8944,032C0721,032D2676,032D4168,032D5618,032D8600,032G2453,36002670,36004495,36027761,27200225,27200349,27202916,27260976,06212818,06217158,06223056,06290900,15210276,15210317,15210714,152B2594,09202140,09202247,09202490,09202619,09202668,09202801,09202891,09203175,09203239,09203363,09203429,13240049,13240399,18201318,18201719,18202309,18206310,18207005,18208288,18209009,18217033,18217070,18218701,18218855,17200030,17200108,17200988,17201065,17204979,17209280,172F0937,172F1419,172F3159,172F3364,172F6772,172J3174,172J4069,172J4640,172J4656,172K2111,172N1256,172P2003,05202269,05221463,05230008,11200029,11202853,11206617,11240373,07201888,07205228,07210780,07212424,07224066,07224120,07228131,07228136,07228158,07228186,07228241,30260134,30260140,302a0640,302g1225,04200181,04200225,04200426,04200989,04201750,04201918,04201920,04202378,04202485,04202755,04203033,04203083,04203479,04203516,04203651,04203879,04204747,04204860,04204953,04205704,04206940,04207148,04207643,04208262,04208982,04209490,04210347,04210915,04211442,04212527,04214454,04214483,04214867,04214991,04215881,04218119,04219726,04221223,04221228,04221404,04221545,04222109,04222125,04222252,04222296,04222629,04222798,25200008,25200167,25201099,25202228,25202852,32230365,08214125,08216773,08220279,08220758,08221335,08228271,08235020,08241377,08242711,08252058,08260981,08261930,08261934,08262419,08270039,08270122,08270828,08277001,08280799,36118127,31200084,31200229,31200315,31201184,312A0625,312A1411,312A1931,312B0207,312B0262,312C0075,312C0529,312D0002,312D0061,312D0107,312D0131,312D0151,312D0264,312E0083,312E0127,312E0175,312E0316,312E0533,312E0704,312E0916,312E3210,312F0018,312F0474,36062615,36070794,36076070,36076320,36102238,36113954,36130275,36169187,36174857,36180027,36191395,36209023,36217227,36217257,36217280,36217299,36217324,36217479,36219563,36219568,36219815,36233019,36236763,36244066,36245918,36251098,36258121,36258656,36266980,36270156,36274950,36278193,36291747,36305388";
//		String str2 = "22206415,22208460,22207360,08242853,01256729,01256781,04218685,08262419,01255100,08251335,01256066,01256257,08260981,01203045,01203188,01203226,01203966,01204667,01204906,01206054,01206943,01206957,01208596,01209210,01200201,01200381,01201115,01270409,01201528,01201812,01202031,01202114,01202377,01202688,08214859,08220758,08221335,08241377,08235020,36102238,31200315,08235164,36270156,08220279,36219815,08216773,08242711,312A0625,01279553,01287465,01289888,01288574,01288661,01228219,01228547,01228620,01241953,01250901,01250993,01251184,36014819,36007017,01212861,01214195,01214364,01215766,01215783,01212975,01218504,01218716,01216064,01216137,01217473,01217722,36009606,01219649,01235963,01236154,01236309,36180027,08270828,01211925,312A1411,01252398,01252524,01213680,01253920,01226011,01215086,01215201,01215255,36251098,01236906,01237100,01237755,01232537,01233206,01242187,01251380,01246419,01246636,01253713,01251647,01226786,01238069,01238098,01238911,01238917,08277339,01229627,01229985,01230062,01233431,01233523,01233881,01243033,01243601,01246838,01247153,01254828,01226877,01221720,01247263,08270659,36278193,01244398,01252706,01252711,01254042,01254147,01227729,01222487,01225141,01225570,312B0262,08270039,36219563,36076070,312D0002,36266980,36217324,36219568,36217299,08286085,312D0107,312D0061,36274950,36217257,312D0151,36217479,36217227,36130275,312D0264,312E0127,312E0704,36191395,312E0175,36236763,312E0083,08217580,23203092,08228260,nclwys,08242026,08228271,08280799,08252058,08270122,08261934,08277001,08277316,08261930,36118127,36305388,36291747,17204979,172N1256,172J4069,172J4640,172F3364,23233277,17200030,17200108,172J3174,17209747,172F3159,17200988,17201065,172F0937,172F6772,172F1419,172J4656,17209280,172P2003,172K2111,21255248,36258121,21235803,21210931,09203175,21210688,09202891,18202309,21270301,18209009,18218701,18217070,21204638,21209039,21235939,11206617,312E0533,21255380,31201184,31200084,11200029,21241075,21245699,36169187,36174857,36245918,36209023,312C0529,36233019,31200229,36070794,312A1931,36113954,312D0131,36217280,312E3210,36062615,312E0916,312F0474,312D0311,312E0316,36258656,36076320,312B0207,36244066,312C0075,312F0018,25201099,25202852,25200167,24253334,22208106,05202269,05221463,27200225,27260976,05230008,25202228,25200008,09203239,09203479,08214125,09202619,09202668,09203429,09202140,09202490,09202801,09202247,09203363,05221000,22299862,04205704,04213921,04208262,04208982,04203033,04203083,04214454,04203479,04203516,04200237,04203651,29250001,04211442,29202399,29200137,19203819,19204848,19201806,15210714,19201636,15210317,19204157,16272469,13240399,13240049,18218855,18208288,302g1225,18201318,18201719,18207005,18206310,18217033,18206850,032A6967,36002670,032D2676,032D4168,032D5618,032I6200,152B2594,032G2453,04214483,04214991,36020195,032C0721,032D8600,36004495,032A8944,36027761,15210276,06212818,30260134,30260140,302a0640,302d1085,04211964,04221228,04210255,262A1113,26208877,26206922,26206703,28216807,28220109,28228871,28216839,28232704,28215355,26220090,22292889,22276242,04221545,04222296,04214867,28216803,28220191,28220198,28219842,28228880,28231312,28231348,28204798,28206427,04201918,04222252,342A1533,28200053,04221404,27200349,28201340,04209490,28202698,26206153,27202916,28202524,28232351,06223056,28205361,04222109,04222125,04200181,04200225,04200426,04222798,04221667,03205585,03203015,04221223,04222629,28204800,03201013,04206940,04207148,04210347,04204747,04204860,03247205,04210915,04215881,04204953,04207643,06290900,04212527,06217158,04218119,04201750,04201920,04202378,04202485,04202755,32230365,04203156,04200989,04203879,22200954,22233707,22237359,22201485,22239727,262U0291,20251829,11202853,11240373,20200124,04212576,04214163,04219726,04221920,07224066,07201888,07224120,07228131,07228136,07228186,07210780,07228158,07205228,07212424,07228241";
//		String[] tmp1 = str1.split(",");
//		String[] tmp2 = str2.split(",");
//		List l = cc.compareStr(tmp1, tmp2);
//		for(int i=0;i<l.size();i++){
//			System.out.println(i+"=="+(String)l.get(i));
//		}
		
	}
}