Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/





package mypackage.servletxsl.examples;



import java.io.*;

import java.net.*;

import javax.servlet.*;

import javax.servlet.http.*;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFDataFormat;

import org.apache.poi.hssf.usermodel.HSSFFont;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.util.HSSFColor;

//或者直接引用import org.apache.poi.hssf.usermodel.*;



public class HSSFCreate extends HttpServlet {

    public void init(ServletConfig config){}

　　 throws ServletException {

        super.init(config);

    }

    public void destroy() {

    }

    protected void processRequest(HttpServletRequest request,

        HttpServletResponse response)

　　　　 throws ServletException, IOException {

        response.setContentType("application/vnd.ms-excel");

        HSSFWorkbook wb = new HSSFWorkbook();

        HSSFSheet sheet = wb.createSheet("new sheet");

        HSSFRow row     = sheet.createRow((short)0);

        HSSFCell cell   = row.createCell((short)0);

        cell.setCellValue(1);

        row.createCell((short)1).setCellValue(1.2);

        row.createCell((short)2).setCellValue("一个字符串值");

        row.createCell((short)3).setCellValue(true);

        OutputStream out = response.getOutputStream();

        wb.write(out);

        out.close();

    }



    protected void doGet(HttpServletRequest request,

        HttpServletResponse response)

　　　　 throws ServletException, IOException {

        processRequest(request, response);

    }



    protected void doPost(HttpServletRequest request,

        HttpServletResponse response)

　　　　 throws ServletException, IOException {

        processRequest(request, response);

    }



    public String getServletInfo() {

       return "示例：在Servlet中用HSSF创建Excel工作簿";

    }

}

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/





package xsl;



import java.io.*;

import java.net.URL;

import java.io.File;

import java.util.Date;

import jxl.*;

import jxl.read.biff.*;

import tel.db.DBConnect;

import tel.util.*;

import java.sql.*;

import javax.servlet.http.*;



public class xsl {

  public xsl() {

  }

  public  void    test(){

    System.out.println("test ok");

  }

  public void  readWrite(String xlsFile ,String date)   throws   Exception{

   String myxslFile = xlsFile;

   FileInputStream fileOut = null;

   URL url = this.getClass().getResource("../../../upload_file/updata.xls");

  try {

      Workbook workbook = Workbook.getWorkbook(new File(url.getFile()));

      Sheet sheet = workbook.getSheet(0);

      int cNum=sheet.getColumns();

      DBConnect dbc = new DBConnect();

      dbc.prepareStatement("select * from user");

      dbc.executeUpdate();

      int rNum=sheet.getRows();

      for(int i=1;i<rNum;i  )

        {

          Cell a0=sheet.getCell(0,i);

          Double b0=new Double(a0.getContents());

          number=b0.intValue();

          dbc.prepareStatement("INSERT INTO user(user) VALUES (?)");

          dbc.setInt(1, user);

          dbc.executeUpdate();

        }

 workbook.close();

      }

      catch (BiffException ex2) {

        System.out.println("jxl.read.biff.erro");

      }

      catch (IOException ex2) {

      }

   }