先把excel文件上傳到服務器,然後可以把excel當作一個表來讀取,然後把讀取出來的數據一條條的插入數據庫,給你個例子~~~try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
out.print("driver is not exist");
}
try{
Connection conn_excel=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ="這裡寫文件的絕對路徑和文件名");
Statement stmt_excel=conn_excel.createStatement();
String str_excel="Select * From [Sheet1$]";
ResultSet rs_excel=stmt_excel.executeQuery(str_excel);
while(rs_excel.next())
{
machinecode=rs_excel.getString(1);
programcode=rs_excel.getString(2); if(programcode != null && !programcode.trim().equals(""))
{
Connection conn=Conn.getConnection();
String str_insert="insert into SA_List(SA_L_MachineCode,SA_L_ProgramCode) values(?,?)";
PreparedStatement stmt=conn.prepareStatement(str_insert);
stmt.setString(1,machinecode);
stmt.setString(2,programcode);
stmt.executeUpdate();
}
}
}
catch(Exception e)
{
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
out.print("driver is not exist");
}
try{
Connection conn_excel=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ="這裡寫文件的絕對路徑和文件名");
Statement stmt_excel=conn_excel.createStatement();
String str_excel="Select * From [Sheet1$]";
ResultSet rs_excel=stmt_excel.executeQuery(str_excel);
while(rs_excel.next())
{
machinecode=rs_excel.getString(1);
programcode=rs_excel.getString(2); if(programcode != null && !programcode.trim().equals(""))
{
Connection conn=Conn.getConnection();
String str_insert="insert into SA_List(SA_L_MachineCode,SA_L_ProgramCode) values(?,?)";
PreparedStatement stmt=conn.prepareStatement(str_insert);
stmt.setString(1,machinecode);
stmt.setString(2,programcode);
stmt.executeUpdate();
}
}
}
catch(Exception e)
{
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货