在java中如何实现将excel中的数据导入SqlServer？

Question

要源码，， 从头到尾的，， 我还不会。

Answer 1

需要导入一个jxl jar包，这个jar包在网上下载，专门用于读取excel
读取的代码在网上有很多，
我大概的写一下吧
//取得工作薄
WorkBook workbook = WorkBook.getWorkBook(new File("文件的路径名"));
//取得excel的第一页
Sheet sheet = workbook.getSheet(0);
int rowNum = sheet.getRows();
for(int i=0; i<rowNum;i++){
}

Answer 2

...点错了，没写完，继续上边
int rowNum = sheet.getRows();   --获取一共有多少行
int colNum = sheet.getCols();   --获取列的方法名具体忘了，你Eclipse里敲下就知道了 
for(int i=0; i <rowNum;i++){ 
   for(int j =0 ;j<colNuml;j++){
     Cell cell =  sheet.getCell(j,i);   ---获取每一个单元格
      String content = cell.getContent();   --获取单元格的内容
   }
}这样你就应该知道怎么从excel里读数据了，真正的具体运行还是自己写比较好，刚学java自己多敲敲代码能加深记忆，复制是不行的~~~~

Answer 3

servlet实现的上传的excel文件后输出其内容import java.io.*;
import java.net.*;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileItemFactory;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class Dataimport extends HttpServlet {    private Logger log = Logger.getLogger(Dataimport.class);    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            boolean isMultipart = ServletFileUpload.isMultipartContent(request);
            FileItemFactory factory = new DiskFileItemFactory();
            ServletFileUpload upload = new ServletFileUpload(factory);
            List items = null;
            try {
                items = upload.parseRequest(request);
            } catch (Exception e) {
                log.error("");
            }
            Iterator itr = items.iterator();
            while (itr.hasNext()) {
                FileItem item = (FileItem) itr.next();
                if (!item.isFormField()) {
                    HSSFWorkbook workbook = null;
                    try {
                        workbook = new HSSFWorkbook(item.getInputStream());
                    } catch (Exception e) {
                        log.error("" + item.getName() + "");
                    }
                    int number = workbook.getNumberOfSheets();
                    log.info("\n" + item.getName() + "" + number + "");
                    for (int i = 0; i < number; i++) {
                        log.info("" + item.getName() + "" + workbook.getSheetName(i) + "");
                        ParseSheet(workbook.getSheetName(i), workbook.getSheetAt(i));
                    }
                }
            }
        }    public void ParseSheet(String sheetname, HSSFSheet sheet) {
        Map<Integer,String> exattrs = new HashMap<Integer,String>();
        HSSFRow row = sheet.getRow(0);
        if (row != null) {
            int colnum = row.getLastCellNum();
            if (colnum != 0) {
                for (int i = 0; i <= colnum; i++) {
                    cell = row.getCell((short) i);
                    if (cell != null) {
                        System.out.println(cell.toString());
                    }
                }
            }
        }
    }
}