jspµ¼Èëexcel
package com.lsf;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.sql.*;
import java.io.*;
import java.util.ArrayList;
import java.sql.Connection;
public class ReadExcelTest
{
private Connection con;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String USER="sa";
String PWD="sa";
private ArrayList listFirstColum = new ArrayList();
private ArrayList listSecondColum = new ArrayList();
// Á¬½ÓÊý¾Ý¿â
public ReadExcelTest() throws Exception
{
try
{
Class.forName(DBDriver);
con=DriverManager.getConnection(url,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
throw(new Exception("Sorry,database connecting failed!"));
}
}
// ´ÓexcelÖжÁÈ¡Êý¾Ý´æÈëArrayListÖÐ
public void readExcel(String sFileName)
{
try
{
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(sFileName));// ¶ÁÈ¡excelÎļþ
HSSFSheet sheet = workbook.getSheetAt(0);// ¶ÁÈ¡µÚÒ»¸ösheet
for(int i=0;i<=sheet.getLastRowNum();i++)// Ñ»·È¡µÃËùÓÐÐÐ
{
if(sheet.getRow(i)!=null)
{
HSSFRow aRow = sheet.getRow(i);// ÐÐÊý
HSSFCell cellFirstColum = aRow.getCell((short)0);// µÚÒ»ÁÐ
HSSFCell cellSecondColum = aRow.getCell((short)1);// µÚ¶þÁÐ
// °ÑÊý¾Ý´æÈëlistÀﱸÓÃ
Ïà¹ØÎĵµ£º
Ö÷ÒªÔÚjspÒ³Ãæ¼ÓÈë
<%@ page contentType="application/msexcel;charset=GBK"%>
<%
response.setHeader("Content-disposition",
"attachment; filename=shouExcel.xls");
%>
ÍêÕûÒ³ÃæÈçÏ£º
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8 ......
1 ËùÓÐµÄ .java|.jsp|.html|.xml Ô´Îļþ¾ùʹÓÃutf-8±àÂë¸ñʽ±£´æµ½ÏµÍ³´ÅÅÌ¡£
È磺ÔÚEclipseÖбà¼Îļþ£¬Ñ¡ÖÐÎļþ´ò¿ªÓÒ¼ü²Ëµ¥Ñ¡ÔñÊôÐÔ£¬½«Îı¾Îļþ±àÂëÉèÖÃΪÆäËû²¢Ñ¡ÔñUTF-8£»Ò²¿ÉÒÔÔÚ
Eclipse——Ê×Ñ¡Ïî——³£¹æ——ÄÚÈÝÀàÐÍÖÐÉèÖø÷ÖÖÎļþµÄȱʡ±àÂ룬ÕâÑùÒÔºóËùÓеÄÎı¾Îļþ¶¼Ê¹ÓÃÍ³Ò ......
×òÌìÔÚд¶«Î÷µÄʱºò£¬Êý¾Ý¿âÓõıàÂëÊǣգԣƣ£¸£¬Ò³ÃæÒ²Êǣգԣƣ£¸£¬È»ºó´æ½øÊý¾Ý¿âµÄʱ·¢ÏÖ»¹ÊÇÂÒÂë¡£ÖÐÎĵÄʱºò£¬Ëæºó£ä£å£â£õ£ç£¬²éµ½£Á£ã£ô£é£ï£îÀïÃæµÃµ½µÄ±íµ¥ÄÚÈÝÒ²ÊÇÂÒÂ룬¹þ¹þ
ÎÊÌâÕÒµ½ÁË£¬ÔÀ´Êǣƣï£ò£í±íµ¥»òÕ߯äËûµØ·½ÓÐÎÊÌâ
ºóÀ´ÔÚ£÷£å£â£®£ø£í£ìÖмÓÉ϶ԣӣð£ò£é£î£ç±àÂëµÄ¿ØÖÆÓï¾ä£¬ºÃÁË£®£®£®ºÇºÇ
......
ת×Ô£ºhttp://www.centospub.com/make/servlet.html
ǰ¡¡¡¡ÑÔ
¡¡¡¡Ëùν Java Servlet £¬ÊÇÖ¸Óà Java ÓïÑÔ£¬ÊµÏÖ¶¯Ì¬ÍøÒ³µÄ´´½¨µÄ¹¦ÄÜ£¬Ò»°ã°Ñ¼òµ¥µÄ°ÑËü³ÆÎª“Servlet”£¨ÎÞÖÐÎÄÒëÎÄ£©µÄÇé¿ö±È½Ï³£¼û¡£ºÍËü´¦ÓÚͬµÈÀà±ðµÄ¼¼Êõ»¹ÓÐÎÒÃÇÖªµÀµÄPerl¡¢PHP¡¢ASPµÈµÈ¡£ServletËãÊÇJ2EEÖеÄÒ»²¿·Ö£¬ËùÒÔÔÚÆóÒµÓ¦Ó÷½Ãæ ......