用JXL读写excel到数据库实例

package org.apache.poi.hssf.usermodel.examples; import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import org.apache.poi.hssf.usermodel.*; public class HSSFCreate extends HttpServlet { public void init(ServletConfig config){} 　　 throws ServletException { super.init(config); } public void destroy() { } /** 处理HTTP GET 和POST请求 * @param request：请求 * @param response：应答 */ 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"); // 创建一个新的行，添加几个单元格。 // 行号从0开始计算 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(); } /** 处理HTTP GET请求 * @param request：请求 * @param response：应答 */ protected void doGet(HttpServletRequest request, HttpServletResponse response) 　　　　 throws ServletException, IOException { processRequest(request, response); } /** 处理HTTP POST请求 * @param request：请求 * @param response：应答 */ protected void doPost(HttpServletRequest request, HttpServletResponse response) 　　　　 throws ServletException, IOException { processRequest(request, response); } /** 返回关于Servlet的简单说明 */ public String getServletInfo() { return "示例：在Servlet中用HSSF创建Excel工作簿"; } }