亚洲一区免费观看,亚洲av成人一区二区三区在线观看 ,亚洲精品视频在线观看你懂的

眼睛能裝下世界，為何卻裝不下眼淚? 一只風(fēng)箏一輩子只為一根線冒險(xiǎn)。那不是一場(chǎng)游戲，為何總有一根線牽著心懷，隱隱作疼？那不是一段邂逅，為何飄在橋上的影子，總纏進(jìn)夢(mèng)鄉(xiāng)？那不是一個(gè)夢(mèng)境，為何你的溫柔私語(yǔ)，總是不經(jīng)意的響起？

將Excel文件內(nèi)容寫入到數(shù)據(jù)庫(kù)

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:\\學(xué)生信息臨時(shí)文件.xls " ); // 產(chǎn)生文件名和空文件

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

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

Sheet sheet = book.getSheet( 0 ); // 獲得第一個(gè)工作表對(duì)象

int row = sheet.getRows(); // /得到該sheet的行數(shù)

int column = sheet.getColumns(); // 得到該sheet的列數(shù)

System.out.println( " 數(shù)據(jù)行數(shù)= " + row);

System.out.println( " 數(shù)據(jù)列數(shù)= " + 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 2011-11-16 14:12 Steven_bot 閱讀(351) 評(píng)論(0) 編輯收藏所屬分類: tools

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: 將Excel文件內(nèi)容寫入到數(shù)據(jù)庫(kù) mysql備份

StevenBot-Saltsam

導(dǎo)航

統(tǒng)計(jì)

常用鏈接

留言簿

隨筆分類

隨筆檔案

文章分類

文章檔案

datas link

OSChinal Sources codes Library

搜索

最新評(píng)論

閱讀排行榜

評(píng)論排行榜

將Excel文件內(nèi)容寫入到數(shù)據(jù)庫(kù)