Question

怎么把EXCEL中的数据导入到数据库中？

怎么把EXCEL中的数据导入到数据库中？
最好能实现双向功能的
即可从数据库中导入到EXCEL表格中
也可把EXCEL表格中的数据导入到数据库中
用java语句怎么写？

Answer 1

public ActionForward importExcel(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception {
@SuppressWarnings("unused")
UserForm myform = (UserForm)form;
HttpSession session=request.getSession();
User userBean=(User)session.getAttribute("user");
if (userBean == null){
response.sendRedirect("index.html");
return null;
}
int companyId = userBean.getUserId();
String state = "1";
try {
InputStream is = myform.getFile().getInputStream();
jxl.Workbook rwb = Workbook.getWorkbook(is);
// Sheet(术语：工作表)就是Excel表格左下角的Sheet1,Sheet2,Sheet3但在程序中
// Sheet的下标是从0开始的
// 获取第一张Sheet表
Sheet rs = rwb.getSheet(0);
// 获取Sheet表中所包含的总列数
// int rsColumns = rs.getColumns();
// 获取Sheet表中所包含的总行数
int rsRows = rs.getRows();
// 获取指这下单元格的对象引用
userList = new ArrayList<TblUser>();
java.util.Date da= new java.util.Date();//取当前时间
for(int i=2;i<rsRows;i++){
//判断手机号是否重复
TblUser user = new TblUser();
user.setName(rs.getCell(0, i).getContents());
userList.add(user);

}
//效验用户在数据库中是否重复
boolean flag = userManagerService.checkImportUser(userList);
//添加到数据库
if(!flag){
userManagerService.importExcelDate(userList);
}else{
request.setAttribute("messages", "数据库中已经存在该条数据!");
return this.jumpImportPage(mapping, form, request, response);
}

rwb.close();

is.close();
System.gc();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
state = "2";
} catch (IndexOutOfBoundsException e) {
// TODO Auto-generated catch block
e.printStackTrace();
state = "2";
}
request.setAttribute("state", state);
return mapping.findForward("importExcel");
}