Because MS Word and Excel support HTML text format, you can use Word or Excel to do a template, save it as a web page, and then change the HTML to JSP, you can dynamically fill the data part, you don't have to worry hard. Adjustment format Word page As long as the JSP head is set as follows: <% @ page contentType = "Application / MSWORD; charset = GBK"%> Excel as follows: <% @ Page ContentType = "Application / VND.MS-Excel; Charset = GBK "%> Using this method The client must install Office software, and the user will open the page directly in IE during IE. This method advantage is that template design, convenient adjustment, no need to use complex POI or JXL technology on server-side, there is no need to use ActiveX control technology, safer, more secure, and easy to implement better printing effects on the client.
Microsoft About Server Dynamically Create Office Documents (ASP Example): http://support.microsoft.com/default.aspx?scid=kb;n-us;301044& Simple example: Using Word to establish a document, the drawing table is as follows : -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - Save as web page test.htm, rename Test.htm to test.jsp, modify the Guest, passers-by, male from the database dynamic query, as follows: <% @ Page ContentType = Application / Msword; charset = GBK "%> <% @ page import =" java.sql. * "%>
User Information </ Title> <! - [IF GTE MSO 9]> <xml> <OocUmentProperties> <o: Author> Evan Zhao </ o: Author> <o: Lastauthor> Evan Zhao </ o: Lastauthor> <o: revision> 1 </ o: revision> < O: Totaltime> 1 </ o: Totaltime> <o: create> 2003-08-20t16: 26: 00z </ o: create> <o: lastsaved> 2003-08- 20T16: 27: 00Z </ o: Lastsaved> <OAGES> 1 </ OAGES> <o: Company> Taiping </ o: Company> <o: lines> 1 </ o: lines> <oragraplay> 1 </ oragraphs > <o: Version> 9.2812 </ o: Version> </ OOCUMENTPROPERTIES> </ XML> <! [endif] -> <! - [if gte mso 9]> <xml> <w: WordDocument> <wunctuationkerning /> <wrawinggridvertageSpacing></p>
<p>7.8 lbs </ wrawingGridVerticalSpacing> <wisplayHorizontalDrawingGridEvery> 0 </ wisplayHorizontalDrawingGridEvery> <wisplayVerticalDrawingGridEvery> 2 </ wisplayVerticalDrawingGridEvery> <w: Compatibility> <w: SpaceForUL /> <w: BalanceSingleByteDoubleByteWidth /> <woNotLeaveBackslashAlone /> <w: ULTrailSpace /> < WONOTEXPANDSHIFTRETURN /> <W: AdjustLineHeightintable /> <W: useFelayout /> </ w: Compatibility> </ w: WordDocument> </ xml> <! [endif] -> <style> <! - / * font definitions * / @ font-face {font-family: Song; Panose-1: 2 1 6 0 3 1 1 1 1; MSO-FONT-Alt: SIMSUN; MSO-FONT-CHARSET: 134; MSO-generic-font- Family: Auto; MSO-FONT-PITCH: Variable; MSO-FONT-SIGNATURE: 3 135135232 16 0 262145 0;} @ font-face {font-family: "@ 体"; Panose-1: 2 1 6 0 3 1 1 1 1; MSO-FONT-CHARSET: 134; MSO-generic-font-family: Auto; MSO-FONT-PITCH: Variable; MSO-FONT-SIGNATURE: 3 135135232 16 0 262145 0;} / * style definitions * / p.msonormal, div.msonormal, div.msonormal {mso-style-parent: ""; margin: 0cm; margin-bottom: .0001pt; text-align: Justify; Text-Justify: inter-ideograph; mso- PAGINATION: NONE Font-size: 10.5pt; mso-bidi-font-size: 12.0pt; font-family: "Times new Roman"; MSO-FAREAST-FONT-FAMILY: Song; MSO-FONT-KERNING: 1.0pt;} / * Page definitions * / @ page {mso-page-border-surround-header: no; mso-page-border-surround-footer: no;} @ page section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt; mso-header-margin: 42.55pt; mso-footer-margin: 49.6pt; mso-paper-source: 0; layout-grid: 15.6pt;} div.section1 {page: section1;} > </ style> </ head> <body lang = zh-cn style = 'tab-interval: 21.0pt; text-justify-trim: puncture'> <div class = section1 style = '</p>
<p>Layout-grid: 15.6pt '> <table border = 1 cellspacing = 0 cellpadding = 0 style =' border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt '> <tr> <td width = 189 Valign = Top Style =' Width: 142.0pt; border: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt '> <p class = msonormal> < Span style = 'font-family: Song; MSO-ASCII-FONT-FAMILY: "Times New Roman"; MSO-HANSI-FONT-FAMILY: "Times New Roman"> User Name </ span> </ p> < / TD> <TD Width = 189 Valign = Top Style = 'Width: 142.05pt; border: solid windowtext .5pt; border-left: none; mso-border-left-alt: solid windowText .5pt; padding: 0cm 5.4pt; padding: 0cm 5.4pt; 0cm 5.4pt '> <plass = msonormal> <span style =' font-family: Song; MSO-ASCII-FONT-FAMILY: "Times New Roman"; MSO-HANSI-FONT-FAMILY: "Times New Roman" ' > Reality Alt; Padding: 0cm 5.4pt 0cm 5.4pt '> <p class = msonormal> <span style =' font-family: Song; MSO-ASCII-FONT-FAMILY: "Times New Roman"; MSO-HANSI-FONT-FAMILY: "Times New Roman"> Gender </ span> </ p> </ td> </ tr> <% class.Forname ("Sun.jdbc.odbc.jdbcodbcdriver"; string URL = "JDBC: ODBC: MYDB"; // Connect the MYDB Database Connection Con = DriverManager.getConnection (URL, "," "); Try {Statement Stmt = Con.CreateStatement (); // Query Employee Table ResultSet RS = Stmt.executeQuery ("Select User_Name, Real_name, Gender from Employee); While (Rs.Next ()) {%> <</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-76647.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="76647" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.045</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'DqYAVRGHRSSSLPqJUM_2FjbL_2FugGeoj8LEfeXsWMYFfgo8Xd5LRQBS37DD7_2BsQPiUECPa_2BI2B96stIY9bex9JCug_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
