jspÒ³ÃæÊý¾Ýµ¼Èëword
Ò»¡¢°ÑjspÒ³ÃæÊý¾Ý¸´ÖƵ½wordÎĵµ
var table=document.getElementById('printTable');
row=table.rows.length;
column=table.rows(1).cells.length;
var word = new ActiveXObject("Word.Application");
word.Application.Visible = true;
word.Selection.Text ="<%=reportTitle%>";
var mydoc=word.Documents.Add('',0,0);
myRange =mydoc.Range(0,1);
var sel=document.body.createTextRange();
sel.moveToElementText(table);
sel.select();
sel.execCommand('Copy');
myRange.Paste();
¶þ¡¢°ÑjspÒ³ÃæÊý¾ÝдÈëwordÎĵµ
var table=document.getElementById('printTable');
row=table.rows.length;
column=table.rows(1).cells.length;
var wdapp=new ActiveXObject("Word.Application");
wdapp.visible=true;
wddoc=wdapp.Documents.Add(); //Ìí¼ÓеÄÎĵµ
thearray=new Array();
//½«Ò³ÃæÖбí¸ñµÄÄÚÈÝ´æ·ÅÔÚÊý×éÖÐ
for(i=0;i<row;i++){
thearray[i]=new Array();
for(j=0;j<column;j++){
thearray[i][j]=table.rows(i).cells(j).innerHTML;
}
}
var range = wddoc.Range(0,0);
range.Text="<%=reportTitle%>"+"\n";
wdapp.Application.Activedocument.Paragraphs.Add(range);
wdapp.Application.Activedocument.Paragraphs.Add();
rngcurrent=wdapp.Application.Activedocument.Paragraphs(3).Range;
var objTable=wddoc.Tables.Add(rngcurrent,row,column) //²åÈë±í¸ñ
for(i=0;i<row;i++){
for(j=0;j<column;j++){
objTable.Cell(i+1,j+1).Range.Text = thearray[i][j].replace(" ","");
}
}
Ïà¹ØÎĵµ£º
Java/JSPÖÐÎÄÂÒÂëÎÊÌâ½â¾öÐĵÃ
×Ô´Ó½Ó´¥JavaºÍJSPÒÔÀ´£¬¾Í²»¶ÏÓëJavaµÄÖÐÎÄÂÒÂëÎÊÌâ´ò½»µÀ£¬ÏÖÔÚÖÕÓڵõ½Á˳¹µ×µÄ½â¾ö£¬ÏÖ½«ÎÒÃǵĽâ¾öÐĵÃÓë´ó¼Ò¹²Ïí¡£
Ò»¡¢JavaÖÐÎÄÎÊÌâµÄÓÉÀ´
JavaµÄÄں˺ÍclassÎļþÊÇ»ùÓÚunicodeµÄ£¬ÕâʹJava³ÌÐò¾ßÓÐÁ¼ºÃµÄ¿çƽ̨ÐÔ£¬µ«Ò²´øÀ´ÁËһЩÖÐÎÄÂÒÂëÎÊÌâµÄÂé·³¡£ÔÒòÖ÷ÒªÓÐÁ½·½Ã棬JavaºÍJS ......
ÔÚÌÚ¿ÆÅàѵÁËÓÐ1¸ö°ëÔÂÁË£¬ÖÕÓÚѧÍêJSP+SERVLET+JAVABEAN+MYSQL£¬Ñ§ÁËjavaµÄµÚÒ»Ì×web½â¾ö·½°¸¡£ÀÏʦҪÇóÎÒÃÇ6ÈËÒ»×鿪ʼ×öÒ»¸ö¶©²Íϵͳ¡£Õâ¸öϵͳûÓÐÊ²Ã´ÌØ±ðµÄ£¬¾Í¸úµç×ÓÉ̳ÇÊÇÒ»¸öÑùµÄ¡£ÓÉÓÚÒª¶ÔÊý¾Ý¿â×ö´óÁ¿µÄÔöɾ¸Ä²é£¬ÄǸö´úÂëÓֶ࣬ÎÒÏëÄܲ»Äܽ«Êý¾Ý¿â²Ù×÷µÄÕâÒ»²ã´ò°üÆðÀ´(SqlOperDao)£¬ÈÃÎÒ¶ÔÊý¾Ý¿â²Ù×÷£¬Óü¸Ðд ......
JSPÓï·¨
Ö¸Áî(Directive)±ê¼Ç
page Ö¸Áî
include Ö¸Áî
taglib Ö¸Áî
<%@ page language="java" %>
<%@ include file="test.html"%>
<%@ taglib uri="http://www.deng.com/tags" prefix="util" %>
......
¼òµ¥½éÉÜJSPÊý¾Ý¿â²Ù×÷µÄ3¸öС¼¼ÇÉ£ºÊý¾ÝÅÅÐò£¬Ö÷/´Ó±í´¦Àí£¬ÊÂÎñ´¦Àí¡£
1¡¡Êý¾ÝÅÅÐò
ÔÚÊý¾Ý¿â¼¼ÊõÖУ¬¿ÉÒÔʹÓÃORDER×Ó¾ä¶Ô²éѯ½á¹û½øÐÐÅÅÐò
[ ORDER BY { order_by_exdivssion[ ASC | DESC]} [ ¸…n ] ]
ÆäÖУ¬order_by_exdivssionÓÃÀ´Ö¸¶¨ÒªÅÅÐòµÄÁУ»ASCÖ¸¶¨°´µÝÔö˳ÐòÅÅÁУ»DESCÖ¸¶¨°´µÝ¼õ˳ÐòÅÅÐò ......