JAVA从桌面把Excl表格数据导入数据库

package app.controllers.user;
/**
 * 	设备导入Dtt
 * @author zdw
 *
 */
/**
 * @author zdw
 *
 */
public class DeviceDtt {

	// 补充EXCEL数据
	/**
	 * 	科室名称
	 */
	private String department_name;

	/**
	 *	 供应商名称	
	 */
	private String supplier_name;

	/**
	 * 	维保人员
	 */
	private String s_repair_name;



	/**
	 * 	维保电话
	 */
	private String s_repair_phone;

	/**
	 * 	维保单位
	 */
	private String s_repair_unit;

	/**
	 * 	设备编号
	 */
	private String device_number;

	/**
	 * 	维保期限
	 */
	private String device_period;

	/**
	 * 	设备品牌
	 */
	private String device_brand;

	/**
	 * 	设备型号
	 */
	private String device_model;

	/**
	 * 	设备名称
	 */
	private String device_name;

	/**
	 * 	质控设备(多条以英文逗号隔开)
	 */
	private String device_check_device;

	/**
	 * 	环境条件(非必填)
	 */
	private String device_environment;

	/**
	 * 	出厂日期(格式:yyyy-MM-dd)
	 */
	private String device_create_time;

	/**
	 * 	验收日期(格式:yyyy-MM-dd)
	 */
	private String device_check_time;

	/**
	 * 	出保日期(格式:yyyy-MM-dd)
	 */
	private String device_Guarantee_time;
	
	public String getDepartment_name() {
		return department_name;
	}

	public void setDepartment_name(String department_name) {
		this.department_name = department_name;
	}

	public String getSupplier_name() {
		return supplier_name;
	}

	public void setSupplier_name(String supplier_name) {
		this.supplier_name = supplier_name;
	}

	public String getS_repair_name() {
		return s_repair_name;
	}

	public void setS_repair_name(String s_repair_name) {
		this.s_repair_name = s_repair_name;
	}

	public String getS_repair_phone() {
		return s_repair_phone;
	}

	public void setS_repair_phone(String s_repair_phone) {
		this.s_repair_phone = s_repair_phone;
	}

	public String getS_repair_unit() {
		return s_repair_unit;
	}

	public void setS_repair_unit(String s_repair_unit) {
		this.s_repair_unit = s_repair_unit;
	}

	public String getDevice_number() {
		return device_number;
	}

	public void setDevice_number(String device_number) {
		this.device_number = device_number;
	}

	public String getDevice_period() {
		return device_period;
	}

	public void setDevice_period(String device_period) {
		this.device_period = device_period;
	}

	public String getDevice_brand() {
		return device_brand;
	}

	public void setDevice_brand(String device_brand) {
		this.device_brand = device_brand;
	}

	public String getDevice_model() {
		return device_model;
	}

	public void setDevice_model(String device_model) {
		this.device_model = device_model;
	}

	public String getDevice_name() {
		return device_name;
	}

	public void setDevice_name(String device_name) {
		this.device_name = device_name;
	}

	public String getDevice_check_device() {
		return device_check_device;
	}

	public void setDevice_check_device(String device_check_device) {
		this.device_check_device = device_check_device;
	}

	public String getDevice_environment() {
		return device_environment;
	}

	public void setDevice_environment(String device_environment) {
		this.device_environment = device_environment;
	}

	public String getDevice_create_time() {
		return device_create_time;
	}

	public void setDevice_create_time(String device_create_time) {
		this.device_create_time = device_create_time;
	}

	public String getDevice_check_time() {
		return device_check_time;
	}

	public void setDevice_check_time(String device_check_time) {
		this.device_check_time = device_check_time;
	}

	public String getDevice_Guarantee_time() {
		return device_Guarantee_time;
	}

	public void setDevice_Guarantee_time(String device_Guarantee_time) {
		this.device_Guarantee_time = device_Guarantee_time;
	}

	@Override
	public String toString() {
		return "DeviceDtt [department_name=" + department_name + ", supplier_name=" + supplier_name + ", s_repair_name="
				+ s_repair_name + ", s_repair_phone=" + s_repair_phone + ", s_repair_unit=" + s_repair_unit
				+ ", device_number=" + device_number + ", device_period=" + device_period + ", device_brand="
				+ device_brand + ", device_model=" + device_model + ", device_name=" + device_name
				+ ", device_check_device=" + device_check_device + ", device_environment=" + device_environment
				+ ", device_create_time=" + device_create_time + ", device_check_time=" + device_check_time
				+ ", device_Guarantee_time=" + device_Guarantee_time + "]";
	}
}

按照Excl表格数据格式，写一个容器类

我的表格是这样的

 

接下来写主方法

先说一下流程，识别文件——》取文件——》拿到每一行——》拿到每一格的值——》存入数据库

package app.controllers.device;

import java.io.File;
import java.util.ArrayList;
import java.util.List;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class ExcelUtil {

	public static void main(String args[]) {
		File f = new File("C:\\Users\\Administrator\\Desktop\\123.xls");
//		File f = getFile().getFile();
		try {
			Workbook book = Workbook.getWorkbook(f);//获得文件
			Sheet sheet = book.getSheet(0); // 获得第一个工作表对象
			List<DeviceDtt> result = new ArrayList<DeviceDtt>();
// 遍历每一行
			for (int i = 0; i < sheet.getRows(); i++) {
				DeviceDtt device = new DeviceDto();
// 遍历每一格
				for (int j = 0; j < sheet.getColumns(); j++) {
					Cell cell = sheet.getCell(j, i); // 获得单元格

					if (j == 0) {
						// 科室名称
						device.setDepartment_name(cell.getContents());
					} else if (j == 1) {
						// 供应商名称
						device.setSupplier_name(cell.getContents());
					} else if (j == 2) {
						// 维保人员
						device.setMaintenance_name(cell.getContents());
					} else if (j == 3) {
						// 维保电话
						device.setMaintenance_mobile(cell.getContents());
					} else if (j == 4) {
						// 维保单位
						device.setMaintenance_company(cell.getContents());
					} else if (j == 5) {
						// 设备编号
						device.setDevice_number(cell.getContents());
					} else if (j == 6) {
						// 维保期限
						device.setMaintenance_time(cell.getContents());
					} else if (j == 7) {
						// 设备品牌
						device.setDevice_brand(cell.getContents());
					} else if (j == 8) {
						// 设备型号
						device.setDevice_model(cell.getContents());
					} else if (j == 9) {
						// 设备名称
						device.setDevice_name(cell.getContents());
					} else if (j == 10) {
						// 质控设备(多条以英文逗号隔开)
						device.setDevice_cont(cell.getContents());
					} else if (j == 11) {
						// 环境条件(非必填)
						device.setEnvironment(cell.getContents());
					} else if (j == 12) {
						// 出厂日期(格式:yyyy-MM-dd)
						device.setProduction_time(cell.getContents());
					} else if (j == 13) {
						// 验收日期(格式:yyyy-MM-dd)
						device.setCheck_time(cell.getContents());
					} else if (j == 14) {
						// 出保日期(格式:yyyy-MM-dd)
						device.setGuarantee_time(cell.getContents());
					}
				}
				result.add(device);
			}

			for (DeviceDtt deviceDtt : result) {
				System.out.println(deviceDtt);
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

输出打印就已经把EXCL表格的数据打印出来了，在后续forench通过get取出值，存入数据库就行

device.set("asset_number", deviceDtt.getDevice_number());
				device.set("shop_id", shop_id);
				device.set("device_brand", deviceDtt.getDevice_brand());
				device.set("device_model", deviceDtt.getDevice_model());
				device.set("device_name", deviceDtt.getDevice_name());
				device.set("environment", deviceDtt.getDevice_environment());
				device.set("period", deviceDtt.getDevice_period());
				device.set("check_device", deviceDtt.getDevice_check_device());
				device.set("check_time", deviceDtt.getDevice_check_time());
				device.set("create_time", deviceDtt.getDevice_create_time());
				device.set("Guarantee_time", deviceDtt.getDevice_Guarantee_time());
				device.set("status", "启用");
				device.set("update_time", curTime());

				device.save();

希望对你有帮助。