Java Jacob将数据库信息导入Word文档

package com.andy.jacob;
002
003 import java.io.File;
004 import java.sql.ResultSet;
005 import java.sql.ResultSetMetaData;
006 import java.sql.SQLException;
007 import java.util.ArrayList;
008 import java.util.List;
009
010 import com.andy.db.DBUtil;
011 import com.jacob.com.ComThread;
012
013
014 public class ReadOracleToWard {
015
016 private DBUtil dbUtil = null;
017 // 表格列名数组
018 private String colNames[] = null;
019 // 表格value值
020 private List colValuesList = null;
021
022 private Inerttable inerttable = null;
023
024  
025 public void writeColNames(String colNames[]) {
026   for (int i = 0; i < colNames.length; i++) {
027    inerttable.putTxtToCell(1, 1, (i + 1), colNames[i]);
028   }
029 }
030
031  
032 public void writeColValues(List colValuesList) {
033   String[] colValues = null;
034   int row = 2;
035   for (int i = 0; i < colValuesList.size(); i++) {
036    colValues = colValuesList.get(i);
037    for (int k = 0; k < colValues.length; k++) {
038     inerttable.putTxtToCell(1, row, (k + 1), colValues[k]);
039    }
040    row++;
041   }
042 }
043
044  
045 public ResultSet getResultSet(String tableName) {
046   dbUtil = new DBUtil();
047   String sql = "select * from " + tableName;
048   ResultSet rs = null;
049
050   dbUtil.findConnection();
051   dbUtil.findPreparedStatement(sql);
052   rs = dbUtil.queryDB(sql);
053   System.out.println("getResultSet : rs : " + rs);
054   return rs;
055 }
056
057  
058 public String[] getColNames(ResultSet rs) throws SQLException {
059   System.out.println("getResultSet : rs : " + rs);
060   ResultSetMetaData rsmd = null;
061   if (rs != null) {
062    rsmd = rs.getMetaData();
063    int count = rsmd.getColumnCount();
064
065    colNames = new String[count];
066
067    for (int i = 0; i < count; i++) {
068     colNames[i] = rsmd.getColumnName(i + 1);
069    }
070   } else {
071    colNames = new String[] {};
072   }
073   return colNames;
074 }
075
076  
077 public List getColValuesList(ResultSet rs) throws SQLException {
078   colValuesList = new ArrayList();
079   System.out.println("getResultSet : rs : " + rs);
080   ResultSetMetaData rsmd = null;
081   if (rs != null) {
082    rsmd = rs.getMetaData();
083    int count = rsmd.getColumnCount();
084    String[] colValues = null;
085
086    while (rs.next()) {
087     colValues = new String[count];
088     for (int i = 0; i < count; i++) {
089      String value = rs.getString(i + 1);
090      // 将 数据库中的 null 转化为"null"，避免在转化格式时出错
091      if (value == null || "".equals(value)) {
092       value = "null";
093      }
094      colValues[i] = value;
095     }
096     colValuesList.add(colValues);
097    }
098   }
099   return colValuesList;
100 }
101
102  
103 public void writeToWord(String tableName) {
104   try {
105    long begin = System.currentTimeMillis();
106    ResultSet rs = getResultSet(tableName);
107    getColNames(rs);
108    getColValuesList(rs);
109
110    ComThread.InitSTA();
111    inerttable = new Inerttable();
112    inerttable.createNewDocument();
113    inerttable.createTable(colNames.length, colValuesList.size() + 1);
114
115    writeColNames(colNames);
116    writeColValues(colValuesList);
117
118    String docPath = getLocationPath(tableName);
119    inerttable.save(docPath);
120    ComThread.Release();
121
122    long end = System.currentTimeMillis();
123    System.out.println("用时：" + String.valueOf(end - begin));
124   } catch (Exception e) {
125    // TODO: handle exception
126    System.out.println("异常：" + e.getMessage());
127   } finally {
128    dbUtil.closeResource();
129   }
130 }
131
132  
133 public String getLocationPath(String tableName) {
134   // 生成文件路径(在本项目src下)
135   File f = new File(".");
136   f = new File(f, "src/com/andy/jacob");
137
138   if (!f.exists()) {
139    f.mkdirs();
140   }
141   f = new File(f, tableName + ".docx");
142   return f.getAbsolutePath();
143 }
144
145 public static void main(String[] args) {
146   ReadOracleToWard toWard = new ReadOracleToWard();
147   String tableName = "andy_blob";
148   toWard.writeToWord(tableName);
149 }
150 }


此文档是别人写的！我拷贝下来的，方便以后观看！请勿怪！