Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÀﱸÓÃ


Ïà¹ØÎĵµ£º

Java¡¢JSP¡¢HTML¡¢XML±àд¶¼Òª·ûºÏÒÔϱàÂë¹æÔò£¡

1 ËùÓÐµÄ .java|.jsp|.html|.xml Ô´Îļþ¾ùʹÓÃutf-8±àÂë¸ñʽ±£´æµ½ÏµÍ³´ÅÅÌ¡£
È磺ÔÚEclipseÖб༭Îļþ£¬Ñ¡ÖÐÎļþ´ò¿ªÓÒ¼ü²Ëµ¥Ñ¡ÔñÊôÐÔ£¬½«Îı¾Îļþ±àÂëÉèÖÃΪÆäËû²¢Ñ¡ÔñUTF-8£»Ò²¿ÉÒÔÔÚ
Eclipse——Ê×Ñ¡Ïî——³£¹æ——ÄÚÈÝÀàÐÍÖÐÉèÖø÷ÖÖÎļþµÄȱʡ±àÂ룬ÕâÑùÒÔºóËùÓеÄÎı¾Îļþ¶¼Ê¹ÓÃÍ³Ò ......

jspÂÒÂë½â¾ö´óÈ«(ת×ÔcsdnÒ»¸ßÊÖ)

Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
¶þ¡¢±íµ¥Ìá½»ÖÐÎÄʱ³öÏÖÂÒÂë
Èý¡¢Êý¾Ý¿âÁ¬½Ó
´ó¼ÒÔÚJSPµÄ¿ª·¢¹ý³ÌÖУ¬¾­³£³öÏÖÖÐÎÄÂÒÂëµÄÎÊÌ⣬¿ÉÄÜÒ»ÖÁÀ§ÈÅ×ÅÄú£¬ÎÒÏÖÔÚ°ÑÎÒÔÚJSP¿ª·¢ÖÐÓöµ½
µÄÖÐÎÄÂÒÂëµÄÎÊÌâ¼°½â¾ö°ì·¨Ð´³öÀ´¹©´ó¼Ò²Î¿¼¡£
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
ÏÂÃæµÄÏÔÊ¾Ò³Ãæ(display.jsp)¾Í³öÏÖÂÒÂ룺
<html>
<head>
<tit ......

JSPµÄ»á»°¸ú×Ù¼¼Êõ

JSPµÄ»á»°¸ú×Ù¼¼Êõ
       Cookie£º·þÎñÆ÷ÔÚÒ»¸öÓ¦´ðÊײ¿´«µÝ¸øä¯ÀÀÆ÷µÄÃû³Æ/Öµ¶Ô¡£ä¯ÀÀÆ÷±£´æµÄʱ¼äÓÉcookieµÄ¹ýÆÚʱ¼äÊôÐÔÀ´Ö¸¶¨¡£µ±ä¯ÀÀÆ÷Ïòij¸ö·þÎñÆ÷·¢ËÍÒ»¸öÇëÇóʱ£¬Ëü»á¼ì²éÆä±£´æµÄcookie£¬²¢ÔÚÇëÇóÊײ¿Öаüº¬´Óͬһ̨·þÎñÆ÷ÉϽÓÊÕµ½µÄËùÓÐcookie¡£
      ......

£¨×ª£©CENTOS4ÅäÖÃJSP½Ì³Ì

ת×Ô£ºhttp://www.centospub.com/make/servlet.html
ǰ¡¡¡¡ÑÔ
¡¡¡¡Ëùν Java Servlet £¬ÊÇÖ¸Óà Java ÓïÑÔ£¬ÊµÏÖ¶¯Ì¬ÍøÒ³µÄ´´½¨µÄ¹¦ÄÜ£¬Ò»°ã°Ñ¼òµ¥µÄ°ÑËü³ÆÎª“Servlet”£¨ÎÞÖÐÎÄÒëÎÄ£©µÄÇé¿ö±È½Ï³£¼û¡£ºÍËü´¦ÓÚͬµÈÀà±ðµÄ¼¼Êõ»¹ÓÐÎÒÃÇÖªµÀµÄPerl¡¢PHP¡¢ASPµÈµÈ¡£ServletËãÊÇJ2EEÖеÄÒ»²¿·Ö£¬ËùÒÔÔÚÆóÒµÓ¦Ó÷½Ãæ ......

2010.5.5¼Ç£¨JSPÖÐÒýÓÃjsÎļþ»á·¢ÉúÒýÓò»µ½µÄÎÊÌ⣩

ÔÚJSPÖÐÒýÓÃjsÎļþ»á·¢ÉúÒýÓò»µ½µÄÎÊÌ⣺
    ÔÚwebÏîÄ¿À´æÔÚWEB-INFÎļþĿ¼£¬ÎҵĴíÎó×ö·¨ÊǰÑjs£¬image£¬CSS¶¼·ÅÔÚ´ËÎļþ¼ÐÏ¡£×î³õÒÔΪÊÇÏà¶Ô·¾¶Óë¾ø¶Ô·¾¶¸ã´íÁË£¬µ«ÊÇÔõôÐÞ¸ÄÒ²ÎÞ·¨½â¾öÎÊÌâ¡£µ÷ÓÃjsʱ×ÜÊǻᱨȱÉÙ¶ÔÏó£¬×îºóÁ˽âÊÇÒòΪWEB-INFÕâÀïµÄ¶«Î÷ÊDz»ÈÃÖ±½Ó·ÃÎʵġ£ËùÒԸı䷽·¨°ÑÕâЩΠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ