setjlistdate.java

是mysql数据库数据导入程序是从excel中提取数据导入到mysql数据库中

package excel.read;

import java.io.FileInputStream;
import java.io.InputStream;

import com.main.IndexPane;

import jxl.Workbook;

public class SetJListDate {

	/**
	 * 当选定excel后为JList赋值方法
	 * @param path
	 */
	public void fuzhi(String path)
	{
		try {
			InputStream is = new FileInputStream(path);//写入到FileInputStream
			Workbook wb = Workbook.getWorkbook(is); //得到工作薄
			String[] name = wb.getSheetNames();//读取工作表的名称
			IndexPane.jl.setListData(name);//为JList赋值
		}
		catch(Exception e) {
			//e.printStackTrace();
			System.out.println(e+"11111111");
		}
	}
}