﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>语源科技BlogJava-mgp1030</title><link>http://www.blogjava.net/mgp1030/</link><description /><language>zh-cn</language><lastBuildDate>Wed, 15 Apr 2026 11:58:52 GMT</lastBuildDate><pubDate>Wed, 15 Apr 2026 11:58:52 GMT</pubDate><ttl>60</ttl><item><title>TOMCAT5.5数据源配置</title><link>http://www.blogjava.net/mgp1030/archive/2008/06/01/205149.html</link><dc:creator>苍天之狼</dc:creator><author>苍天之狼</author><pubDate>Sun, 01 Jun 2008 07:10:00 GMT</pubDate><guid>http://www.blogjava.net/mgp1030/archive/2008/06/01/205149.html</guid><wfw:comment>http://www.blogjava.net/mgp1030/comments/205149.html</wfw:comment><comments>http://www.blogjava.net/mgp1030/archive/2008/06/01/205149.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/mgp1030/comments/commentRss/205149.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/mgp1030/services/trackbacks/205149.html</trackback:ping><description><![CDATA[&nbsp;&lt;Context path="/moon" docBase="C:\downloads\jspwork"<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; debug="5" reloadable="true" crossContext="true"&gt;
<p>&lt;Resource name="jdbc/mldn" auth="Container" type="javax.sql.DataSource"<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxActive="100" maxIdle="30" maxWait="10000"<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; username="root" password="tiger" driverClassName="com.mysql.jdbc.Driver"<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; url="jdbc:mysql://localhost:3306/wolf?autoReconnect=true"/&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Context&gt;</p>
<p>==================================================================</p>
<p>&lt;Context path="/test" docBase="f:\testweb\"<br />
&nbsp;&nbsp; debug="5" reloadable="true" crossContext="true"&gt;<br />
<br />
&lt;Logger className="org.apache.catalina.logger.FileLogger"<br />
&nbsp;&nbsp;&nbsp;&nbsp; prefix="localhost_MysqlTest_log." suffix=".txt"<br />
&nbsp;&nbsp;&nbsp;&nbsp; timestamp="true"/&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp; //下面Resource中的name 是数据源的名字<br />
&lt;Resource name="名字" auth="Container" type="javax.sql.DataSource"/&gt;<br />
<br />
//与上面的名字完全相同，要进行数据源的具体配置<br />
&lt;ResourceParams name="名字"&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;factory&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;org.apache.commons.dbcp.BasicDataSourceFactory&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;maxActive&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;100&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;maxIdle&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;30&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;maxWait&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;5000&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;username&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;用户名&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;password&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;密码&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;driverClassName&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;驱动程序&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;parameter&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;name&gt;url&lt;/name&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;value&gt;连接地址&lt;/value&gt;<br />
&nbsp;&nbsp; &lt;/parameter&gt;<br />
&nbsp;&nbsp; &lt;/ResourceParams&gt;<br />
&lt;/Context&gt;</p>
<p>=================================================</p>
<p>&lt;%@ page import="java.sql.*"%&gt;<br />
&lt;%@ page import="javax.sql.*"%&gt;<br />
&lt;%@ page import="javax.naming.*"%&gt;<br />
&lt;%!<br />
final String JNDINAME = "java:comp/env/jdbc/mldn" ;<br />
%&gt;<br />
&lt;%<br />
Connection conn = null ;<br />
try<br />
{<br />
&nbsp;&nbsp; // 初始化查找命名空间<br />
&nbsp;&nbsp; Context ctx = new InitialContext() ;<br />
&nbsp;&nbsp; // 找到DataSource<br />
&nbsp;&nbsp; DataSource ds = (DataSource)ctx.lookup(JNDINAME) ;<br />
&nbsp;&nbsp; conn = ds.getConnection() ;<br />
}<br />
catch(Exception e)<br />
{<br />
&nbsp;&nbsp; System.out.println(e) ;<br />
}<br />
%&gt;<br />
&lt;%=conn%&gt;<br />
&lt;%<br />
// 将连接重新放回到池中<br />
conn.close() ;<br />
%&gt;</p>
 <img src ="http://www.blogjava.net/mgp1030/aggbug/205149.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/mgp1030/" target="_blank">苍天之狼</a> 2008-06-01 15:10 <a href="http://www.blogjava.net/mgp1030/archive/2008/06/01/205149.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>mysql JDBC编程URL说明</title><link>http://www.blogjava.net/mgp1030/archive/2008/06/01/205148.html</link><dc:creator>苍天之狼</dc:creator><author>苍天之狼</author><pubDate>Sun, 01 Jun 2008 07:08:00 GMT</pubDate><guid>http://www.blogjava.net/mgp1030/archive/2008/06/01/205148.html</guid><wfw:comment>http://www.blogjava.net/mgp1030/comments/205148.html</wfw:comment><comments>http://www.blogjava.net/mgp1030/archive/2008/06/01/205148.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/mgp1030/comments/commentRss/205148.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/mgp1030/services/trackbacks/205148.html</trackback:ping><description><![CDATA[<p>jdbc url参数说明 <br />
url格式：jdbc:mysql://[hostname][:port]/dbname[?param1=value1][?m2=value2]... <br />
参数名 取值 缺省 <br />
user 数据库用户名 无 <br />
password 数据库用户口令 无 <br />
autoReconnect 当数据库连接丢失时是否自动连接，取值true/false false <br />
maxReconnects 如果autoReconnect为true,此参数为重试次数，缺省为3次 3 <br />
initialTimeout 如果autoReconnect为true,此参数为重新连接前等待的秒数 2 <br />
maxRows 设置查询时返回的行数，0表示全部 0 <br />
useUnicode 是否使用unicode输出，true/false false <br />
characterEncoding 如果useUnicode,该参数制定encoding类型，建议使用iso8859-1无</p>
<p>提示 <br />
同时使用useUnicode,characterEncoding,能解决数据库输出时的中文问题 <br />
如:jdbc:mysql://localhost/test?user=root&amp;useUnicode=true;characterEncoding=iso-8859-1</p>
<img src ="http://www.blogjava.net/mgp1030/aggbug/205148.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/mgp1030/" target="_blank">苍天之狼</a> 2008-06-01 15:08 <a href="http://www.blogjava.net/mgp1030/archive/2008/06/01/205148.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>