JavaÀûÓÃxml½«´óÅúÁ¿Êý¾Ýµ¼³öµ½excelµÄÒ»¸ö·½·¨
±ÊÕßÔÚJava¿ª·¢Öг£³£»áÓöµ½½«Êý¾Ý¿âÊý¾Ýµ¼³öµ½ExcelµÄÒªÇ󣬱ÈÈçÔÚÎÒµÄÒ»¸öÏîÄ¿ÖУ¬¿Í»§ÒªÇóËùÓвéѯ½á¹û¶¼¿ÉÒÔµ¼³öµ½Excel£¬¶ÔÓÚÊý¾ÝÁ¿²»´óµÄ£¨¼¸ÍòÌõ£©£¬Õâ±È½ÏÈÝÒ×ʵÏÖ£¬µ«¶ÔÓÚÊý¾ÝÁ¿±È½Ï´óµÄ£¨¼¸Ê®Íò¼°ÒÔÉÏ£¬¾ßÌåÒª¿´µ¼³öÄÚÈݵÄ×ֶθöÊýºÍ³¤¶Ì£©£¬ÔòÔÚÊý¾Ý¿â²éѯºÍÉú³ÉexcelÎļþÉ϶¼»áÓÐÂé·³¡£
ÒÔÎÒÔÚʵ¼ÊÏîÄ¿ÖеÄÒ»¸ö±íΪÀý£¬Oracle 10gÊý¾Ý¿â£¬Õâ¸ö±íÖÐÓÐ40¶à¸ö×ֶΣ¬ÄÚÈÝÊÇÐÕÃû¡¢ÄêÁä¡¢ÐԱ𡢵ØÖ·¡¢ÉúÈÕ¡¢Ö°Òµ¡¢¹¤×÷µ¥Î»µÈ¸öÈËÐÅÏ¢£¬ÒªÇóµ¼³ö20¶à¸ö×ֶΡ£µ¼³öΪHTMLµÄ±í¸ñµÄ»°£¬¼´Êý¾Ý·ÅÔÚ<table><tr><td>ÖУ¬1ÍòÌõÊý¾Ý´óÔ¼ÐèÒª7.5-8M¡£
¶ÔÓÚÊý¾Ý¿â²éѯ£¬¿ÉÒÔͨ¹ýÒÔ϶þ¸ö·½·¨½â¾ö£º
Ò»¡¢²ÉÓ÷ÖÒ³²éѯ¡£¸ù¾ÝÊý¾Ý¿â·þÎñÆ÷ÐÔÄܺÍÊý¾Ý¿â²Ù×÷Ƶ·±³Ì¶È£¬¾ö¶¨Ã¿Ò³´óС£¬±ÈÈçÿҳ5000µ½10000ÐУ¬Ã¿´Î²éѯ³öÒ»Ò³£¬È»ºóÉú³ÉexcelÎļþ¡£ÕâÖÖ·½·¨µÄȱµãÊÇÐèÒª¶à´Î²éѯÊý¾Ý¿â£¬¶øÊý¾Ý¿â·ÖÒ³²éѯÒòÐèҪʹÓÃÁÙʱ±í£¬ËùÒԱȽϺÄÐÔÄÜ¡£
¶þ¡¢²ÉÓÃÖмä±í¡£Ò»´ÎÐÔ½«²éѯ½á¹û·Åµ½Öмä±íÖУ¬¿É²ÉÓÓselect ...into...”£¬ÔÙ´ÓÖмä±íÖÐÒ»²¿·ÖÒ»²¿·ÖµØÈ¡³öÀ´Éú³Éexcel¡£Ã¿È¡Ò»²¿·Ö£¬¾Í¿ÉÒÔɾ³ýËü£¬»òÕß±ê¼ÇΪ“Òѵ¼³ö”¡£ÕâÖÖ·½·¨ÐèÒª²Ù×÷Öмä±í£¬¹ý³ÌÂ鷳һЩ£¬µ«Ð§Âʺá£
ÏÂÃæÊÇÉú³ÉexcelµÄ¼¸ÖÖ·½·¨(Office 2000ÒÔÉÏʵÏÖ)£º
Ò»¡¢²ÉÓÃPOI»òÕßJXL×é¼þÉú³ÉEXCEL¸ñʽµÄÎļþ¡£ÕâÖÖ·½Ê½¿ÉÒԺܺõؿØÖÆÄÚÈݵĸñʽ£¬È±µãÊÇÕâ¶þÖÖ·½Ê½¶¼Êǽ«EXCELÎļþÕû¸ö¼ÓÔØµ½ÄÚ´æÖнøÐд¦ÀíµÄ£¬Ïòexcel×·¼ÓÊý¾Ýʱ£¬Ò²ÒªÏÈÈ«²¿¼ÓÔØÔÎļþ£¬µ±Êý¾ÝÁ¿´óʱ£¬Éú³ÉµÄEXCELÎļþ»áºÜ´ó£¬¿ÉÄÜ»áÒòÕ¼ÄÚ´æÌ«¶à¶øµ¼ÖÂWEB·þÎñÆ÷ÄÚ´æÒç³ö¡£
¶þ¡¢ÀûÓÃExcelÎļþÖ§³ÖHTML¸ñʽµÄ¹¦ÄÜ£¬¼´Ïµ½«htmlÎļþºó׺Ãû¸ÄΪ.xls£¬¾Í¿ÉÒÔÓÃexcel´ò¿ª¡£ÕâÊÇ×î¼òµ¥µÄ·½·¨£¬ÔÚJspÖÐÖ»Òª½«httpÍ·¸Äһϣ¬Èÿͻ§¶Ëä¯ÀÀÆ÷ÏÂÔØÉú³ÉµÄ.xlsÎļþ£¬¶ø²»ÊÇÈÃä¯ÀÀÆ÷´ò¿ªhtmlÎļþ¾Í¿ÉÒÔÁË¡£JspÎļþ´úÂëÈçÏ£º
view plaincopy to clipboardprint?
<%@ page language="java" contentType="text/html; charset=GBK" %>
<%
String fileName = "export_file_name.xls";//ÏÂÔØ¶Ô»°¿òµÄ±£´æÎļþÃû
response.setHeader("Content-disposition", "attachment; filename="+ fileName);
%>
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmln
Ïà¹ØÎĵµ£º
ÔÚjavaÖУ¬¼ÙÉèÄãÓÐÒ»¸öuser ¶ÔÏóµÄlist£¬´Ëuser¶ÔÏó·â×°ÁËÓû§µÄid, first name, last name and age. È»ºóÄãÏëµ÷ÓÃÒ»¸öweb service(eg. UserService.deleteUsersByIds(List<Integer> userIds) ȥɾ³ýÊý¾Ý¿âÖÐÖ¸¶¨µÄÕâЩuser¡£ ÌýÆðÀ´Ëƺõ²»Ì«À§ÄÑ£¬²»ÊÇô? ÄãËùÐèÒªÖ»Êǽ« List<User> ת»¯³ÉList&l ......
ÒòΪ¹¤×÷ÐèÒª£¬ÐèÒªÔÚͬһʱ¼äÖ´Ðжà´Îij¸ö²Ù×÷£¬¿´¿´ÊÇ·ñ»áÒýÆðÊý¾ÝµÄdeadlockÎļþ¡£
¶àÏ߳̾ßÌåÖ´ÐÐÀà
package com.ericyang.test.cmdline;
import java.util.List;
import java.text.SimpleDateFormat;
import java.text.DateFormat;
import java.util.Date;
class ThreadClass extends xxxTestBase implemen ......
Ò»¡¢½âÎöXMLÎļþʱ£¬Óöµ½DTDµÄ¶¨ÒåÒªÔõô°ì£¿
ÏÂÃæÕâ¶Î´úÂëÊÇibatisÅäÖÃÎļþ£¬ÓÃw3c Dom(ÆäʵÈÎÒâÒ»ÖÖ½âÎö·½Ê½¶¼ÊÇÕâÑù)¶¼»á´Óhttp://www.ibatis.com/dtd/sql-map-config-2.dtd
Õâ
¸öµØÖ·ÕÒ¶ÔÓ¦µÄDTDÎļþ½øÐÐУÑ飬Èç¹ûÒòÌØÍøÉÏÕâ¸öµØÖ·²»´æÔڵϰ£¬¾Í»á±¨ java.net.ConnectException:
Con ......
WebService£¬¼òµ¥Ò»µã˵£¬¾ÍÊǸö¶ÔÍâµÄ½Ó¿Ú,ÀïÃæÓк¯Êý¿É¹©Íⲿ¿Í»§µ÷ÓÃ(×¢Òâ:ÀïÃæÍ¬ÑùÓпͻ§²»¿Éµ÷Óõĺ¯Êý).¼ÙÈôÎÒÃÇÊÇ·þÎñ¶Ë,ÎÒÃÇдºÃÁ˸öwebservice,È»ºó°ÑËü¸øÁ˿ͻ§(ͬʱÎÒÃǸøÁËËûÃǵ÷ÓùæÔò),¿Í»§¾Í¿ÉÒÔÔÚ´Ó·þÎñ¶Ë»ñÈ¡ÐÅϢʱ´¦ÓÚÒ»¸öÏà¶Ô͸Ã÷µÄ״̬.¼´Êǿͻ§²»Á˽â(Ò²²»ÐèÒª)Æä¹ý³Ì,ËûÃÇÖ»»ñÈ¡Êý¾Ý. Webservice´«µ ......
ÉùÃ÷¶ÔÏóʵÀý
var xmlhttp = false;
//²úÉúÒ»¸öXMLHttpRequest¶ÔÏóʵÀý
getHTTPRequestObject();
function getHTTPRequestObject()
{
try
{
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e)
{
try
{
xmlhttp = new ActiveXObject("Micr ......