Looking for Tomcat's database connection pool configuration method, busy one morning, finally succeeded, huh, huh
Operating system: Windows XP SP1
1. Install JDK 5.0 Update 1
Download: http://java.sun.com/
Assume that the installation path is d: /java/jdk1.5.0_01 Set the environment variable (Control Panel -> System -> Advanced) Java_Home = D: /JAVA/JDK1.5.0_01ClassPath = .; d: /java/jdk1.5.0_01/ LIB / DT.JAR; D: /JAVA/JDK1.5.0_01/lib/tools.jar; Path = path;% java_home% / bin
2. Install Tomcat 5.5.4
Download: http://jakarta.apache.org/site/binIndex.cgi (http://apache.freeelamp.com/jakarta/tomcat-5/v5.5.4/bin/jakarta-tomcat-5.5.4.exe)
Installing D: / Tomcat 5.5, installing Tomcat 5.5 requires JRE 5.0. If the first installed JDK5.0 path is not automatically identified, you need to manually specify the path to JRE5.0.
Set environment variables Catalina_Home = D: / Tomcat 5.5
------------------------------------------ Configuration D: / Tomcat 5.5 / CONF / Server.xml ----------------------------------------- Host> plus the following configuration information
Where the Path sets the name of the virtual directory, DocBase is configured for the actual path in the system Note to put the JDBC driver of SQL Server (msqlserver.jar) in D: / Tomcat 5.5 / Common / lib or D: / dbtest / web-inf / lib directory
D: / dbtest directory structure | ----- Web-inf ---- Web.xml | ----- Classes | ----- LIB ------------- ------------------------------ Configuration D: /DBTEST/Web-inf/web.xml ------- ------------------------------------ Between Plus ConnectDB JDBC / ConnectDB javax.sql.datasource < Res-auth> Container After configuring Tomcat --------------------------- -------------- JSP test code D: /dbteest/testdb.jsp ------------------------- ---------------- <% @ page contenttype = "text / html; charSet = GBK"%> <% @ page import = "java.sql. *, javax.sql. DataSource, javax.naming. * "%> dbcp </ title> </ head> <body bgcolor =" # ffffff "> <h1> test tomcat </ h1> <% try { Context initCtx = new InitialContext (); DataSource ds = (DataSource) initCtx.lookup ( "java: comp / env / jdbc / connectDB"); Connection conn = ds.getConnection (); Statement stmt = conn.createStatement (); ResultSet RS = stmt.executequery ("Select * from test"); While (rs.next ()) {%> first: <% = rs.getstring (1)%> <%}%> <% out.print ("sucssful! / n");%> <% rs.close (); stmt.close ();} catch (exception e) {E.PrintStackTrace ();}%> </ body> </ html> Note Before you first build the corresponding test data in SQL Server</p>
<p>Ok, now I am visiting http: // localhost: 8080 / dbtest / testdb.jsp in the browser.</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-62940.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="62940" 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 = 'uQfePnFX_2BfLoU4u44ylfwQpJJ_2Bw0_2B6vqWx_2BkAF8nAs2047gGNORiJf0yEqlWTXWDLm9JMpRCsaJR5HwPo2C4pg_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>
