|NO.Z.00102|——————————|BigDataEnd|——|Java&MySQL.数据库连接池和DBUtils.V11|——|MySQL.v12|Druid连接池工具类测试|
一、测试工具类
### --- 测试工具类
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-php"><span class="hljs-keyword">public</span> <span class="hljs-class"><span class="hljs-keyword">class</span> <span class="hljs-title">TestDruid</span> </span>{
<span class="hljs-comment">// 需求 查询 薪资在3000 到 5000之间的员工的姓名</span>
<span class="hljs-keyword">public</span> <span class="hljs-built_in">static</span> <span class="hljs-keyword">void</span> <span class="hljs-title function_ invoke__">main</span>(String[] args) throws SQLException {
<span class="hljs-comment">//1.获取连接</span>
Connection con = DruidUtils.<span class="hljs-title function_ invoke__">getConnection</span>();
<span class="hljs-comment">//2.获取Statement对象</span>
Statement statement = con.<span class="hljs-title function_ invoke__">createStatement</span>();
<span class="hljs-comment">//3.执行查询</span>
ResultSet resultSet = statement.<span class="hljs-title function_ invoke__">executeQuery</span>(<span class="hljs-string">"select ename from employee where salary
between 3000 and 5000"</span>);
<span class="hljs-comment">//4.处理结果集</span>
<span class="hljs-keyword">while</span>(resultSet.<span class="hljs-title function_ invoke__">next</span>()){
String ename = resultSet.<span class="hljs-title function_ invoke__">getString</span>(<span class="hljs-string">"ename"</span>);
System.out.<span class="hljs-title function_ invoke__">println</span>(ename);
}
<span class="hljs-comment">//5.释放资源</span>
DruidUtils.<span class="hljs-title function_ invoke__">close</span>(con,statement,resultSet);
}
}</code></pre>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">二、sql语句</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-java"><span class="hljs-keyword">package</span> com.yanqi.testpool;
<span class="hljs-keyword">import</span> com.yanqi.utils.DruidUtils;
<span class="hljs-keyword">import</span> java.sql.Connection;
<span class="hljs-keyword">import</span> java.sql.ResultSet;
<span class="hljs-keyword">import</span> java.sql.SQLException;
<span class="hljs-keyword">import</span> java.sql.Statement;
<span class="hljs-keyword">public</span> <span class="hljs-keyword">class</span> <span class="hljs-title class_">TestDruid</span> {
<span class="hljs-comment">// 需求 查询 薪资在3000 到 5000之间的员工的姓名</span>
<span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> <span class="hljs-keyword">void</span> <span class="hljs-title function_">main</span><span class="hljs-params">(String[] args)</span> <span class="hljs-keyword">throws</span> SQLException {
<span class="hljs-comment">//1.获取连接</span>
<span class="hljs-type">Connection</span> <span class="hljs-variable">con</span> <span class="hljs-operator">=</span> DruidUtils.getConnection();
<span class="hljs-comment">//2.获取Statement对象</span>
<span class="hljs-type">Statement</span> <span class="hljs-variable">statement</span> <span class="hljs-operator">=</span> con.createStatement();
<span class="hljs-comment">//3.执行查询</span>
<span class="hljs-type">ResultSet</span> <span class="hljs-variable">resultSet</span> <span class="hljs-operator">=</span> statement.executeQuery(<span class="hljs-string">"select ename from employee where salary between 3000 and 5000"</span>);
<span class="hljs-comment">//4.处理结果集</span>
<span class="hljs-keyword">while</span>(resultSet.next()){
<span class="hljs-type">String</span> <span class="hljs-variable">ename</span> <span class="hljs-operator">=</span> resultSet.getString(<span class="hljs-string">"ename"</span>);
System.out.println(ename);
}
<span class="hljs-comment">//5.释放资源</span>
DruidUtils.close(con,statement,resultSet);
}
}</code></pre>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div><span style="font-family: 微软雅黑"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">三、编译打印</span></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-swift"><span class="hljs-type">D</span>:\<span class="hljs-type">JAVA</span>\jdk<span class="hljs-operator">-</span><span class="hljs-number">11.0</span>.<span class="hljs-number">2</span>\bin\java.exe <span class="hljs-string">"-javaagent:D:\IntelliJIDEA\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar=63441:D:\IntelliJIDEA\IntelliJ IDEA 2019.3.3\bin"</span> <span class="hljs-operator">-</span><span class="hljs-type">Dfile</span>.encoding<span class="hljs-operator">=</span><span class="hljs-type">UTF</span><span class="hljs-operator">-</span><span class="hljs-number">8</span> <span class="hljs-operator">-</span>classpath <span class="hljs-string">"E:\NO.Z.10000——javaproject\NO.H.00002.mysql\mysql\out\production\mysql.jdbc_task06;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\dom4j-1.6.1.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\druid-1.0.9.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\c3p0-0.9.5.2.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\commons-dbcp-1.4.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\jaxen-1.1-beta-6.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\commons-pool-1.5.6.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\commons-dbutils-1.6.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\mchange-commons-java-0.2.12.jar;F:\NO.Z.02000——soft——IT.实验\20210801——Hadoop\20210801.2——Hadoop——第二阶段——预科班\预科班第二阶段模块一<span class="hljs-subst">\0</span>5 任务五 (JDBC)<span class="hljs-subst">\0</span>3_软件\myJar\mysql-connector-java-5.1.37-bin.jar"</span> com.yanqi.testpool.<span class="hljs-type">TestDruid</span>
<span class="hljs-number">8</span>月 <span class="hljs-number">05</span>, <span class="hljs-number">2021</span> <span class="hljs-number">10</span>:<span class="hljs-number">17</span>:<span class="hljs-number">33</span> 下午 com.alibaba.druid.pool.<span class="hljs-type">DruidDataSource</span> info
信息: {dataSource<span class="hljs-operator">-</span><span class="hljs-number">1</span>} inited
李清照
林黛玉
李白
<span class="hljs-type">Process</span> finished with exit code <span class="hljs-number">0</span></code></pre>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div><hr style="font-family: 微软雅黑"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div>
<div style="text-align: left"><span style="font-family: 微软雅黑"><span style="font-family: 微软雅黑; color: rgba(255, 0, 0, 1)" data-wiz-span="data-wiz-span"> </span></span></div>
<div style="text-align: left"><span data-wiz-span="data-wiz-span"> </span></div>
<hr style="text-align: left">Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart</div>
<div> ——W.S.Landor</div>
<div><hr></div>
<div> </div>