JDK installation is simple, if you have a problem, you can send me an email, or visit my homepage, http://www.bcxy.com/sdl1, install Tomcat
Make sure that JDK is installed, refer to the Tomcat for Window's installation wizard, basically directly installed, note: Enter the management username and password when installing, this is the username and password used later, remember.
2, install mysql
The default is installed.
3, use Tomcat's Web Management Application Configure Data Source
Start the Tomcat server, open the browser, enter http: // localhost: 8080 / admin / (where localhost is the name server or the host), enters the management interface login page, at this time, please enter the user name that is required to enter when installing. Password, log in to the management interface,
Select Resources-Data Sources to enter the configuration data source interface, select Data Source Actions -> Select CREATE New Data Source to enter the configuration details interface, the content is as follows:
JNDI NAME: JDBC / MySQL
Data Source URL: JDBC: MySQL: // Localhost: 3306 / CS
JDBC Driver Class: com.mysql.jdbc.driver
User Name: root
PASSWORD: *********
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query:
The information requested by JNDI Name is required, in which other other can be filled in according to your needs. For example, the content of the Data Source URL may be: jdbc: mysql: // ip or name / databasename, where DatabaseName is your database name, IP is the IP or name of the server where your database is located. Finally click Save-> Commit Change. So your basic data of your data source is half configured.
4 (This step can not be done, just check it) Modify the configuration file corresponding to your reference under Web.xml and% Tomcat_Home% / Conf / Catalina / localhost
Open% tomcat_home% / conf / web.xml, add the following in front of ::
DB Connection
jdbc / mysql
javax.sql.datasource
container
Note that the content fill in RES-REF-NAME is consistent with the JNDI Name name mentioned above.
Enter% Tomcat_Home% / Conf / Catalina / LocalHost, find your web application corresponding to the .xml file (below with my web directory structure), such as MyWeb.xml, and add the code under this file:
to here, the configuration work is basically completed.
5, other considerations
Don't forget the JDBC driver mysql-connection-bin.ja must be placed to Tomcat's corresponding directory, your JDBC driver may be high, but as long as you can correspond to the mysql used Yes, because I found that the version of the JDBC driver that does not support 4.0. * Version of the MySQL database, it is recommended to place under the% Tomcat_Home / Common / LIB and the application of Web-INF / LIB. What is the difference between the two? In fact, I will understand that Common / lib is all applications that can be used by all applications.
Restart your Tomcat service.
6, write test code
Create a Test.jsp file in the application's directory, the code is as follows:
"http://www.w3.org/tr/rec-html40/strict.dtd">
<% @ Page Import = "java.sql. *"%>
<% @ Page Import = "javax.sql. *"%>
<% @ Page Import = "javax.naming. *"%>
<% @ Page ContentType = "text / html; charset = GB2312"%>
</ title></p>
<p><%</p>
<p>Out.print ("My Test Start");</p>
<p>Try {</p>
<p>Context initContext = new InitialContext (); Context envContext = (Context) initContext.lookup ( "java: / comp / env"); DataSource ds = (DataSource) envContext.lookup ( "jdbc / mysql"); con = ds.getConnection ();</p>
<p>Statement Stmt = conn.createstatement ();</p>
<p>// Tip: Users must be a table for the database,</p>
<p>// The database mentioned in the Data Source URL configuration herein is included in the database.</p>
<p>String strsql = "select * from users";</p>
<p>ResultSet RS = Stmt.executeQuery (strsql);</p>
<p>While (rs.next ()) {</p>
<p>Out.print (Rs.getstring (1));</p>
<p>}</p>
<p>Out.print ("My Test ends");</p>
<p>}</p>
<p>Catch (Exception EX) {</p>
<p>Out.print ("Exception Exceptions, information is:" ex.getMessage ());</p>
<p>EX.PrintStackTrace ();</p>
<p>%></p>
<p></ hEAD></p>
<p><body></p>
<p></ body></p>
<p></ html></p>
<p>operation result:</p>
<p>My test starts 12345678 My test ends because my RS.GetString (1) is stored in the database 12345678</p>
<p>7, summary</p>
<p>Thank Jemlee2002 Note: In H: / Webspp / MyWeb / Web-INF / LIB / Under is JSTL's JAR file, Classes is bean, H: / Webspp / MyWeb / Web-INF / Lower (refer to me Alternative: Install JSTL in Tomcat and 8 TLD files. Mysql's drive is placed in% Tomcat_Home% / Common / Lib / under% Tomcat_Home% / CONF / CATALINA / LOCALHOST / Under the <context path = "" DOCBASE = "H: / WebApp / MyWeb" debug = "0"> <logger classname = "org.apache.catalina.logger.filelogger" prefix = "localhost_customer_log." Suffix = ". Txt" timestamp = "true" /> <resourceLink name = "jdbc / mysql" global = "jdbc / mysql" type = "javax.sql.datasource" /></p>
<p></ Context></p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-103999.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="103999" 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.036</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 = 'Wg2uD11O8Ir9xv2WssXwF02Y6L7HY6dJECyH09404HEG8IXssMrgmlY_2F5nfbWIY1CZWBwYJ0SlKY0y6JPGknRQ_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>
