Quick Test Tomcat + Oracle 9i + JSP

xiaoxiao2021-03-06  78

My environment is Windows 2000, but the same concept should be available in Linux. I will have a chance to verify it, and then POST. 1. First install JDK 1.4.2_01, http://java.sun.com/j2se/2 Next, the ORACLE9I is installed. After the installation is complete, change the parameters of XML Database because XML Database's HTTP Server preset use port 8080, will be able to change the proposes with Tomcat to change to 8081, refer to these two pictures http://home.pchome.com .tw / service / anthonycs / image / oracle04.gifhttp: //home.pchome.com.tw/service/anthonycs/image/oracle05.gif3. You can then install Tomcat, use the JDK1.4.2_01 installed as Tomcat as Tomcat Virtual Machine4 Download Oracle JDBC Driver http://otn/java/sqlj_jdbc/content.html According to JDK1.4.2_01, Oracle 9.2.0.1.0 is three files OCRS12.ZIP OJDBC14. Jar ojdbc14_g.jar places the downloaded file to / WebApps / Examples / Web-INF / LIB / Restart Tomcat service Note: To pick the correct JDK and Oracle version of Driverjdk, ​​Tomcat, Oracle JDBC Driver should be coordinated, especially CAUTION There are more than two JDK versions to install Tomcat. HR is an example, refer to the three pictures below, the picture is large, and you will be able to enjoy the better http://home.pchome.com.tw/service/anthonycs/image/oracle01.gifhtp://home.pchome.com. Tw / Service / Anthonycs / Image / Oracle02.gifhttp: //home.pchome.com.tw/service/anthonycs/image/oRacle03.gif6. Write a JSP page, refer to the following blue Part of the Oracle host is set (IP, SID, password) <% @ page contenttype = "text / html; charSet = BIG5" Language = "java" import = "java.sql. *, Oracle.jdbc. * "%> </ title> </ head> <body> Test OracleDriver <p> <% results = null; string oracle: th: @oracle host ip: 1521: SID "; string oracleuser =" hr "; string oraclepass =" xxxx "; try {drivermanager.registerdriver (new oracle.jdbc.driver.Oracledriver ());} catch (sqlexception e) {Out.Print (" Driver } ");} Try {connection conn =</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-108100.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="108100" 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.042</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 = 'LCrA5wnHG_2BC22X85CUTC4J85FDp41eF7suxz_2B_2BhTD8IrK_2FeTNlXGfGUVTuC7alLIoJfZ4g4YtOp5MqHyKVheMg_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>