上传Excel的Demojava代码

使用jdbc封装类，进行excel文件的上传和下载

package com.tgb.entity;

/**
 * 学生实体，导入的对象
 * 
 * @author liuyanling
 *
 */
public class Student {

	// 主键
	private String id;
	// 学号
	private String stuNo;
	// 姓名
	private String stuName;
	// 性别
	private String stuSex;
	// 院系
	private String department;
	// 专业
	private String major;

	// 构造函数和重写toString方法
	public Student（） {
	}

	public Student（String id String stuNo String stuName String stuSex
			String department String major） {
		this.id = id;
		this.stuNo = stuNo;
		this.stuName = stuName;
		this.stuSex = stuSex;
		this.department = department;
		this.major = major;
	}

	@Override
	public String toString（） {
		return “Student:[id = “ + id + “ stuNo = “ + stuNo + “ stuName = “
				+ stuName + “ stuSex = “ + stuSex + “ department = “ + department
				+ “ major = “ + major + “]“;
	}

	/*** getter和setter方法 **************/
	public String getId（） {
		return id;
	}

	public void setId（String id） {
		this.id = id;
	}

	public String getStuNo（） {
		return stuNo;
	}

	public void setStuNo（String stuNo） {
		this.stuNo = stuNo;
	}

	public String getStuName（） {
		return stuName;
	}

	public void setStuName（String stuName） {
		this.stuName = stuName;
	}

	public String getStuSex（） {
		return stuSex;
	}

	public void setStuSex（String stuSex） {
		this.stuSex = stuSex;
	}

	public String getDepartment（） {
		return department;
	}

	public void setDepartment（String department） {
		this.department = department;
	}

	public String getMajor（） {
		return major;
	}

	public void setMajor（String major） {
		this.major = major;
	}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2015-08-18 11:22  ImportExcelDemo\
     文件         431  2015-08-18 11:22  ImportExcelDemo\.classpath
     文件         391  2015-08-17 21:58  ImportExcelDemo\.project
     目录           0  2015-08-17 21:58  ImportExcelDemo\.settings\
     文件         598  2015-08-17 21:58  ImportExcelDemo\.settings\org.eclipse.jdt.core.prefs
     目录           0  2015-08-18 15:07  ImportExcelDemo\bin\
     目录           0  2015-08-18 09:13  ImportExcelDemo\bin\com\
     目录           0  2015-08-18 15:07  ImportExcelDemo\bin\com\tgb\
     目录           0  2015-08-18 09:13  ImportExcelDemo\bin\com\tgb\entity\
     文件        2164  2015-08-18 10:32  ImportExcelDemo\bin\com\tgb\entity\Student.class
     目录           0  2015-08-18 10:38  ImportExcelDemo\bin\com\tgb\excel\
     文件        3029  2015-08-18 11:16  ImportExcelDemo\bin\com\tgb\excel\ExportExcel.class
     文件        1895  2015-08-18 10:32  ImportExcelDemo\bin\com\tgb\excel\ImportExcel.class
     目录           0  2015-08-18 09:13  ImportExcelDemo\bin\com\tgb\service\
     文件        3680  2015-08-18 11:19  ImportExcelDemo\bin\com\tgb\service\StudentService.class
     目录           0  2015-08-18 09:13  ImportExcelDemo\bin\com\tgb\util\
     文件        2437  2015-08-18 10:39  ImportExcelDemo\bin\com\tgb\util\DBHelper.class
     目录           0  2015-08-17 22:23  ImportExcelDemo\lib\
     文件      725735  2014-05-21 16:49  ImportExcelDemo\lib\jxl.jar
     文件      709922  2014-02-19 11:55  ImportExcelDemo\lib\mysql-connector-java-5[1].1.7-bin.jar
     目录           0  2015-08-18 15:07  ImportExcelDemo\src\
     目录           0  2015-08-17 21:59  ImportExcelDemo\src\com\
     目录           0  2015-08-21 11:51  ImportExcelDemo\src\com\tgb\
     目录           0  2015-08-17 22:16  ImportExcelDemo\src\com\tgb\entity\
     文件        1710  2015-08-18 10:32  ImportExcelDemo\src\com\tgb\entity\Student.java
     目录           0  2015-08-18 10:38  ImportExcelDemo\src\com\tgb\excel\
     文件        2832  2015-08-18 11:16  ImportExcelDemo\src\com\tgb\excel\ExportExcel.java
     文件        1566  2015-08-18 10:32  ImportExcelDemo\src\com\tgb\excel\ImportExcel.java
     目录           0  2015-08-18 09:04  ImportExcelDemo\src\com\tgb\service\
     文件        3843  2015-08-18 11:19  ImportExcelDemo\src\com\tgb\service\StudentService.java
     目录           0  2015-08-17 22:23  ImportExcelDemo\src\com\tgb\util\
............此处省略2个文件信息