java把excel内容上传到mysql实例代码
mysql表列名num1,num2,num3,num4,num5,num6表名Excle
上传的方法
packagecom.web.connection;
importjava.io.FileInputStream;
importjava.io.FileNotFoundException;
importjava.io.IOException;
importorg.apache.commons.logging.Log;
importorg.apache.commons.logging.LogFactory;
importorg.apache.poi.hssf.usermodel.HSSFCell;
importorg.apache.poi.hssf.usermodel.HSSFRow;
importorg.apache.poi.hssf.usermodel.HSSFSheet;
importorg.apache.poi.hssf.usermodel.HSSFWorkbook;
importorg.apache.poi.xssf.usermodel.XSSFCell;
importorg.apache.poi.xssf.usermodel.XSSFRow;
importorg.apache.poi.xssf.usermodel.XSSFSheet;
importorg.apache.poi.xssf.usermodel.XSSFWorkbook;
publicclassTestExcel{
//记录类的输出信息
staticLoglog=LogFactory.getLog(TestExcel.class);
//获取Excel文档的路径
//.xlsx文件用XSSFWorkbook.xlx用HSSFWorkbook
publicstaticStringfilePath="D://demoExcel.xlsx";
publicstaticvoidmain(String[]args){
try{
//创建对Excel工作簿文件的引用
XSSFWorkbookwookbook=newXSSFWorkbook(newFileInputStream(filePath));
//在Excel文档中，第一张工作表的缺省索引是0
//其语句为：HSSFSheetsheet=workbook.getSheetAt(0);
XSSFSheetsheet=wookbook.getSheet("Sheet1");
//获取到Excel文件中的所有行数
introws=sheet.getPhysicalNumberOfRows();
//遍历行
for(inti=0;i0){
System.out.println("插入成功");
}else{
System.out.println("插入失败");
}
}
}
}
catch(FileNotFoundExceptione){
e.printStackTrace();
}
catch(IOExceptione){
e.printStackTrace();
}
}
}
其中TestEntity为用存放从excel表中查询到的数据的实体类
packagecom.web.connection;
publicclassTestEntity{
privateStringnum1;
privateStringnum2;
privateStringnum3;
privateStringnum4;
privateStringnum5;
privateStringnum6;
publicTestEntity(){
}
publicStringgetNum1(){
returnnum1;
}
publicvoidsetNum1(Stringnum1){
this.num1=num1;
}
publicStringgetNum2(){
returnnum2;
}
publicvoidsetNum2(Stringnum2){
this.num2=num2;
}
publicStringgetNum3(){
returnnum3;
}
publicvoidsetNum3(Stringnum3){
this.num3=num3;
}
publicStringgetNum4(){
returnnum4;
}
publicvoidsetNum4(Stringnum4){
this.num4=num4;
}
publicStringgetNum5(){
returnnum5;
}
publicvoidsetNum5(Stringnum5){
this.num5=num5;
}
publicStringgetNum6(){
returnnum6;
}
publicvoidsetNum6(Stringnum6){
this.num6=num6;
}
}
TestMethod为往mysql表中插入数据的sql语句
packagecom.web.connection;
importjava.sql.Connection;
importjava.sql.PreparedStatement;
importjava.sql.SQLException;
publicclassTestMethod{
publicintadd(TestEntityte){
Connectioncon=DBconnection.getConnection();
PreparedStatementpstmt=null;
intcount=0;
Stringsql="insertintoExcle(num1,num2,num3,num4,num5,num6)values(?,?,?,?,?,?)";
try{
pstmt=con.prepareStatement(sql);
pstmt.setString(1,te.getNum1());
pstmt.setString(2,te.getNum2());
pstmt.setString(3,te.getNum3());
pstmt.setString(4,te.getNum4());
pstmt.setString(5,te.getNum5());
pstmt.setString(6,te.getNum6());
count=pstmt.executeUpdate();
/*
*if(count==0){thrownewDataAlreadyExistException();}
*/
}
catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
finally{
try{
pstmt.close();
}
catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
DBconnection.closeConnection();
}
returncount;
}
}
总结
以上就是本文关于java把excel内容上传到mysql实例代码的全部内容，希望对大家有所帮助。感兴趣的朋友可以继续参阅本站其他相关专题，如有不足之处，欢迎留言指出。感谢朋友们对本站的支持！