Excel导入导出MYSQL，0分下载

package net.company.dao; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import net.company.connect.ConnCOnnection; import net.company.dto.Student; import jxl.Workbook; import jxl.read.biff.BiffException; public class Date { public void getDate() { List liststu=new ArrayList(); // 找到导入的文件 InputStream is= Date.class.getClassLoader().getResourceAsStream("student.xls"); try { //创建工作簿 Workbook wb=Workbook.getWorkbook(is); //创建工作表 jxl.Sheet sheet=wb.getSheet(0); String content=null; for(int i=1;i<sheet.getRows();i++) { Student stu=new Student(); for(int j=0;j<sheet.getColumns();j++) { content=sheet.getCell(j, i).getContents(); //j代表列 从0开始 //i代表行 从1开始 System.out.println(j+"----"+i); System.out.print(content); if(stu.getId()==0) { stu.setId(Integer.parseInt(sheet.getCell(j, i).getContents())); continue; } if(stu.getName()==null) { stu.setName(sheet.getCell(j, i).getContents()); continue; } if(stu.getAge()==0) { stu.setAge(Integer.parseInt(sheet.getCell(j, i).getContents())); continue; } } getStudentInfo(stu); } } catch (BiffException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void getStudentInfo(Student stu) { String sql="insert into stu values("+stu.getId()+",'"+stu.getName()+"',"+stu.getAge()+")"; ConnCOnnection conn=new ConnCOnnection(); Connection con=conn.getConnect(); try { Statement state=con.createStatement(); state.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }