日期:2014-05-18  浏览次数:20713 次

求一将Excel的数据导到数据库中的程序,紧急,在线等待中!
求一Excel的数据导到数据库中的程序,  
Excel   中有几个sheet   ,     单元格中还可能含有图片等文档   ,
数据库为oracle,   其他数据库的也行,  

我暂时用的是JXL   ,
也有人用POI或其他的,都可以,只要达到要求就行了,因为比较紧,没时间挑三检四,功能第一先.

如上,给出程序代码的(连接的也可以)   立马   给分.

先谢谢各位了^^^^^^

------解决方案--------------------
使用jxl.jar的api函数可以比较轻松的完成
------解决方案--------------------
//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.0/xslt/JavaClass.xsl

package com.inventec.cmm.shopimport;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import javax.servlet.RequestDispatcher;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.swing.JOptionPane;
import java.io.File;

//import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.*;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.upload.FormFile;

import java.lang.*;
import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;


import java.util.*;
;
/**
* MyEclipse Struts
* Creation date: 02-18-2006
*
* XDoclet definition:
* @struts:action validate= "true "
*/
public class DoImportAction extends Action {

// --------------------- Instance Variables

// --------------------- Methods

/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute (
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) throws Exception{

// Logger logger =Logger.getLogger( "DoatProAction.class ");

Collection errors = new ArrayList();
String id= "-1 ";
if (request.getParameter( "id ")==null){
errors.add( "请登陆! ");
return mapping.getInputForward();
}else
id=request.getParameter( "id ");

request.setAttribute( "id ",request.getParameter( "id "));

// int isnull =0;
int cnt=0;

String dir=servlet.getServletContext().getRealPath( "/upload ");
ShopImportForm hff=(ShopImportForm)form;
FormFile file =(FormFile) hff.getFile();

if((file==null)||(file.getFileSize()==0))

{
errors.add( "文件上传出错或者未指定文件! ");
request.setAttribute( "errors ",errors);
return mapping.getInputForward();
}

String fname=file.getFileName();
String size=Integer.toString(file.getFileSize())+ "bytes ";
InputStream streamIn=file.getInputStream();

java.text.DateFormat d = new java.text.SimpleDateFormat( "yyyy-MM-dd-hh_mm_ss ");
String strd = d.format(new Date(System.currentTimeMillis()));

S