Label application: Data source MyDataSource2 User SA Password (empty) Database PUBS table: Employee
Description: Windows ODBC --- SQL Database PUBS Table: Employee
Function: Retrieve data records of JOB_LVL> = 100, call it in place in the JSP page.
1: Tag handler: Employeetag.java
Package Net.inber;
Import javax.servlet.jsp. *; import javax.servlet.jsp.tagext. *;
Import java.util.hashtable; import java.io.writer; import java.io.iOException; import java.util.date;
Import java.sql. *; import java.math. *; import java.util. *;
public class EmployeeTag extends TagSupport {Connection con = null; Statement state = null; ResultSet rs = null; public EmployeeTag () throws ClassNotFoundException {Class.forName ( "sun.jdbc.odbc.JdbcOdbcDriver");} public int doStartTag () throws JspTagException {return EVAL_BODY_INCLUDE;}. public int doEndTag () throws JspTagException {String dateString = new Date () toString ();. try {pageContext.getOut () write ( ""); try {JspWriter out = pageContext.getOut () Con = DriverManager.getConnection ("JDBC: ODBC: MyDataSource2", "SA", ""); String strQuery = "SELECT EMP_ID, FNAME, LNAME, JOB_LVL, HIRE_DATE AROM EMPLOYE WHERE
job_lvl> = 100 "; state = con.createStatement (); rs = state.executeQuery (strQuery); String emp_id = null; String fname = null; String lname = null; String job_lvl = null; String hire_date = null; out. Write ("
"); while (rs.next ()) {EMP_ID = rs.getstring (1); fname = rs.getstring (2) ; Lname = rs.getstring (3); job_lvl = rs.getstring (4); hire_date = rs.getstring (5); out.write (""); out.write ("| " EMP_ID " "); Out.write (" | "); Out.write (" | LNAME ""); Out.write (" | " Hire_Date " "); Out.write (" ");} Out.write (" ";} catch (exception e) {// throw new JSptagexception ("Fatal Error: Connect Error!");}} Catch (IOException EX) {Throw new JSptagexception ("Fatal Error: Hello Tag Contond Not Write To
JSP out ");} return evAl_page; // Return Skip_page;}} 2.TLD file Employeetag.TLD
a tag library adricising simpletag handlers. 1.0 a Simple Tab Library for the Examples
Select DB Pubs Tb Employees Employeetag net.inber.employeetag jsp JSP 3. JSP page call index.jsp <% @ taglib URI = "/ Employeetag" prefix = "a"%> <% @ Page Import = "Net.inber. *"%> < % @ Page ContentType = "Text / HTML; Charset = GB2312" Language = "Java"%> first cumstomed tag </ title> <meta http-equiv = "content-type" content = "Text / HTML; Charset = GB2312"> </ head> <body> <p> The following content from the library PUBS search table EMPLOYEE JOB_LVL is greater than or equal to 100 record: </ p></p>
<p><table width = '677' height = '21 'border =' 1 'bgcolor = "# c14646"> <tr> <td width = "25%> number </ td> <TD width =" 17% "> Name </ td> <td width = "13%"> Listing </ TD> <TD Width = "9%> JOB_LVL </ TD> <TD Width =" 36%> Date </ TD> </ TR > </ table> <A: Employeetag /> AAA </ body> </ html></p>
<p>4. Tomcat Deployment Web.xml</p>
<p><? XML Version = "1.0" Encoding = "ISO-8859-1"> <! - Copyright 2004 The Apache Software FoundationLicensed Under The Apache License, Version 2.0 (The "license"); You May Not Use this file except IN Compliance with the license. You may Obtain a Copy of the license at</p>
<p>http://www.apache.org/license/license-2.0</p>
<p>Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations Under the license .--></p>
<p><web-app xmlns = "http://java.sun.com/xml/ns/j2ee" xmlns: xsi = "http://www.w3.org/2001/xmlschema-instance" xsi: schemAlocation = "http : //java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web</p>
<p>-app_2_4.xsd "Version =" 2.4 "></p>
<p><Display-Name> Welcome to Tomcat </ display-name> <description> Welcome to Tomcat </ description></p>
<p><! - jspc servlet mappings start -></p>
<p><taglib> <taglib-uri> / Employeetag </ taglib-uri> <taglib-location> /web-inf/tlds/employeetag.tld </ taglib-location> </ taglib></p>
<p><! - jspc servlet mappings end -></p>
<p></ web-app></p>
<p>Ok, the last step below you should try it with your hands, if you have any questions, you can contact me.</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-124942.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="124942" 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.039</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 = '7NyEo2qKtONXWM_2F4xox4RRmPjjTzNTes91yqFazyH4QtkkQyiiP3UZF3Vim9zkl6dmnYMiEwqelMSHM0HoVKAw_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> |
