java从数据库导入excel

Love The Way You Lie 2022-05-29 10:49 273阅读 0赞

`java把数据从数据库导入到excel`

`package` `com.madhouse.sys.util;`

`import` `java.io.File;`

`import` `java.io.IOException;`

`import` `java.sql.DriverManager;`

`import` `java.sql.ResultSet;`

`import` `java.sql.ResultSetMetaData;`

`import` `java.sql.SQLException;`

`import` `jxl.Workbook;`

`import` `jxl.write.Label;`

`import` `jxl.write.WritableSheet;`

`import` `jxl.write.WritableWorkbook;`

`import` `jxl.write.WriteException;`

`import` `jxl.write.biff.RowsExceededException;`

`import` `org.apache.commons.logging.Log;`

`import` `org.apache.commons.logging.LogFactory;`

`import` `com.mysql.jdbc.Connection;`

`import` `com.mysql.jdbc.Statement;`

`/**`

` ` `* <li>把数据导入到Excel公用类</li>`

` ` `* </br> This is about <code>ExcelUtil</code>`

` ` `*`

` ` `* @author hjy273`

` ` `* @version 1.0`

` ` `* @date Sep 6, 2008 9:52:52 PM`

` ` `*/`

`public` `class` `ExcelUtil {`

`    ` `private` `static` `Log log = LogFactory.getLog(ExcelUtil.` `class` `);`

`    ` `public` `ExcelUtil() {`

`    ` `}`

`    ` `public` `boolean` `DB2Excel(ResultSet rs) {`

`        ` `boolean` `flag =` `false` `;`

`        ` `WritableWorkbook workbook =` `null` `;`

`        ` `WritableSheet sheet =` `null` `;`

`        ` `Label label =` `null` `;`

`        ` `// 创建Excel表`

`        ` `try` `{`

`             ` `workbook = Workbook.createWorkbook(` `new` `File(` `"e:/_report/output.csv"` `));`

`            ` `//workbook = Workbook.createWorkbook(os);`

`            `

`             ` `// 创建Excel表中的sheet`

`            ` `sheet = workbook.createSheet(` `"First Sheet"` `,` `0` `);`

`            ` `// 向Excel中添加数据`

`            ` `ResultSetMetaData rsmd = rs.getMetaData();`

`            ` `int` `columnCount = rsmd.getColumnCount();`

`            ` `String colName =` `null` `;`

`            ` `int` `row =` `0` `;`

`            ` `// 添加标题`

`            ` `for` `(` `int` `i =` `0` `; i < columnCount; i++) {`

`                ` `colName = rsmd.getColumnName(i +` `1` `);`

`                ` `label =` `new` `Label(i, row, colName);`

`                ` `// log.debug("标题:"+i+"---"+row +"---"+ colName);`

`                ` `sheet.addCell(label);`

`            ` `}`

`            ` `row++;`

`            ` `log.debug(` `"写入标题成功"` `);`

`            ` `while` `(rs.next()) {`

`                ` `for` `(` `int` `i =` `0` `; i < columnCount; i++) {`

`                    ` `label =` `new` `Label(i, row, rs.getString(i +` `1` `));`

`                    ` `log.debug(` `"行:"` `+i+` `"---"` `+row +` `"---"` `+ rs.getString(i+` `1` `));`

`                    ` `sheet.addCell(label);`

`                ` `}`

`                ` `row++;`

`            ` `}`

`            ` `log.debug(` `"写入内容成功"` `);`

`            ` `// 关闭文件`

`            ` `workbook.write();`

`            ` `workbook.close();`

`            ` `log.info(` `"数据成功写入Excel"` `);`

`            ` `flag =` `true` `;`

`        ` `}` `catch` `(SQLException e) {`

`            ` `log.debug(e.getMessage());`

`        ` `}` `catch` `(RowsExceededException e) {`

`            ` `log.debug(e.getMessage());`

`        ` `}` `catch` `(WriteException e) {`

`            ` `log.debug(e.getMessage());`

`        ` `}` `catch` `(IOException e) {`

`            ` `log.debug(e.getMessage());`

`        ` `}` `finally` `{`

`            ` `try` `{`

`                ` `workbook.close();`

`            ` `}` `catch` `(Exception e) {`

`            ` `}`

`        ` `}`

`        ` `return` `flag;`

`    ` `}`

`    ` `/**`

`     ` `* 测试方法`

`     ` `*`

`     ` `* @param args`

`     ` `*/`

`    ` `public` `static` `void` `main(String[] args) {`

`        ` `// write your code`

`        ` `try` `{`

`            ` `Class.forName(` `"org.gjt.mm.mysql.Driver"` `).newInstance();`

`            ` `Connection conn = (Connection) DriverManager`

`                    ` `.getConnection(`

`                            ` `"jdbc:mysql://localhost:3306/firewall?useUnicode=true&characterEncoding=utf8"` `,`

`                            ` `"root"` `,` `"root"` `);`

`            ` `Statement st = (Statement) conn.createStatement();`

`            ` `ResultSet rs = st`

`                    ` `.executeQuery(` `"select * from firewall.tb_operator"` `);`

`             ` `if` `(!` `new` `ExcelUtil().DB2Excel(rs)){`

`                 ` `log.info(` `"数据写入失败"` `);`

`             ` `}`

`            ` `rs.close();`

`            ` `st.close();`

`            ` `conn.close();`

`        ` `}` `catch` `(Exception e) {`

`            ` `e.printStackTrace();`

`        ` `}`

`    ` `}`

`}`

java从数据库导入excel

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 SQLServer数据库如何从Excel中导入数据表？

相关如何用java导入excel数据到数据库_如何用java导入Excel数据到数据库？

相关 java 从EXCEL导入到数据库

相关 java导入excel数据内容存入数据库

相关 java从数据库导入excel

相关 excel导入mysql数据库

相关 Excel表格导入到数据库

相关 Delphi XE2 从Excel导入到数据库《LceMeaning》

相关导入excel数据到数据库

相关 java导入Excel数据到数据库