Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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(JAVA)α¾²Ì¬µÄ¾ßÌåÉèÖùý³Ì

Ò»£ºµ½http://tuckey.org/urlrewrite/  ÏÂÔØurlrewrite¼Ü°ü£¨ÍƼö2.6.0£©
¡¡¡¡¶þ£º½âѹËùÏÂÔØµÄÎļþ,°Ñurlrewrite-2.6.0.jar¸´ÖƵ½ÏîÄ¿µÄWebRoot/WEB-INF/lib/Ŀ¼ÏÂ
¡¡¡¡Èý£º°Ñurlrewrite.xml¸´ÖƵ½ÏîÄ¿µÄWebRoot/WEB-INF/Ŀ¼ÏÂ
¡¡¡¡ËÄ£ºÔÚweb.xmlÎļþÖмÓÈëÒÔÏÂ
¡¡¡¡<filter>
¡¡¡¡<filter-name>Ur ......

¹ØÓÚJSPµÄ¸ÐÏë

      ÕâÁ½¸öÐÇÆÚ³ýÁËרҵ¿Î·½ÃæµÄѧϰ£¬Ò»Ö±ÔÚѧϰJSP£¬ÓõÄÊÇ¡¶21ÌìѧͨJAVA WEB¿ª·¢¡·Õâ±¾»ù´¡ÈëÃŽ̲ģ¬Ê鱾ɿ¼°µ½µÄ¶«Î÷²¢²»¶à£¬Ñ§µÄ»¹ÊÇһЩ±È½ÏdzÏԵĶ«Î÷°É¡£Ò²ÐíºÜ¶à¶«Î÷ÕæµÄÒª½Ó´¥ÁËÖ®ºó²Å»áÓиоõ£¬×÷Ϊ¸Õ¸Õ½Ó´¥web¿ª·¢µÄ²ËÄñ¶øÑÔ£¬Äܹ»½«Ð´µÄ¶«Î÷ÔËÐÐÆðÀ´ÕæµÄºÜÓгɾ͸У¬(*^__^*) Îû ......

jspѧϰС֪ʶ

1. Tomcat¶Ë¿ÚÅäÖÃ
    ¿ÉÒÔÔÚTomcat·þÎñÆ÷µÄconfÎļþϵÄÖ÷ÅäÖÃÎļþserver.xmlÖеÄÀ´¸ü¸Ä¶Ë¿ÚºÅ¡£
    Èç¹ûTomcat·þÎñÆ÷ËùÔڵļÆËã»úûÓÐÆô¶¯ÆäËûµÄÕ¼ÓÐ80¶Ë¿ÚºÅµÄÍøÂç³ÌÐò£¬Ò²¿ÉÒÔ½«Tomcat·þÎñÆ÷µÄ¶Ë¿ÚºÅÉèÖÃΪ80£¬ÕâÑùÓû§ÔÚ·ÃÎÊTomcatµÄ·þÎñÆ÷µÄʱºò¾Í¿ÉÒÔÊ¡ÂԶ˿ںţ¬ÀýÈ磺http£º// ......

JSP ÉÏ´«ºÍÏÂÔØÎļþ

×¼±¸Ìõ¼þ£º
ÔÚJboss4.2.2GA¸ùĿ¼Ï²¿ÊðÅäÖÃÎļþ£ºconstants.xml
<?xml version="1.0" encoding="UTF-8"?>
<constants>
<init-constants>
<context-param>
<name>path.upload.dcm</name>
<value>//192.168.1.37/upload/oaw/</value>
</context-para ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ