将Excel文件内容写入到数据库

package com.zhupan.spring;

import java.io.File;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import jxl.Sheet;

import jxl.Workbook;

import org.springframework.validation.BindException;

import org.springframework.web.multipart.MultipartFile;

import org.springframework.web.multipart.MultipartHttpServletRequest;

import org.springframework.web.servlet.ModelAndView;

import org.springframework.web.servlet.mvc.SimpleFormController;

import com.ctgusec.model.Student_info;

import com.ctgusec.service.IStudent_infoManage;

/**

* @author zhupan

public class EStudentInsertExcelController extends SimpleFormController {

private IStudent_infoManage studentManage;

@Override

protected ModelAndView onSubmit(HttpServletRequest request,

HttpServletResponse response, Object command, BindException errors)

throws Exception {

Student_info student_info = (Student_info) command;

try {

MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;

MultipartFile file = multipartRequest.getFile( " Excelfile " ); // 获得文件：

File toFile = new File( " c:\\学生信息临时文件.xls " ); // 产生文件名和空文件

file.transferTo(toFile); // 文件上传

Workbook book = Workbook.getWorkbook(toFile); // 得到工作薄

Sheet sheet = book.getSheet( 0 ); // 获得第一个工作表对象

int row = sheet.getRows(); // /得到该sheet的行数

int column = sheet.getColumns(); // 得到该sheet的列数

System.out.println( " 数据行数= " + row);

System.out.println( " 数据列数= " + column);

for ( int i = 1 ;i < row;i ++ )

{

for ( int j = 0 ;j < column;j ++ )

{

System.out.println( " j= " + j);

sheet.getCell(j, i).getContents(); // 得到第j列第i行的单元格的类容

student_info.setStudentID(sheet.getCell(j, i).getContents());

student_info.setName(sheet.getCell( ++ j,i).getContents());

student_info.setSex(sheet.getCell( ++ j,i).getContents());

student_info.setUnit(sheet.getCell( ++ j,i).getContents());

student_info.setClass_(sheet.getCell( ++ j,i).getContents());

student_info.setSpecialty(sheet.getCell( ++ j,i).getContents());

student_info.setRemark(sheet.getCell( ++ j,i).getContents());

}

if ( this .studentManage.getStudentByStudentID(

student_info.getStudentID()).size() != 0 )

return new ModelAndView( " education/e-studentInfoAddError " );

this .studentManage.insertStudent_info(student_info);

}

book.close();

return new ModelAndView( " education/e-studentInfoAddExcelSuccess " , " row " , new Integer(row - 1 ));

} catch (Exception e) {

e.printStackTrace();

}

return new ModelAndView( " education/e-studentInfoAddExcelError " );

}

public void setStudentManage(IStudent_infoManage studentManage) {

this .studentManage = studentManage;

}

posted on 2006-10-07 15:05 温柔一刀阅读(914) 评论(1) 编辑收藏所属分类: java相关

# re: 将Excel文件内容写入到数据库 2006-10-27 18:20 junitfans

这个更直接啊回复更多评论

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻知识库 C++博客博问管理
相关文章: 德比软件(DerbySoft)诚聘java工程师（上海） jpivot中输出pdf打印汉字、excel导出中文方法 Ant+Tomcat自动部署的小问题 FCKeditor-2.3在线编辑器，可以直接用的（java版） Eclipse快捷键指南 Java应用iText动态生成PDF文件将Excel文件内容写入到数据库 JXL操作Excel 件上传组件commons-fileupload用户指南随机生成验证码

e代剑客——温柔一刀

随笔分类(78)

随笔档案(76)

java源码

友情连接

开发文档

搜索

最新评论

阅读排行榜

评论排行榜

评论