|NO.Z.00108|——————————|BigDataEnd|——|Java&MySQL.数据库连接池和DBUtils.V17|——|MySQL.v18|mysql元数据|
一、MySql 元数据
### --- MySql元数据
~~~ <span class="hljs-selector-attr">[JDBC获取数据库元数据信息]</span>——<span class="hljs-selector-attr">[JDBC获取结果集元数据信息]</span></code></pre>
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-sql">### <span class="hljs-comment">--- 什么是元数据</span>
<span class="hljs-operator">~</span><span class="hljs-operator">~</span><span class="hljs-operator">~</span> # 除了表之外的数据都是元数据,可以分为三类
——<span class="hljs-operator">></span> 查询结果信息： <span class="hljs-keyword">UPDATE</span> 或 <span class="hljs-keyword">DELETE</span>语句 受影响的记录数。
——<span class="hljs-operator">></span> 数据库和数据表的信息： 包含了数据库及数据表的结构信息。
——<span class="hljs-operator">></span> MySQL服务器信息： 包含了数据库服务器的当前状态，版本号等。</code></pre>
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-lua">### <span class="hljs-comment">--- 常用命令</span>
<span class="hljs-comment">-- 元数据相关的命令介绍</span>
<span class="hljs-comment">-- 1.查看服务器当前状态</span>
<span class="hljs-comment">-- 2.查看MySQl的版本信息</span>
<span class="hljs-comment">-- 3.查询表中的详细信息</span>
<span class="hljs-comment">-- 4.显示数据表的详细索引信息</span>
<span class="hljs-comment">-- 5.列出所有数据库</span>
<span class="hljs-comment">-- 6.显示当前数据库的所有表</span>
<span class="hljs-comment">-- 7.获取当前的数据库名</span></code></pre>
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-sql"><span class="hljs-operator">~</span><span class="hljs-operator">~</span><span class="hljs-operator">~</span> <span class="hljs-keyword">select</span> version(); 获取mysql服务器的版本信息
<span class="hljs-operator">~</span><span class="hljs-operator">~</span><span class="hljs-operator">~</span> <span class="hljs-keyword">show</span> status; 查看服务器的状态信息
<span class="hljs-operator">~</span><span class="hljs-operator">~</span><span class="hljs-operator">~</span> <span class="hljs-keyword">show</span> columns <span class="hljs-keyword">from</span> table_name; 显示表的字段信息等，和<span class="hljs-keyword">desc</span> table_name一样
<span class="hljs-operator">~</span><span class="hljs-operator">~</span><span class="hljs-operator">~</span> <span class="hljs-keyword">show</span> index <span class="hljs-keyword">from</span> table_name; 显示数据表的详细索引信息，包括<span class="hljs-keyword">PRIMARY</span> KEY（主键）
——<span class="hljs-operator">></span> <span class="hljs-keyword">show</span> databases:列出所有数据库
——<span class="hljs-operator">></span> <span class="hljs-keyword">show</span> tables : 显示当前数据库的所有表
——<span class="hljs-operator">></span> <span class="hljs-keyword">select</span> database(): 获取当前的数据库名</code></pre>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div><img src="http://masterfile.aigcbbs.cn/Fnhe2hxArA0z7VxZGP0-RcNlh-x-" width="1060" height="117" style="font-family: 微软雅黑" class="medium-zoom-image"></div>
</div>
<div>
<div>
<div><img src="http://masterfile.aigcbbs.cn/FiqaDfY4dfdmn7V-gkfMZBhcy0Dp" style="font-family: 微软雅黑" class="medium-zoom-image"></div>
</div>
</div>
<div><img src="http://masterfile.aigcbbs.cn/FuY-GPp0Vy1y2xF1XgXGufoFEcec" style="font-family: 微软雅黑" class="medium-zoom-image"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span"><br></span></div>
<div>
<div>
<div><img src="http://masterfile.aigcbbs.cn/FgyyzcO3zHQppgfFijEolR1o8a6g" style="font-family: 微软雅黑" class="medium-zoom-image"></div>
</div>
</div>
<div><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">二、使用JDBC 获取元数据<br></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-shell"><span class="hljs-meta">#</span><span class="language-bash"><span class="hljs-comment">## --- 使用JDBC 获取元数据</span></span>
——> 通过JDBC 也可以获取到元数据,比如数据库的相关信息,
——> 或者当我们使用程序查询一个不熟悉的表时, 我们可以通过获取元素据信息,
——> 了解表中有多少个字段,字段的名称 和 字段的类型</code></pre>
</div>
<div data-mode="JavaScript" data-theme="default">
<pre class="highlighter-hljs" highlighted="true"><code class="highlighter-hljs hljs language-bash"><span class="hljs-comment">### --- 常用类介绍</span>
~~~ <span class="hljs-comment"># JDBC中描述元数据的类</span>
~~~ <span class="hljs-comment"># 获取元数据对象的方法 : getMetaData ()</span>
——> connection 连接对象, 调用 getMetaData () 方法,获取的是DatabaseMetaData 数据库元数据对象
——> PrepareStatement 预处理对象调用 getMetaData () , 获取的是ResultSetMetaData , 结果集元数据对象
——> DatabaseMetaData的常用方法</code></pre>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="wiz-table-container" style="position: relative; padding: 0">
<div class="wiz-table-body">
<div class="table-wrapper"><table>
<tbody>
<tr>
<td style="width: 216px" rowspan="1" colspan="1"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">元数据类</span></td>
<td style="width: 535px" rowspan="1" colspan="1"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">作用</span></td>
</tr>
<tr>
<td style="width: 216px" rowspan="1" colspan="1"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">DatabaseMetaData </span></td>
<td style="width: 535px" rowspan="1" colspan="1"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">描述数据库的元数据对象</span></td>
</tr>
<tr>
<td style="width: 216px" rowspan="1" colspan="1"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">ResultSetMetaData</span></td>
<td style="width: 535px" rowspan="1" colspan="1"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span"> 描述结果集的元数据对象</span></td>
</tr>
</tbody>
</table></div>
</div>
</div>
<div class="wiz-table-container" style="position: relative; padding: 0">
<div class="wiz-table-body">
<div class="table-wrapper"><table style="width: 752px">
<tbody>
<tr>
<td style="width: 751px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">方法说明</span></td>
</tr>
<tr>
<td style="width: 751px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getURL() : 获取数据库的URL</span></td>
</tr>
<tr>
<td style="width: 751px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getUserName(): 获取当前数据库的用户名</span></td>
</tr>
<tr>
<td style="width: 751px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getDatabaseProductName(): 获取数据库的产品名称</span></td>
</tr>
<tr>
<td style="width: 751px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getDatabaseProductVersion(): 获取数据的版本号</span></td>
</tr>
<tr>
<td style="width: 751px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getDriverName(): 返回驱动程序的名称</span></td>
</tr>
<tr>
<td style="width: 751px"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">isReadOnly(): 判断数据库是否只允许只读 true 代表只读</span></td>
</tr>
</tbody>
</table></div>
</div>
</div>
<div><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span"> </span></div>
<div class="wiz-table-container" style="position: relative; padding: 0">
<div class="wiz-table-body">
<div class="table-wrapper"><table style="width: 748px">
<tbody>
<tr>
<td style="width: 747px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">方法说明：ResultSetMetaData的常用方法</span></td>
</tr>
<tr>
<td style="width: 747px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getColumnCount() : 当前结果集共有多少列</span></td>
</tr>
<tr>
<td style="width: 747px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getColumnName(int i) : 获取指定列号的列名, 参数是整数 从1开始</span></td>
</tr>
<tr>
<td style="width: 747px" align="left" valign="middle"><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">getColumnTypeName(int i): 获取指定列号列的类型, 参数是整数 从1开始</span></td>
</tr>
</tbody>
</table></div>
</div>
</div>
<div>
<div><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-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-java"><span class="hljs-keyword">public</span> <span class="hljs-keyword">class</span> <span class="hljs-title class_">TestMetaData</span> {
<span class="hljs-comment">//1.获取数据库相关的元数据信息 使用DatabaseMetaData</span>
<span class="hljs-meta">@Test</span>
<span class="hljs-keyword">public</span> <span class="hljs-keyword">void</span> <span class="hljs-title function_">testDataBaseMetaData</span><span class="hljs-params">()</span> <span class="hljs-keyword">throws</span> SQLException {
<span class="hljs-comment">//1.获取数据库连接对象 connection</span>
<span class="hljs-type">Connection</span> <span class="hljs-variable">connection</span> <span class="hljs-operator">=</span> DruidUtils.getConnection();
<span class="hljs-comment">//2.获取代表数据库的 元数据对象 DatabaseMetaData</span>
<span class="hljs-type">DatabaseMetaData</span> <span class="hljs-variable">metaData</span> <span class="hljs-operator">=</span> connection.getMetaData();
<span class="hljs-comment">//3.获取数据库相关的元数据信息</span>
<span class="hljs-type">String</span> <span class="hljs-variable">url</span> <span class="hljs-operator">=</span> metaData.getURL();
System.out.println(<span class="hljs-string">"数据库URL: "</span> + url);
<span class="hljs-type">String</span> <span class="hljs-variable">userName</span> <span class="hljs-operator">=</span> metaData.getUserName();
System.out.println(<span class="hljs-string">"当前用户: "</span> + userName );
<span class="hljs-type">String</span> <span class="hljs-variable">productName</span> <span class="hljs-operator">=</span> metaData.getDatabaseProductName();
System.out.println(<span class="hljs-string">"数据库产品名: "</span> + productName);
<span class="hljs-type">String</span> <span class="hljs-variable">version</span> <span class="hljs-operator">=</span> metaData.getDatabaseProductVersion();
System.out.println(<span class="hljs-string">"数据库版本: "</span> + version);
<span class="hljs-type">String</span> <span class="hljs-variable">driverName</span> <span class="hljs-operator">=</span> metaData.getDriverName();
System.out.println(<span class="hljs-string">"驱动名称: "</span> + driverName);
<span class="hljs-comment">//判断当前数据库是否只允许只读</span>
<span class="hljs-type">boolean</span> <span class="hljs-variable">b</span> <span class="hljs-operator">=</span> metaData.isReadOnly(); <span class="hljs-comment">//如果是 true 就表示 只读</span>
<span class="hljs-keyword">if</span>(b){
System.out.println(<span class="hljs-string">"当前数据库只允许读操作!"</span>);
}<span class="hljs-keyword">else</span>{
System.out.println(<span class="hljs-string">"不是只读数据库"</span>);
}
connection.close();
}
<span class="hljs-comment">//获取结果集中的元数据信息</span>
<span class="hljs-meta">@Test</span>
<span class="hljs-keyword">public</span> <span class="hljs-keyword">void</span> <span class="hljs-title function_">testResultSetMetaData</span><span class="hljs-params">()</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.获取预处理对象</span>
<span class="hljs-type">PreparedStatement</span> <span class="hljs-variable">ps</span> <span class="hljs-operator">=</span> con.prepareStatement(<span class="hljs-string">"select * from employee"</span>);
<span class="hljs-type">ResultSet</span> <span class="hljs-variable">resultSet</span> <span class="hljs-operator">=</span> ps.executeQuery();
<span class="hljs-comment">//3.获取结果集元素据对象</span>
<span class="hljs-type">ResultSetMetaData</span> <span class="hljs-variable">metaData</span> <span class="hljs-operator">=</span> ps.getMetaData();
<span class="hljs-comment">//1.获取当前结果集 共有多少列</span>
<span class="hljs-type">int</span> <span class="hljs-variable">count</span> <span class="hljs-operator">=</span> metaData.getColumnCount();
System.out.println(<span class="hljs-string">"当前结果集中共有: "</span> + count + <span class="hljs-string">" 列"</span>);
<span class="hljs-comment">//2.获结果集中 列的名称 和 类型</span>
<span class="hljs-keyword">for</span> (<span class="hljs-type">int</span> <span class="hljs-variable">i</span> <span class="hljs-operator">=</span> <span class="hljs-number">1</span>; i <= count; i++) {
<span class="hljs-type">String</span> <span class="hljs-variable">columnName</span> <span class="hljs-operator">=</span> metaData.getColumnName(i);
System.out.println(<span class="hljs-string">"列名: "</span>+ columnName);
<span class="hljs-type">String</span> <span class="hljs-variable">columnTypeName</span> <span class="hljs-operator">=</span> metaData.getColumnTypeName(i);
System.out.println(<span class="hljs-string">"类型: "</span> +columnTypeName);
}
<span class="hljs-comment">//释放资源</span>
DruidUtils.close(con,ps,resultSet);
}
}</code></pre>
</div>
<div>
<div>
<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>
</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.testmetadata;
<span class="hljs-keyword">import</span> com.yanqi.utils.DruidUtils;
<span class="hljs-keyword">import</span> org.junit.Test;
<span class="hljs-keyword">import</span> java.sql.*;
<span class="hljs-keyword">public</span> <span class="hljs-keyword">class</span> <span class="hljs-title class_">TestMetaData</span> {
<span class="hljs-comment">//1.获取数据库相关的元数据信息 使用DatabaseMetaData</span>
<span class="hljs-meta">@Test</span>
<span class="hljs-keyword">public</span> <span class="hljs-keyword">void</span> <span class="hljs-title function_">testDataBaseMetaData</span><span class="hljs-params">()</span> <span class="hljs-keyword">throws</span> SQLException {
<span class="hljs-comment">//1.获取数据库连接对象 connection</span>
<span class="hljs-type">Connection</span> <span class="hljs-variable">connection</span> <span class="hljs-operator">=</span> DruidUtils.getConnection();
<span class="hljs-comment">//2.获取代表数据库的 元数据对象 DatabaseMetaData</span>
<span class="hljs-type">DatabaseMetaData</span> <span class="hljs-variable">metaData</span> <span class="hljs-operator">=</span> connection.getMetaData();
<span class="hljs-comment">//3.获取数据库相关的元数据信息</span>
<span class="hljs-type">String</span> <span class="hljs-variable">url</span> <span class="hljs-operator">=</span> metaData.getURL();
System.out.println(<span class="hljs-string">"数据库URL: "</span> + url);
<span class="hljs-type">String</span> <span class="hljs-variable">userName</span> <span class="hljs-operator">=</span> metaData.getUserName();
System.out.println(<span class="hljs-string">"当前用户: "</span> + userName );
<span class="hljs-type">String</span> <span class="hljs-variable">productName</span> <span class="hljs-operator">=</span> metaData.getDatabaseProductName();
System.out.println(<span class="hljs-string">"数据库产品名: "</span> + productName);
<span class="hljs-type">String</span> <span class="hljs-variable">version</span> <span class="hljs-operator">=</span> metaData.getDatabaseProductVersion();
System.out.println(<span class="hljs-string">"数据库版本: "</span> + version);
<span class="hljs-type">String</span> <span class="hljs-variable">driverName</span> <span class="hljs-operator">=</span> metaData.getDriverName();
System.out.println(<span class="hljs-string">"驱动名称: "</span> + driverName);
<span class="hljs-comment">//判断当前数据库是否只允许只读</span>
<span class="hljs-type">boolean</span> <span class="hljs-variable">b</span> <span class="hljs-operator">=</span> metaData.isReadOnly(); <span class="hljs-comment">//如果是 true 就表示 只读</span>
<span class="hljs-keyword">if</span>(b){
System.out.println(<span class="hljs-string">"当前数据库只允许读操作!"</span>);
}<span class="hljs-keyword">else</span>{
System.out.println(<span class="hljs-string">"不是只读数据库"</span>);
}
connection.close();
}
<span class="hljs-comment">//获取结果集中的元数据信息</span>
<span class="hljs-meta">@Test</span>
<span class="hljs-keyword">public</span> <span class="hljs-keyword">void</span> <span class="hljs-title function_">testResultSetMetaData</span><span class="hljs-params">()</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.获取预处理对象</span>
<span class="hljs-type">PreparedStatement</span> <span class="hljs-variable">ps</span> <span class="hljs-operator">=</span> con.prepareStatement(<span class="hljs-string">"select * from employee"</span>);
<span class="hljs-type">ResultSet</span> <span class="hljs-variable">resultSet</span> <span class="hljs-operator">=</span> ps.executeQuery();
<span class="hljs-comment">//3.获取结果集元素据对象</span>
<span class="hljs-type">ResultSetMetaData</span> <span class="hljs-variable">metaData</span> <span class="hljs-operator">=</span> ps.getMetaData();
<span class="hljs-comment">//1.获取当前结果集 共有多少列</span>
<span class="hljs-type">int</span> <span class="hljs-variable">count</span> <span class="hljs-operator">=</span> metaData.getColumnCount();
System.out.println(<span class="hljs-string">"当前结果集中共有: "</span> + count + <span class="hljs-string">" 列"</span>);
<span class="hljs-comment">//2.获结果集中 列的名称 和 类型</span>
<span class="hljs-keyword">for</span> (<span class="hljs-type">int</span> <span class="hljs-variable">i</span> <span class="hljs-operator">=</span> <span class="hljs-number">1</span>; i <= count; i++) {
<span class="hljs-type">String</span> <span class="hljs-variable">columnName</span> <span class="hljs-operator">=</span> metaData.getColumnName(i);
System.out.println(<span class="hljs-string">"列名: "</span>+ columnName);
<span class="hljs-type">String</span> <span class="hljs-variable">columnTypeName</span> <span class="hljs-operator">=</span> metaData.getColumnTypeName(i);
System.out.println(<span class="hljs-string">"类型: "</span> +columnTypeName);
}
<span class="hljs-comment">//释放资源</span>
DruidUtils.close(con,ps,resultSet);
}
}</code></pre>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div><span style="font-family: 微软雅黑" data-wiz-span="data-wiz-span">五、打印输出</span></div>
</div>
</div>
</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-operator">-</span>ea <span class="hljs-operator">-</span><span class="hljs-type">Didea</span>.test.cyclic.buffer.size<span class="hljs-operator">=</span><span class="hljs-number">1048576</span> <span class="hljs-string">"-javaagent:D:\IntelliJIDEA\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar=62503: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">"D:\IntelliJIDEA\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar;D:\IntelliJIDEA\IntelliJ IDEA 2019.3.3\plugins\junit\lib\junit5-rt.jar;D:\IntelliJIDEA\IntelliJ IDEA 2019.3.3\plugins\junit\lib\junit-rt.jar;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;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org<span class="hljs-subst">\t</span>estng<span class="hljs-subst">\t</span>estng\6.14.3<span class="hljs-subst">\t</span>estng-6.14.3.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\com\beust\jcommander\1.72\jcommander-1.72.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\apache-extras\beanshell\bsh\2.0b6\bsh-2.0b6.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\junit\jupiter\junit-jupiter\5.4.2\junit-jupiter-5.4.2.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\junit\jupiter\junit-jupiter-api\5.4.2\junit-jupiter-api-5.4.2.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\apiguardian\apiguardian-api\1.0.0\apiguardian-api-1.0.0.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\opentest4j\opentest4j\1.1.1\opentest4j-1.1.1.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\junit\platform\junit-platform-commons\1.4.2\junit-platform-commons-1.4.2.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\junit\jupiter\junit-jupiter-params\5.4.2\junit-jupiter-params-5.4.2.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\junit\jupiter\junit-jupiter-engine\5.4.2\junit-jupiter-engine-5.4.2.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\junit\platform\junit-platform-engine\1.4.2\junit-platform-engine-1.4.2.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\junit\junit\4.12\junit-4.12.jar;C:\Users\Administrator\.m2<span class="hljs-subst">\r</span>epository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar"</span> com.intellij.rt.junit.<span class="hljs-type">JUnitStarter</span> <span class="hljs-operator">-</span>ideVersion5 <span class="hljs-operator">-</span>junit4 com.yanqi.testmetadata.<span class="hljs-type">TestMetaData</span>,testDataBaseMetaData
<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">44</span>:<span class="hljs-number">52</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">URL</span>: jdbc:mysql:<span class="hljs-comment">//127.0.0.1:3306/db5?characterEncoding=UTF-8</span>
当前用户: root<span class="hljs-meta">@localhost</span>
数据库产品名: <span class="hljs-type">MySQL</span>
数据库版本: <span class="hljs-number">5.7</span>.<span class="hljs-number">28</span><span class="hljs-operator">-</span>log
驱动名称: <span class="hljs-type">MySQL</span> <span class="hljs-type">Connector</span> <span class="hljs-type">Java</span>
不是只读数据库
<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>
<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>
</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>