JSP JSP JSP in JBuilder9 + WebLogic7 uses JDBC

zhaozj2021-02-16 52

JBUILDER9 WebLogic7 actual articles

JSP calls JDBC articles through JavaBean

Author: Kay Huang

E_mail: hk_sz@163.com

Application of JSP JavaBean JDBC Oracle

First, start JBUILDER

Start JBuilder: Start / Program / Borland JBuilder 9 Enterprise Trial / Borland JBuilder 9 Enterprise Trial

Before operating the following steps, check if your configuration and parameters are consistent with the tool articles of JBuilder9 WebLogic7 actual combat (Oracle9i), "JBuilder9 WebLogic7 actual combat tool (JDBC 1)".

There are no detailed description of the part if you don't understand, please refer to "JSP servlet articles".

Second, create a project

Create a project called Search.

Third, set the Web Application

Create a Web Application called Search.

Fourth, create a JSPS

4.1 Creating a search.jsp file;

4.2 Replacing all code in the Code Area with the following code:

<% @ page contenttype = "text / html; charset = GBK"

IMPORT = "java.util. *" import = "java.sql.resultset" import = "search.dbbean"%>

Search </ title> </ hEAD> <body bgcolor = "# ffffff"> <center> <h1> JSP -> Javabean -> JDBC -> Oracle </ h1> </ center> <% Dbbean conn = new dbbean (); ResultSet RS = NULL; RS = conn.executeQuery ("Select * from count"); ArrayList Validates = New ArrayList (); While (rs.next ()) { String Num1 = rs.getstring ("Num1"). Trim (); String Num2 = rs.getstring ("Num2"). Trim (); String result = rs.getstring ("result"). Trim (); %> <table width = "100%" cellspacing = "0" Cellpadding = "5" align = "center"> <tr> <TD> Num1 </ td> <TD> Num2 </ td> <TD> Result </ td> </ TR> <tr> <TD> <% = Num1%> </ td> <TD> <% = Num2%> </ td> <td> <% = result%> </ td> </ TR> </ TABLE> <% } Conn.closeConnection (); %> </ body> </ html> V. Create Javabean 5.1 Select File / New ... in the menu bar, pop up the Object Gallery window; 5.2 Click the General tab; 5.3 Select JavaBean and then click OK to show the JavaBean wizard page; 5.4 Enter dbbean after Class Name; click OK to complete. 5.5 Replace all of the code in the code area: Package Search; Import java.io. *; Import java.sql. *; Import java.util. *; Import javax.naming. *; Import javax.sql. *; Public Class Dbbean Implements Serializable { DataSource DS = NULL; CONTEXT CTX = NULL; Connection conn = NULL; Statement Stmt = NULL; ResultSet RS = NULL; Public void getConnection () { Try { // Get the initial context information of WebLogic Server JBDI CTX = GetInitialContext (); System.out.println (ctx.tostring ()); / / Find the JNDI name as the data source of JDBC / TestTxDataSource, establish a data source object DS = (javax.sql.datasource) CTX.lookup ("JDBC / TesttxDataSource"); System.out.println (ds.toString ()); / / Establish a data connection via a data source object CONN = ds.getConnection (); System.out.println (Conn.toToString ()); / / Establish a statement object STMT = conn.createstatement (); } Catch (java.sql.sqlexception es) { System.out.println ("MySQLException" es.getMessage ()); } Catch (Exception EX) { System.out.println ("Conn IS Error" EX.GETMESSAGE ()); } } Public void closeconnection () { Try { IF (rs! = null) // Close the result set Rs.close (); IF (Stmt! = NULL) // Turn off the statement object Stmt.close (); IF (CONN! = NULL) // Close connection CONN.CLOSE (); } Catch (java.sql.sqlexception e) { System.out.println ("MyCloseConnectioinsql" E.GetMessage ()); RS = NULL; STMT = NULL; CONN = NULL; } } Public ResultSet ExecuteQuery (String SQL) { RS = NULL; Try { IF (conn == null) GetConnection (); IF (CONN! = NULL) STMT = conn.createstatement (); RS = stmt.executequery (SQL); } Catch (Exception E) { System.out.println ("ExecuteQuery Error Here:" E.getMessage ()); } Return RS; } Public Boolean ExecuteUpdate (STRING SQL) { Boolean bupdate = false; Try { IF (conn == null) GetConnection (); IF (CONN! = NULL) { STMT = conn.createstatement (); Int rowcount = stmt.executeUpdate (SQL); IF (RowCount! = 0) BUPDATE = TRUE; } } Catch (SQLException EX) { System.err.Println ("Conn.executeUpdate" ex.getMessage ()); } Return BUPDATE; } // getInitialContext () method is used to get the initial context environment of WebLogic Server for JNDI queries. Private static context getinitialcontext () THROWS Exception { // URL, USER, PASSWORD corresponds to WebLogic Server's address, port number, system user, and password String URL = "T3: // localhost: 7001"; String User = "training"; String password = "training"; Properties Properties = NULL; Try { Properties = new property (); Properties.put (Context.Initial_Context_Factory, "WebLogic.jndi.wlinitialContextFactory"); Properties.Put (Context.Provider_URL, URL); Properties.Put (Context.security_principal, user); Properties.put (Context.security_credentials, password); Return New InitialContext (Properties); } Catch (Exception E) { Throw e; } } / * Bean test Public static void main (string args []) { ResultSet RS = NULL; Try { DBBean conndata = new dbbean (); // Establish a result set object RS = connData.executeQuery ("Select * from count"); // Traverse the result set object, access each record, output data While (rs.next ()) { String Num1 = rs.getstring ("Num1"). Trim (); string num2 = rs.getstring ("num 2"). Trim (); String result = rs.getstring ("result"). Trim (); System.out.Println ("Validate: / '" Num1 " " Num2 "=" Result "/" IS "); } } Catch (Exception E) {} } * / } After running, run the result. My article is the first Auro Forum (www.newer.com.cn/bbs) and programmers forum (www.9cbs.net), welcome to reprint, but please keep the author and the name of the revision, thank you.</div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-28154.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"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></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>New Post(0) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="28154" 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: 0.043, SQL: 9</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);"></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'XIxn5oda9uE0YADC_2FzbJ9EtaduTpCN_2FAFI_2BNObNz_2F3IQV6yvewS0V1If2NIPDHrMzhJ3JVaTbAxirK5V'; 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>