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ÀﱸÓÃ
Ïà¹ØÎĵµ£º
µÚ1Ìõ How to Write an Equality Method in Java
http://www.artima.com/lejava/articles/equality.html
How to Write an Equality Method in Java
by Martin Odersky, Lex Spoon, and Bill Venners
June 1, 2009
Summary
This article describes a technique for overriding the equals method t ......
ÕâÁ½¸öÐÇÆÚ³ýÁËרҵ¿Î·½ÃæµÄѧϰ£¬Ò»Ö±ÔÚѧϰJSP£¬ÓõÄÊÇ¡¶21ÌìѧͨJAVA WEB¿ª·¢¡·Õâ±¾»ù´¡ÈëÃŽ̲ģ¬Ê鱾ɿ¼°µ½µÄ¶«Î÷²¢²»¶à£¬Ñ§µÄ»¹ÊÇһЩ±È½ÏdzÏԵĶ«Î÷°É¡£Ò²ÐíºÜ¶à¶«Î÷ÕæµÄÒª½Ó´¥ÁËÖ®ºó²Å»áÓиоõ£¬×÷Ϊ¸Õ¸Õ½Ó´¥web¿ª·¢µÄ²ËÄñ¶øÑÔ£¬Äܹ»½«Ð´µÄ¶«Î÷ÔËÐÐÆðÀ´ÕæµÄºÜÓгɾ͸У¬(*^__^*) Îû ......
Ê×ÏÈ˵˵ΪʲôҪ¾²Ì¬»¯¡£
¶ÔÓÚÏÖÔÚµÄWeb ApplicationÀ´Ëµ£¬¶¯Ì¬Ò³ÃæÊÇÕ¼Óоø¶Ô¸ßµÄµØÎ»µÄ£¬ÕýÒòΪÓÐÁ˶¯Ì¬»¯£¬²ÅÓÐÁËÏÖÔÚWebµÄ·á¸»¶à²Ê£¬µ«ÊÇÈçͬËùÓбðµÄÊÂʵһÑù£¬ºÃ´¦ÍùÍù¶¼ÊÇÓдú¼ÛµÄ¡£
ΪÁ˲úÉú³ö¶¯Ì¬µÄЧ¹û£¬Ã¿Ò»´Î¶ÔÒ³ÃæµÄÇëÇó¶¼»áÒªÇó·þÎñÆ÷¶ÔÒ³Ãæ½øÐбàÒë»òÕßÖ´ÐУ¬ÕâЩ²Ù×÷¶¼ºÜÏûºÄϵͳ×ÊÔ´¡£Èç¹ûÕâÆÚ¼ä»¹ÓÐºÍ ......
×î½üÊÕµ½Ò»¸öÏîÄ¿µÄÔ´´úÂ룬²¿ÊðÒÔºó´ò¿ªÒ³Ãæ·¢ÏÖJSPÒ³ÃæÖеÄEL±í´ïʽ¶¼Ã»ÓнâÎö£¬¶¼ÊÇÔÑùÏÔʾ¡£
ÉÏÍøËÑË÷ÁËÒ»ÏÂÔÒò£¬ÔÀ´ÊÇServlet°æ±¾µÄÎÊÌâ¡£ÔÀ´ServletÖпÉÒÔÉ趨ÊÇ·ñ½âÎöEL±í´ïʽ£¬Ö»ÓÐ2.4°æ±¾µÄServletĬÈÏÊǽâÎöEL±í´ïʽµÄ£¬¶øÆäËû°æ±¾ÊÇĬÈϲ»½âÎöEL±í´ïʽ£¬²éÁËһϳÌÐò£ ......
jspѧϰÐĵÃ
ѧϰJSP¼¼ÊõÒ²¿ì°ëÄê¶àÁ˰ɣ¬×Ô¼ºÒ²¶¯ÊÖ±àдÁËһЩ¼òµ¥µÄ¶¯Ì¬ÍøÒ³°É¡£ÖÚËùÖÜÖª¶¯Ì¬ÍøÒ³Èý´ó¼¼ÊõASP£¬JSP£¬PHP»ù±¾ÉÏÊÇÈý·ÖÌìÏ£¬µ±È»»¹ÓÐÆäËûÓïÑÔÏñRuby£¬PythonµÈÒ²Õ¼¾Ý²»Ð¡µÄ·Ý¶î¡£
ѧϰJSP¹ý³ÌÖÐÎҸд¥×îÉîµÄÊÇÈçϼ¸µã£º
1.JSPÊÇÒ»ÖÖ±íʾ²ãµÄ¼¼Êõ
&nb ......