Use WebLogic Pool connection database

xiaoxiao2021-03-13  173

In the past, the Java access database is used directly to connect to the database directly; in general, every database client application is opened one or more database connections, and we can use the Pool provided by WebLogic to access the database in WebLogic. To make each database client share one or more database connections, which can improve the execution efficiency of the program and reduce the burden on the database server. This article mainly discusses the implementation of the server configuration and code, here, do not want to discuss too many poores concept and characteristics, as for the concept and principle of pool, I suggest you look at "Increase Servlet" The information of the efficiency of the access database is the author. This article introduces the Pool provided by WebLogic 5.1 mysql, and I wrote two servlet as an example of the control. One is the JDBC provided with MySQL to access mysql directly, and the other is the power provided by WebLogic to access. database.

First, please read the JDBC provided by MySQL to access mysql code directly: Myjdbc.java ------------------------------- --------------------------------------------- Import java.io . *; import java.sql *;. import weblogic.db.jdbc *;. import java.util.Properties; import javax.servlet *;. import javax.servlet.http *;. public class myjdbc extends HttpServlet {public void service (HttpServletRequest req, HttpServletResponse res) throws IOException {res.setContentType ( "text / html"); PrintWriter out = res.getWriter (); out.println ( " Hello World </! Title> </ head> "; out.println (" <body> <H1> Test JDBC! </ h1> <pre> "); connection conn = null; try {// ======== ============================================================================================================================================================================================================= ======================= Class.Forname ("org.gjt.mm.mysql.driver"). NewInStance (); conn = drivermanager.getConnection "JDBC: MySQL: / / LOCALHOST / ZJWS? User = ZJXYZ & Password = XYZ"); / / ============================= =============================================================================================================================================================================================================</p> <p>== Statement Stmt = Conn.createStatement (); ResultSet RS = Stmt.executeQuery ("SELECT * from users"); while (rs.next ()) {Out.Println (rs.getstring ("UserID") "/ T " RS.GetString (" passwd ") " / t " rs.getstring (" name "));}} rclose (); stmt.close (); conn.close ();} catch (Exception E) {System.err.Println ("Unable to load driver."); E.PrintStackTrace ();} out.println ("</ pre> </ body> </ html>);}} The above code The function is to list the use of the Users table in MySQL's ZJWS database. I tag the JDBC driver. The following is to use pool to read the database, I also make a mark, please compare it.</p> <p>The first is to configure the server, join in WebLogic.properties, # ==================================== ================= WebLogic.jdbc.connectionPool.Mysqlpool1 = / URL = JDBC: mysql: // localhost / zjws? User = zjxyz, / driver = org.gjt.mm .mysql.Driver, / loginDelaySecs = 1, / initialCapacity = 4, / maxCapacity = 10, / capacityIncrement = 2, / allowShrinking = true, / shrinkPeriodMins = 15, / refreshMinutes = 10, / allow = guest, / props = user = ZJXYZ; password = xyz; server = zjxyz # ========================================== ============= put mysql's JDBC driver in / WebLogic / MyServer / ServerClasses / Directory, I don't know why, I put the JAR package in their directory, add the path to classpath, When the result is started, I can't find the Class, so I have to unlocate the org directory and the files inside it, and the result is ok. MySQL must start more than WebLogic, because WebLogic is created when starting.</p> <p>MySQLPool.java ----------------------------------------------- -------------------------------------------------- - Import java.io. *; import java.sql. *; Import weblogic.db.jdbc. *; Import java.util.properties; import javax.servlet. *; Import javax.servlet.http. *; Public class mysqlpool extends HttpServlet {public void service (HttpServletRequest req, HttpServletResponse res) throws IOException {res.setContentType ( "text / html"); PrintWriter out = res.getWriter (); out.println ( "<html> <head> <title> Hello World! </ Title> </ head> "); out.println (" <body> <h1> test webLogic pool! </ H1> <pre>); connection conn = null; try {// == ============================================================================================================================================================================================================= ================================================2; Props.SetProperty Props.SetProperty ("Password", "zjxyzken"); Driver MyDriver = (DRIVER) Class.Forname ("WebLogic.jdbc.Pool.Driver). NewInstance (); conn = MyDriver.Connect ("JDBC: WebLogic: Pool: MySQLPool1", PrOPS); / / ============================== =============</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-129045.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="129045" 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.043</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 = 'wstIEE0LvJ7wWk_2FvFZQrF_2BPpKAV8XQnyo6vO7uonuVwMYRWxMZYr_2FLT_2Bg6FOiirnWjZPiCe2kCskj2fDd_2FH3Rg_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>