With attribute label development ---- J2EE small application 2 (Inber)

xiaoxiao2021-03-06  109

With attribute label development full process ---- J2EE Small Application 2 (Inber) Tag Application: Data Source MyDataSource2 User SA Password (Empty) Database Pubs Table: Employee

Description: Windows ODBC --- SQL Database PUBS Table: Employee

Function: Search JOB_LVL> = (input value) AND JOB_LVL <= (input value) data record, where you want to call in the JSP page

Call it.

(1) Tag handler: Employeetag.javaPackage 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;

Private string min; public void setminvalue (string t) {this.min = t;} public string getminvalue () {return this.min;} public void setMaxValue (string m) {this.max = m;} Public string getMaxvalue () {return this.max;}

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.get (). Write (""); tryContext.get (); con = drivermanager.getConnection ("JDBC: ODBC: MyDataSource2", "SA", "" ); String strQuery = "select emp_id, fname, lname, job_lvl, hire_date from employee where job_lvl> =" min "and job_lvl <=" max; System.out.println (strQuery); 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 (" FNAME ""); Out.write (" job_lvl ""); out.write (""); Out.write ("" } Out.write ("");} catch (exception e) {// throw new jsptagexception ("Fatal Error: Connect Error!");}} Catch (ooException EX) {throw new jsptagexception "Fatal Error: Hello Tag Conld Not Write to JSP OUT");} Return Eval_page; // Return Skip_page;}}

(2) Configure the label library descriptor (TLD) file configTLD.TLD

a Tag Library Exercising SimpleTag Handlers. 1.0 A Simple Tab Library for the Examples

Select DB Pubs Tb Employees selectsql Net.inber.employEetag jsp maxValue true TRUE

minvalue true TRUE (3) Create Index.jsp File <% @ Taglib Uri = "/ taguri" prefix = "mytag"%> <% @ page import = "net.inber. *"%> <% @ page consttype = "text / html; charSet = GB2312" Language = "java"%% > first cumstomed tag </ title> <meta http-equiv = "content-type" content = "text / html; charSet = GB2312> </ head> <body> <Table Width = "386" Height = "67" border = "0"> <tr> <td> <form1 = "form1" method = "post" action = "> <table width =" 392 "Height =" 94 " Border = "0"> <Tr> <TD> Enter the maximum <input name = "themaxput" type = "text" id = "themaxput"> </ td> </ tr> <tr> <td> Enter minimum <input name = "theminput" type = "text" id = "theminput"> </ td> <input type = "submit" name = "submit" value = "Submit"> <Input Name = "HD" type = "hidden" id = "hd" value = "yes"> </ td> </ tr> </ table> </ form> </ td> </ tr> </ table ></p> <p><% String themax, themin; string ghd; GHD = Request.getParameter ("HD"); Themax = Request.GetParameter ("THEMAXPUT"); Themin = Request.GetParameter ("THEMINPUT");%> <p> Content Pubs Retrieval Table Employee JOB_LVL is greater than or equal to (input value) <% = THEMIN%> smaller than (input value) <% = themax%> record display: </ 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> <mytag: selectsql minvalue = '<% = theme%>' maxValue = '<% = themax%> /> This is the main end section </ body> </ html></p> <p>(4) Final deployment (Press the Tomcat Directory Structure Market, will modify the web.xml file as follows)</p> <p><? XML Version = "1.0" encoding = "ISO-8859-1"> <! - Copyright 2004 The Apache Software Foundation</p> <p>Licensed Under The Apache License, Version 2.0 (The "license"); You May Not Use this file exceptin 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-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> - Define Tag Uri -> <taglib-uri> / taguri </ taglib-uri> <! - Define Tag Specific Location -> <taglib-location> / Web-INF / TLDS / ConfigTLD .TLD </ taglib-location> </ taglib></p> <p><! - jspc servlet mappings end -></p> <p></ web-app></p> <p>Summary: Tips - Note that the attribute name defined by the JSP page is the first letter to lowercase the set (get) such as MinValue in the handler.</p> <p>After the method, the first letter should be uppercase to avoid confusing errors; in various file configuration parameters should try to avoid the parameters of the same name to avoid difficult</p> <p>Understand, causing the trouble of maintenance.</p> <p>This example of the original code download: http:/inber.51.net/9cbs_blog/soft/tag2.rar</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-124649.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="124649" 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.044</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 = 'CJeW8BdJLax1QS5Ico_2BzJWCPaSq_2Fq4z98BIT7wRoZe8qBDD4G7BxGi8xGZiTn2CS9hLCzbzJ0jjvKFX9Z6nRzQ_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>