Java怎樣将資料庫中資料導出為Excel檔案，求完整例...
// 以下為我在項目中運用的jxl的核心代碼
try {
Workbook book = null;
book = Workbook.getWorkbook(file);
// 獲得第一個工作表對象
Sheet sheet = book.getSheet(0);
int rows = sheet.getRows();
if(rows>1){
Map idnomap = this.getStudentByIdnos(sheet);
for (int j = 1; j
TStudentinfo stu = this.getStudent(sheet,sheet.getRow(j),rows,j,appmap,classmap,idnomap,state);
if(stu==null){
continue;
}
stulist.add(stu);
}
}
book.close();
// DEMO: db 操作在下方
xxxService.add(stulist);
}
catch (Exception e) {
System.out.println(e);
}
用java編寫代碼按照正确格式讀取完整excel表格的數...
第一步：如何用POI操作Excel
@Test
public void createXls() throws Exception{
//聲明一個工作薄
HSSFWorkbook wb = new HSSFWorkbook();
//聲明表
HSSFSheet sheet = wb.createSheet("第一個表");
//聲明行
HSSFRow row = sheet.createRow(7);
//聲明列
HSSFCell cel = row.createCell(3);
//寫入資料
cel.setCellValue("你也好");
如何用java實作把excel表中的資料導入到mysql資料...
import java.io.*;
import java.text.SimpleDateFormat;
import java.util.*;
import java.sql.*;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import jxl.*;
public class SimUpdate {
private String fileName;
public ZfzSimUpdate(String fileName){
this.fileName = fileName;
}
static Map tNames;
static{
tNames = new HashMap();
}
private static String getDtime() {
String rid;
Date nd = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
rid = sdf.format(nd);
return rid;
}
public String getSeqNumber(String tableName) {
if(tableName == null || "".equals(tableName))
tableName = "GENERY";
Integer it;
// noinspection SynchronizeOnNonFinalField
synchronized(tNames){
it = (Integer)tNames.get(tableName);
if(it == null){
it = new Integer(100);
tNames.put(tableName, it);
}else{
if(it.intValue() > 998)
it = new Integer(100);
else
it = new Integer(1 it.intValue());
tNames.put(tableName, it);
}
}
return getDtime() String.valueOf(it);
}
private void updateDb(){
try{
Connection conn = DbPool.connectDB();
if(conn != null){
Statement stmt = conn.createStatement();
jxl.Workbook rwb = null;
try{
//建構Workbook對象 隻讀Workbook對象
//直接從本地檔案建立Workbook
//從輸入流建立Workbook
InputStream is = new FileInputStream(fileName);
rwb = Workbook.getWorkbook(is);
//Sheet(術語：工作表)就是Excel表格左下角的Sheet1,Sheet2,Sheet3但在程式中
//Sheet的下标是從0開始的
//擷取第一張Sheet表
Sheet rs = rwb.getSheet(0);
//擷取Sheet表中所包含的總列數
int rsColumns = rs.getColumns();
//擷取Sheet表中所包含的總行數
int rsRows = rs.getRows();
//擷取指這下單元格的對象引用
String simNumber = "",termSeqId = "";
//指定SIM卡号及序列号
for(int i=0;i
for(int j=0;j
Cell cell = rs.getCell(j,i);
if(j==0){
simNumber = cell.getContents();
}
termSeqId = "633" simNumber;
}
String sql = "查詢SQL";
int isOk = stmt.executeUpdate(sql);
if(isOk == 0