package?com.dafang;

import?java.io.BufferedInputStream;
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileNotFoundException;
import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.text.DecimalFormat;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Arrays;
import?java.util.Date;
import?java.util.List;
import?java.util.TimeZone;

import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFDateUtil;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.poifs.filesystem.POIFSFileSystem;

public?class?ExcelOperate?{

	public?static?void?main（String[]?args）?throws?Exception?{
		//-----設置開始時間以及時間格式----
		SimpleDateFormat?sdf?=?new?SimpleDateFormat（“HH:mm:ss:SS“）;?
		TimeZone?t?=?sdf.getTimeZone（）;?
		t.setRawOffset（0）;?
		sdf.setTimeZone（t）;?
		Long?startTime?=?System.currentTimeMillis（）;?

		//------連接數據庫-------
		Connection?conn?=?null;
		PreparedStatement?pst?=?null;
		try?{
			//反射機制，創建數據庫Driver
			Class.forName（“com.mysql.jdbc.Driver“）;
			System.out.println（“數據庫連接成功“）;
			conn?=?java.sql.DriverManager.getConnection（??
	????????????????“jdbc:MySQL://192.168.1.3:3306/test“?“root“?“root“）;?//數據庫database--testusername--root，password--root?
			conn.setAutoCommit（false）;?
			//Dictionary_Geology?--?表名稱?
			//數據庫第一個字段id--自增長，不用處理
			//chinese?--?數據庫第二個字段?
			//english?--?數據庫第三個字段?
			//content?--?數據庫第四個字段?
			pst?=?（PreparedStatement）?conn.prepareStatement（“insert?into?Dictionary_Geology（chinese?english?content）?values?（???）“?）;
			
			
			File?file?=?new?File（“excel/new2.xls“）;
			String[][]?result?=?getData（file?1）;
			int?rowLength?=?result.length;
			System.out.println（result.length）;
			for?（int?i?=?0;?i?						//根據數據庫表字段的不同可以做修改
						pst.setString（1?result[i][1]）;//chinese
						pst.setString（2?result[i][2]）;//english
						pst.setString（3?result[i][3]）;//content
						pst.addBatch（）;?//事務整體添加
			}
			//事務整體提交
			pst.executeBatch（）;?
			conn.commit（）;?
			System.out.println（“數據庫寫入成功“）;?
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
			System.out.println（“數據庫連接失敗“）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}??finally{
			//關閉PreparedStatement
			if（pst?!=?null）?{
				pst.close（）;
				pst?=?null;
			}
			//關閉Connection
			if（conn?!=?null）?{
				conn.close（）;
				pst?=?null;
			}
		}
		
		//-----結束時間------
		Long?endTime?=?System.currentTimeMillis（）;?
		System.out.println（“用時：“?+?sdf.format（new?Date（endTime?-?startTime）））;?	
	}

	/**
	?*?讀取Excel的內容，第一維數組存儲的是一行中格列的值，二維數組存儲的是多少個行
	?*?
	?*?@param?file
	?*????????????讀取數據的源Excel
	?*?@param?ignoreRows
	?*????????????讀取數據忽略的行數，

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\
?????文件?????????611??2011-11-19?09:52??Java_Excel_Writer_Mysql\.classpath
?????文件?????????395??2011-11-19?11:21??Java_Excel_Writer_Mysql\.project
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\.settings\
?????文件?????????629??2011-11-19?09:18??Java_Excel_Writer_Mysql\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\bin\
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\bin\com\
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\bin\com\dafang\
?????文件????????7078??2011-11-19?11:38??Java_Excel_Writer_Mysql\bin\com\dafang\ExcelOperate.class
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\excel\
?????文件???????11776??2011-11-19?11:36??Java_Excel_Writer_Mysql\excel\new2.xls
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\lib\
?????文件??????767492??2011-11-19?09:51??Java_Excel_Writer_Mysql\lib\mysql-connector-java-5.1.13-bin.jar
?????文件?????1083802??2011-11-19?09:18??Java_Excel_Writer_Mysql\lib\poi-3.0.1-FINAL-20070705.jar
?????文件???????59349??2011-11-19?09:18??Java_Excel_Writer_Mysql\lib\poi-contrib-3.0.1-FINAL-20070705.jar
?????文件??????859615??2011-11-19?09:18??Java_Excel_Writer_Mysql\lib\poi-scratchpad-3.0.1-FINAL-20070705.jar
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\sql\
?????文件?????????276??2011-11-19?11:39??Java_Excel_Writer_Mysql\sql\test.sql
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\src\
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\src\com\
?????目錄???????????0??2011-11-19?11:39??Java_Excel_Writer_Mysql\src\com\dafang\
?????文件????????6528??2011-11-19?11:38??Java_Excel_Writer_Mysql\src\com\dafang\ExcelOperate.java