急请高手，，，如果把数据库的数据导入到excel里？

2004-08-31 11:04:03 294 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

newleave840617 墨衍会员 · AI 创作全网分发关注 + 加入社区

各位高手好：
我现在用的是oracle数据库，我要把数据库中的数据通过jsp＋bean程序导入成excel文件，有什么好方法？

...全文

newleave840617

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

newleave840617 2004-08-31

打赏
举报

请问用路径该怎样用呢？

LittleLandlord 2004-08-31

打赏
举报

URL中的DBQ可以用路径的，不一定要配置ODBC数据源

LittleLandlord 2004-08-31

打赏
举报

给你一个读Excel文件的例子，参考一下，把oracle读出，写入Excel就OK了吧
package myapp;
import java.awt.*;
import java.sql.*;

//Connect Excel Files
public class connexcel{

public void conn() {
Connection c = null;
Statement stmnt = null;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc:odbc:commbook", "", "" );
stmnt = c.createStatement();
String query = "SELECT * FROM [Sheet1$] ";
ResultSet rs = stmnt.executeQuery( query );

ResultSetMetaData rsmd = rs.getMetaData();
int columncount = rsmd.getColumnCount();
while( rs.next() ) {
for (int i = 1; i <= columncount; i++) {
if(i>1) //用逗号分隔各列
System.out.print(", ");
String columnValue = rs.getString(i);
System.out.print(columnValue);
}
System.out.println("");
}
}
catch( Exception e ) {
System.err.println( e );
}
finally {
try {
stmnt.close();
c.close();
}
catch( Exception e ) {
System.err.println( e );
}
}
}
}

boykent 2004-08-31

打赏
举报

IBM的jxl方式：
package excelfile;
import java.text.DateFormat;
import java.util.*;
import java.io.*;
import jxl.*;

/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/

public class Jxlcreateexcel {
public Jxlcreateexcel() {
}

public void getExcelFile() {
String tableName = "EXCEL_OUTPUT_TEST_REALDATA_2";
String im = "";
String sid = "oral";
String server = "10.254.100.25";
String whereItem = "rownum <3375";
try {
jxl.write.WritableWorkbook book = Workbook.createWorkbook(new File(
"/home/ljz/filestest/jxlEXCEL_OUTPUT_TEST_REALDATA_2.xls"));
jxl.write.WritableSheet sh = book.createSheet("jxltest", 0);
DBAccess dbaccess = new DBAccess();
dbaccess.setSelectItems(tableName);
dbaccess.setSid(sid);
dbaccess.setServer(server);
dbaccess.setItems(im);
dbaccess.setWhereItem(whereItem);
Hashtable sels = null;
sels = dbaccess.getSelectData();
int hashElement = sels.size();
for (int y = 0; y < hashElement; y++) {
Vector items = (Vector) sels.remove(String.valueOf(y));
for (int x = 0; x < items.size(); x++) {
jxl.write.Label labelCell = new jxl.write.Label(x, y,
(String) items.get(x));
sh.addCell(labelCell);
labelCell = null;
}
}
book.write();
book.close();
}
catch (Exception e) {
e.printStackTrace();
}
}

public static void main(String args[]) {
Date time = new Date();
DateFormat fullDateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG,DateFormat.LONG);
System.out.println("The process start time:"+fullDateFormat.format(time));
Jxlcreateexcel jxlexcle = new Jxlcreateexcel();
try {
jxlexcle.getExcelFile();
}
catch (Exception e) {
e.printStackTrace();
}
Date time1 = new Date();
System.out.println("The process end time:"+fullDateFormat.format(time1));
}

}

这是我写的在linux上面导入excel的方式，windows里面也一样，只不过把生成文件的目录改一下，还有就是你需要下载一个lib，这个就是jxl.jar,（注：DBAccess是我写的一个连接数据库以及从数据库获取数据的一个类）另外还有一种方式就是poi，我也写了，如果需要的话可以找我 msn: boykent@hotmail.com

awaysrain 2004-08-31

打赏
举报

去下poi包吧,里面的文档也很详细的

heartofsword 2004-08-31

打赏
举报

这些是用EXCEL做WEB页时自动生成的

wucr 2004-08-31

打赏
举报

newleave840617 2004-08-31

打赏
举报

heartofsword 2004-08-31

打赏
举报

heartofsword 2004-08-31

打赏
举报

JSP如下，其中SQL语句在test bean中 Resultobj是一个结果集

<%@ page language="java" contentType="text/html;charset=ISO-8859-1"%>
<%response.setContentType("application/vnd.ms-excel");%>
<%@ page import="java.util.*" %>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<jsp:useBean id="test" scope="page" class="*.*.test"></jsp:useBean>
<%@ page import="*.Resultobj"%>
String test = request.getParameter("test");
Resultobj result = test.test(test);
<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<link rel=File-List href="./Book1.files/filelist.xml">
<link rel=Edit-Time-Data href="./Book1.files/editdata.mso">
<link rel=OLE-Object-Data href="./Book1.files/oledata.mso">
<head>
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<link rel=File-List href="./gsdj.files/filelist.xml">
<link rel=Edit-Time-Data href="./gsdj.files/editdata.mso">
<link rel=OLE-Object-Data href="./gsdj.files/oledata.mso">

<style>

</style>

</head>

heartofsword 2004-08-31