package org.jsoft.person.test;
import java.io.File;
import java.io.FileNotFoundException;
import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import org.hibernate.Session;
import org.hibernate.Query;
import org.jsoft.comm.dao.impl.BaseDAO;
import org.jsoft.comm.util.HibernateSessionFactory;
import org.jsoft.comm.vo.*;
import jxl.Sheet;
import jxl.WorkbookSettings;
import jxl.Workbook;
public class ExcelReader {
/**
* ExcelJXL类 为对Excel相关的读取操作类 包括方法
*
* 1. readExcel 方法 为读取excel文件的方法 返回List<List<String>>类型的VOsFromExcel
* 2.saveExcelToDB 方法 为把读取的excel存到数据库的方法
*
*
* 3.BeginLoadExcel 方法 为用户从外部调用的方法 使用的时候用户只用使用这个方法就行
*
* @author 李智 Lychee
*/
public List<List<String>> readExcel(String ExcelPath) {
/**
* readExcel 方法 为读取excel文件的方法 并显示到控制台 参数： 1. ExcelPath
* 为待读取的Excel文件的路径，例如 "D:/testXLS.xls"
*
* 方法返回List<List<String>>类型的VOsFromExcel
* excel中每一行被封装为一个List，所有的List被封装为最后的VOsFromExcel返回
*
* @author 李智 Lychee
*/
System.out.println("Excel读取开始");
List<List<String>> VOsFromExcel = new ArrayList<List<String>>(); // 用于返回的list
try {
WorkbookSettings workbookSettings = new WorkbookSettings();
workbookSettings.setEncoding("GBK"); // 解决乱码问题所采用的编码 utf-8无法解决
// 暂时采用GBK
Workbook book = Workbook.getWorkbook(new File(ExcelPath),
workbookSettings);
Sheet sheet = book.getSheet(0); // 0代表第一个工作表对象
int excelRows = sheet.getRows(); // excel总行数
int excelCols = sheet.getColumns(); // excel总列数
System.out.println("文件总行数：" + excelRows + " 总列数：" + excelCols);
for (int i = 1; i < excelRows; i++) { // 从第二行开始，检索每一行
List<String> VOSingle = new ArrayList<String>(); // 用于返回的单个List
// 一个VOSingle为Excel的一行
// 从表的第一个字段开始
// 取出每个单元格的信息
for (int j = 0; j < excelCols; j++) {
String perUnit = sheet.getCell(j, i).getContents().trim(); // 取出每一行的信息
VOSingle.add(perUnit);
}
VOsFromExcel.add(VOSingle); // 将每一行的VOSingle放到最终返回的list中
}
} catch (FileNotFoundException e) {
// e.printStackTrace();
System.out.println("没有找到文件！请检察路径和文件名是否正确");
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("Excel读取完成");
return VOsFromExcel;
}
public void saveExcelToDB(List<List<String>> VOsFromExcel, String tableName) {
/**
* SaveExcelToDB 方法 为将查询好的list存入数据库中的方法 其中参数： VOsFromExcel
* 为待存储的excel中提取的数据 tableName 为待插入的表名称
*
* 这种方法写起来略麻烦，可能不是最终的解决方案
*/
System.out.println("Excel存储开始");
for (List<String> vos : VOsFromExcel) {
if ("bak".equals(tableName)) {
BaseDAO<Bak> bDAO = new BaseDAO<Bak>();
Bak b = new Bak();
Operater o = new Operater();
o.setOpId(vos.get(1));
b.setOperater(o);
b.setBakRemark(vos.get(2));
try {
Timestamp ts = new Timestamp(new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss").parse(vos.get(3)).getTime());
// ↑ 将String转换成TimeStamp的方法
b.setBakDate(ts);
} catch (ParseException e) {
e.printStackTrace();
}
b.setPath(vos.get(4));
b.setIsDelete(Integer.parseInt(vos.get(5)));
bDAO.save(b);
} else if ("department".equals(tableName)) {
BaseDAO<Department> bDAO = new BaseDAO<Department>();
Department d = new Department();
d.setDepartmentName(vos.get(1));
d.setIsDelete(Integer.parseInt(vos.get(2)));
bDAO.save(d);
} else if ("dept_job_rel".equals(tableName)) {
BaseDAO<DeptJobRel> bDAO = new BaseDAO<DeptJobRel>();
DeptJobRel d = new DeptJobRel();
Salary s = new Salary();
s.setSalaryId(vos.get(1));
d.setSalary(s);
Department dept = new Department();
dept.setDepartmentId(vos.get(2));
d.setDepartment(dept);
Job j = new Job();
j.setJobId(vos.get(3));
d.setJob(j);
d.setIsDelete(Integer.parseInt(vos.get(4)));
bDAO.save(d);
} else if ("diction_log".equals(tableName)) {
BaseDAO<DictionLog> bDAO = new BaseDAO<DictionLog>();
DictionLog d = new DictionLog();
d.setPid(vos.get(1));
d.setName(vos.get(2));
try {
Timestamp ts = new Timestamp(new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss").parse(vos.get(3)).getTime());
// ↑ 将String转换成TimeStamp的方法
d.setDictionLogDate(ts);
} catch (ParseException e) {
e.printStackTrace();
}
d.setDictionLogRemark(vos.get(4));
d.setIsDelete(Integer.parseInt(vos.get(5)));
bDAO.save(d);
} else if ("duty".equals(tableName)) {
BaseDAO<Duty> bDAO = new BaseDAO<Duty>();
Duty d = new Duty();
d.setDutyName(vos.get(1));
d.setIsDelete(Integer.parseInt(vos.get(2)));
bDAO.save(d);
} else if ("encorchast".equals(tableName)) {
BaseDAO<Encorchast> bDAO = new BaseDAO<Encorchast>();
Encorchast e = new Encorchast();
e.setPersonnelEncOrChastPoint(Double.parseDouble(vos.get(1)));
e.setMoney(Double.parseDouble(vos.get(2)));
e.setPersonnelEncOrChastSort(vos.get(3));
e.setIsDelete(Integer.parseInt(vos.get(4)));
bDAO.save(e);
} else if ("job".equals(tableName)) {
BaseDAO<Job> bDAO = new BaseDAO<Job>();
Job j = new Job();
j.setJobName(vos.get(1));
j.setIsDelete(Integer.parseInt(vos.get(2)));
bDAO.save(j);
} else if ("menu".equals(tableName)) {
BaseDAO<Menu> bDAO = new BaseDAO<Menu>();
Menu m = new Menu();
Menu mm = new Menu();
mm.setMenuId(vos.get(1));
m.setMenu(mm);
m.setMenuName(vos.get(2));
m.setMenuUrl(vos.get(3));
m.setRemark(vos.get(4));
m.setMenuDate(vos.get(5));
m.setIsDelete(Integer.parseInt(vos.get(6)));
bDAO.save(m);
} else if ("operate_log".equals(tableName)) {
BaseDAO<OperateLog> bDAO = new BaseDAO<OperateLog>();
OperateLog o = new OperateLog();
Operater operater = new Operater();
operater.setOpId(vos.get(1));
o.setOperater(operater);
try {
Timestamp ts = new Timestamp(new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss").parse(vos.get(2)).getTime());
// ↑ 将String转换成TimeStamp的方法
o.setBakDate(ts);
} catch (ParseException e) {
e.printStackTrace();
}
o.setEvent(vos.get(3));
o.setIsDelete(Integer.parseInt(vos.get(4)));
bDAO.save(o);
} else if ("operater".equals(tableName)) {
BaseDAO<Operater> bDAO = new BaseDAO<Operater>();
Operater o = new Operater();
Personnelinfo p = new Personnelinfo();
p.setPersonnelId(vos.get(1));
o.setPersonnelinfo(p);
o.setPopedom(vos.get(2));
o.setOpName(vos.get(3));
o.setOpPassword(vos.get(4));
o.setIsDelete(Integer.parseInt(vos.get(5)));
bDAO.save(o);
} else if ("peoc".equals(tableName)) {
BaseDAO<Peoc> bDAO = new BaseDAO<Peoc>();
Peoc p = new Peoc();
Encorchast e = new Encorchast();
e.setEncOrChastId(vos.get(1));
p.setEncorchast(e);
Personnelinfo pp = new Personnelinfo();
pp.setPersonnelId(v
企业人事管理系统(java 毕业设计 J2EE 源码) （867个子文件） 
DHTML 手册.chm 3.83MB jquery1.7_20111204.chm 297KB ExcelReader.class 15KB ExcelReader.class 15KB PersonInfoService.class 15KB Personnelinfo.class 13KB BakService.class 10KB PersonAppraiseService.class 9KB BaseDAO.class 9KB BakServlet.class 8KB PersonInfoServlet.class 8KB SearchPayRollService.class 8KB DictionServlet.class 7KB SalaryManageOP.class 7KB UserServlet.class 7KB PersonnelRecordsServlet.class 6KB PersonnelRecordsDAO.class 6KB SalaryServlet.class 6KB PersonAppraiseServlet.class 6KB DepartmentPBService.class 6KB PersonTrainService.class 6KB PersonnelRecordsService.class 6KB PersonTrainServlet.class 6KB OperateLogDAO.class 6KB PageServlet.class 6KB MntAllServlet.class 6KB OperaterManageServelet.class 6KB Dept_job_relServlet.class 6KB OperaterService.class 5KB PersonEOCService.class 5KB ExportExcel.class 5KB MenuServlet.class 5KB PersonnelManagementDAO.class 5KB PersonnelRecordsDAOTest.class 5KB PersonnelRemoveService.class 5KB BakDAO.class 5KB DictionDAO.class 5KB DeptServlet.class 5KB Dept_job_relService.class 5KB PersonnelManagementServlet.class 5KB EncorchastServlet.class 5KB MultipartWrapper.class 5KB PersonnelRemoveServlet.class 5KB SetofBookServlet.class 4KB PersonInfoDAO.class 4KB PersonEOCServlet.class 4KB OperateLogServlet.class 4KB SalaryDAO.class 4KB PersonAdjustSalaryServlet.class 4KB PersonAppraiseDAO.class 4KB PersonTrainDAO.class 4KB UserDAO.class 4KB BaseServlet.class 4KB DepartmentPBServlet.class 4KB MntScoreService.class 4KB PersonAdjustSalaryService.class 4KB MntScoreServlet.class 4KB Dept_job_relDAO.class 3KB OperaterDAO.class 3KB DepartmentDAO.class 3KB MenuDAO.class 3KB EncorchastService.class 3KB DeptDAO.class 3KB SearchPayRollServlet.class 3KB Personnelremove.class 3KB PersonInfoDictionDAO.class 3KB OperateLogService.class 3KB PersonnelManagementService.class 3KB DictionService.class 3KB DeptSevice.class 3KB DutyServlet.class 3KB DutyService.class 3KB MntAllService.class 3KB Salary.class 3KB EncorchastDAO.class 3KB PageDAO.class 3KB Operater.class 3KB DeptJobRel.class 3KB DutyDAO.class 3KB Personneladjustsalary.class 3KB Personnelappraise.class 3KB MysqlBakByJava.class 3KB PersonAdjustSalaryDAO.class 3KB LogServlet.class 3KB Menu.class 3KB Peoc.class 3KB HibernateSessionFactory.class 3KB UserService.class 3KB JobDAO.class 2KB Personneltrain.class 2KB Encorchast.class 2KB PersonEOCDAO.class 2KB InitDataBaseServlet.class 2KB Bak.class 2KB OperateServlet.class 2KB SystemFilter.class 2KB SetofBookService.class 2KB DpwdServlet.class 2KB IPersonInfoService.class 2KB PayRollResult.class 2KB共 867 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
- 1
- 2
前往页