e代劍客——溫柔一刀

生活就像海洋，只有意志堅強的人，才能到達彼岸

:: 首頁 :: 新隨筆 :: 聯系 :: 聚合

:: 管理 ::

76 隨筆 :: 7 文章 :: 215 評論 :: 0 Trackbacks

隨筆分類(78)

隨筆檔案(76)

搜索

閱讀排行榜

評論排行榜

將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 溫柔一刀閱讀(936) 評論(1) 編輯收藏所屬分類: java相關


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB 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源碼

友情連接

開發文檔

搜索

最新評論

閱讀排行榜

評論排行榜

評論