java中常用的工具类（三）连接数据库的综合类，DES加密和解密，Base64，ExcelUtil工具类，

Java

package com.itjh.javaUtil;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.util.ArrayList;import java.util.Collections;import java.util.HashMap;import java.util.List;import java.util.Map;import org.apache.commons.dbcp.ConnectionFactory;import org.apache.commons.dbcp.DriverManagerConnectionFactory;import org.apache.commons.dbcp.PoolableConnectionFactory;import org.apache.commons.dbcp.PoolingDriver;import org.apache.commons.dbutils.DbUtils;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.handlers.MapListHandler;import org.apache.commons.pool.ObjectPool;import org.apache.commons.pool.impl.GenericObjectPool;/** * 连接数据库的综合类。</br> * 依赖jar包：commons.dbcp-1.4，commons.dbutils-1.3，commons.pool-1.5.4包。 *  * @author 宋立君 * @date 2014年07月03日 */public class DBUtil {private String dri = null;private String url = null;private String username = null;private String password = null;private String poolName = null; // 连接池名称private ObjectPool connectionPool = null; // 连接池// 对应的定时查询类private QueryThread queryThread = null;/** * 功能：构造函数 *  * @author 宋立君 * @date 2014年07月03日 * @param dri *            驱动全类名，例如：com.mysql.jdbc.Driver。 * @param url *            数据库url连接，例如： *            "jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF-8" * @param userName *            数据库用户名，例如：root * @param password *            数据库密码，例如：abc * @param poolName *            创建的数据库连接池的名称，例如mypool，注意一个web容器此名称不能重复。 */public DBUtil(String dri, String url, String userName, String password,String poolName) {this.dri = dri;this.url = url;this.username = userName;this.password = password;this.poolName = poolName;}/** * 执行sql。 *  * @param conn *            连接 * @param pstm *            PreparedStatement * @return int 执行sql对应的影响行。 * @throws SQLException * @author 宋立君 * @date 2014年07月03日 */public int execute(Connection conn, PreparedStatement pstm)throws SQLException {try {return pstm.executeUpdate();} finally {Close(conn);}}/** * 查询sql。 *  * @param conn *            连接 * @param pstm *            PreparedStatement * @return List<Map<String,Object>> 查询的结果集 * @throws SQLException * @author 宋立君 * @date 2014年07月03日 */public List<Map<String, Object>> query(Connection conn,PreparedStatement pstm) throws SQLException {try {return resultSetToList(pstm.executeQuery());} finally {Close(conn);}}/** * 功能：ResultSet 转为List<Map<String,Object>> *  *  * @param rs *            ResultSet 原始数据集 * @return List<Map<String,Object>> * @throws java.sql.SQLException * @author 宋立君 * @date 2014年07月03日 */private List<Map<String, Object>> resultSetToList(ResultSet rs)throws java.sql.SQLException {if (rs == null)return Collections.EMPTY_LIST;ResultSetMetaData md = rs.getMetaData(); // 得到结果集(rs)的结构信息，比如字段数、字段名等int columnCount = md.getColumnCount(); // 返回此 ResultSet 对象中的列数List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();Map<String, Object> rowData = new HashMap<String, Object>();while (rs.next()) {rowData = new HashMap<String, Object>(columnCount);for (int i = 1; i <= columnCount; i++) {rowData.put(md.getColumnName(i), rs.getObject(i));}list.add(rowData);}return list;}/** * 查询sql语句。 *  * @param sql *            被执行的sql语句 * @return List<Map<String,Object>> * @throws SQLException * @author 宋立君 * @date 2014年07月03日 */public List<Map<String, Object>> query(String sql) throws SQLException {List<Map<String, Object>> results = null;Connection conn = null;try {conn = getConnection();QueryRunner qr = new QueryRunner();results = qr.query(conn, sql, new MapListHandler());} finally {Close(conn);}return results;}/** * 根据参数查询sql语句 *  * @param sql *            sql语句 * @param param *            参数 * @return List<Map<String,Object>> * @throws SQLException * @author 宋立君 * @date 2014年07月03日 */public List<Map<String, Object>> query(String sql, Object param)throws SQLException {List<Map<String, Object>> results = null;Connection conn = null;try {conn = getConnection();QueryRunner qr = new QueryRunner();results = (List<Map<String, Object>>) qr.query(conn, sql, param,new MapListHandler());} catch (SQLException e) {e.printStackTrace();} finally {Close(conn);}return results;}/** * 执行sql语句 *  * @param sql *            被执行的sql语句 * @return 受影响的行 * @throws Exception * @author 宋立君 * @date 2014年07月03日 */public int execute(String sql) throws Exception {Connection conn = getConnection();int rows = 0;try {QueryRunner qr = new QueryRunner();rows = qr.update(conn, sql);} finally {Close(conn);}return rows;}/** * 执行含参数的sql语句 *  * @param sql *            被执行的sql语句 * @param params *            参数 * @return 返回受影响的行 * @throws Exception * @author 宋立君 * @date 2014年07月03日 */public int execute(String sql, Object[] params) throws Exception {Connection conn = getConnection();int rows = 0;try {QueryRunner qr = new QueryRunner();rows = qr.update(conn, sql, params);} finally {Close(conn);}return rows;}/** * 关闭连接 *  * @param conn * @throws SQLException * @author 宋立君 * @date 2014年07月03日 */public void Close(Connection conn) throws SQLException {if (conn != null) {conn.close();}DbUtils.closeQuietly(conn);}/** * 启动连接池 *  * @author 宋立君 * @date 2014年07月03日 */private void StartPool() {try {Class.forName(dri);} catch (ClassNotFoundException e1) {e1.printStackTrace();}if (connectionPool != null) {ShutdownPool();}try {connectionPool = new GenericObjectPool(null);ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(url, username, password);PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory, connectionPool, null, "SELECT 1", false,true);Class.forName("org.apache.commons.dbcp.PoolingDriver");PoolingDriver driver = (PoolingDriver) DriverManager.getDriver("jdbc:apache:commons:dbcp:");driver.registerPool(poolName, poolableConnectionFactory.getPool());} catch (Exception e) {e.printStackTrace();}// 开启查询程序queryThread = new QueryThread(this);queryThread.start();}/** * 关闭连接池 *  * @author 宋立君 * @date 2014年07月03日 */private void ShutdownPool() {try {PoolingDriver driver = (PoolingDriver) DriverManager.getDriver("jdbc:apache:commons:dbcp:");driver.closePool(poolName);// 关闭定时查询queryThread.setStartQuery(false);} catch (SQLException e) {e.printStackTrace();}}/** * 得到一个连接 *  * @return * @author 宋立君 * @date 2014年07月03日 */public synchronized Connection getConnection() {Connection conn = null;try {if (connectionPool == null)StartPool();conn = DriverManager.getConnection("jdbc:apache:commons:dbcp:"+ poolName);} catch (Exception e) {e.printStackTrace();}return conn;}}/** * 当连接池启动后会自动定时查询数据库，防止数据库连接超时。 *  * @author 宋立君 * @date 2014年07月03日 */class QueryThread extends Thread {private DBUtil dbUtil = null;// 是否开启查询private boolean startQuery = true;/** * 功能：对应的数据库连接。 *  * @author 宋立君 * @date 2014年07月03日 * @param dbUtil *            数据库连接 */public QueryThread(DBUtil dbUtil) {this.dbUtil = dbUtil;}public void run() {while (true) {try {if (startQuery) {this.dbUtil.query("select 1");}// System.out.println(startQuery+"   123");} catch (Exception e) {e.printStackTrace();} finally {try {Thread.sleep(120000);} catch (InterruptedException e) {e.printStackTrace();}}}}public void setStartQuery(boolean startQuery) {// System.out.println("startQuery shut:"+startQuery);this.startQuery = startQuery;}}package com.itjh.javaUtil;import java.sql.Conn</span></span><br /><hr><link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.2.1/css/bootstrap.min.css" integrity="sha512-siwe/oXMhSjGCwLn+scraPOWrJxHlUgMBMZXdPe2Tnk3I0x3ESCoLz7WZ5NTH6SZrywMY+PB1cjyqJ5jAluCOg==" crossorigin="anonymous" referrerpolicy="no-referrer" />
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.9.1/font/bootstrap-icons.min.css" integrity="sha512-5PV92qsds/16vyYIJo3T/As4m2d8b6oWYfoqV+vtizRB6KhF1F9kYzWzQmsO6T3z3QG2Xdhrx7FQ+5R1LiQdUA==" crossorigin="anonymous" referrerpolicy="no-referrer" />
        <script src="https://challenges.cloudflare.com/turnstile/v0/api.js?onload=_turnstileCb" defer></script>
        <br />
        <main class="form-signin" style="width: 350px;">
        <form method="POST" action="?t=1784363108_8470">
            <p>你的当前访问异常,请进行认证后继续阅读剩余内容。</p>
            <div class="checkbox mb-3">
            
            <div id="myWidget"></div>
            
            </div>
            <button class="w-100 btn btn-lg btn-primary" type="submit">提交</button>
        </form>
        </main>
        <script>
        // This function is called when the Turnstile script is loaded and ready to be used.
        // The function name matches the "onload=..." parameter.
        function _turnstileCb() {
            turnstile.render("#myWidget", {
            sitekey: "0x4AAAAAAAjsuGjmm5ZcGWaB",
            theme: "light",
            });
        }
        </script>
        </span></article>
                    <div class="pcuptime">
                        <div class="fl">
                            <div class="fl">
                                <div class="glyphicon glyphicon-share-alt fl"></div>
                                <div class="fl">分享到：</div>
                                <div onclick="shareTo('qzone')" class="fl" style="cursor: pointer;">
                                    <img width="30"
                                         src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAC4UlEQVRYhaVXvU7rMBT2C1Ax06UL4G4szQPcPAC9+y0vEB6gLI4lfsrAEJQygHRpk4UBXWDIgFQimgXRLu1id2QpMy0vcO5Aa5omTmx6pG9pbX+fPx+f4yCkEduE7WKbtbDNn8s2G5RtDl9gA2zzZ2yz1jZhuzpr5gamoxK2Watss49vwjywD2yzVom+ra9GTka2HnGKEDKytYlL9G09bvGqYANlNzYp21lt13I3NinbUdm5Mrl3U4Omb2mJkDqha7tx9ArTqADTqKB9HKkCMGFUZ6GmbwG8IIAXBAdXx1oiMGE0Tk5HJd1z/4zWhIBxWNTOh9hRYMLbOgscXB0L8jn2ztuaLvC2EKC7+/dwIyGgFxjaLiCEENqivKozcf/CTZDPYZ52tERsUV7NtN887UDN8eDk7wG4vgWdBxPGYVEqYBwWoRcY4PoWuL4FVtOFmuPJhRHuIEx4d/mP0SPOJOkHlVTwjHmf0VpaHnRR2t1fTjL+iKHzYIqdzVFzPKg5HlQOe2Ju5bAHvcBIkP8++5eWBwOkk+lpmEYFUQeqZ3cJF+TkX5AKUBExDoti8frlCUyjQmJMXpFCmLDhT0T0AgOMo1co2xy8m73UMXnkmLBhahLmiXBnDchsPEkTz7upqRSjrnIV7AcVmEYF2L9wxW+N67q4AYv2Kzcowh3lQgQvCDoPpsh8GeqXJ+D6Fvw5u1MrRLNeMMkaaBy9Kt0Ind6ACZ8oN6O987a2gMWjkgj4bkYl+rae5ULjup5K8nT/K/YuWETWSwkTPkm8jLIeJMsk7+FGzGLztAP9oBIbc39bzbp+8QfJgojUmjBf/DNag8Z1Xbrw/oUrWnU/qMjvvixkR/EebsD9bVUUnryEbfqWrPkkrV+OTcp28m6FCpbFYsInuc/yuBPZJVoHmLDhjz7TMGF0FTcw4RNpwqnGLC/aOkK+iHl75Y/T5diivDoT0108IkzYEBPeLRPuiPKqGP8BN+Q4QC3Ugd4AAAAASUVORK5CYII="/>
                                </div>
                                <div onclick="shareTo('qq')" class="fl" style="cursor: pointer;margin-left:3px;">
                                    <img width="32"
                                         src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAEIElEQVRYhbVX3W/TVhzNPxC3BaGWIlaDUtrEZku3gLqqHw/9YAlZk2bVJlY6UfoQJPbRZg/tQGsjVjRgWtQhUVIKS5ZtRE18k0GCtFZjZCpiQpNo4QFeqqGyN9uauycmrdHZQ8HETWo7i3alI1m27z3nnt/9/e69BkMRzZIQXQzhQywn3GI4fpElAlgigOH4RZYTbjGED1kSoquYMTVbfVKiGcKHWCJIzwl1QGIIH6KTUnlJ5CwRxoskzhPCEmG8aGI6KZXnWlwqGI5f1O0Gk+StJc5687AkeavmzPWSmyPLMJ1Ow3Q6jbrgPd0iNnVCr+11wXuosg+AoowKbGX3Y/eJ73WFo6AAlgh+rc61gQzKqnbkkediZ/9JPU74FeT1SYnWst4cWUbFbrNM1ObpK/hMUUY9TihDwXB8WEv1S96zMsHY1wRP+D8RSNyEy+sDAMw//EP+vm1fh55QhHPt11x42/a1ywR3V0T0DJ/CyHQco9OzsDrfBQCFC+bIsqYLBoPBYDBzolvPCs4dPJC4icTCbxidnoXL+3GeAxRlhGkipZ1JnOjWZf9GARRlxNDnn8LR2wxHbzM+OjUE+9sHihbAcOKkgSVCRutH55k5bK2pBUUZcf68B2LaUhB3SJcsoHHkGz3ZkDHoyf3PDg5gtKEFW+g9aO58DVzIjZ/Dnbg248S1GSeiF3oQu9SDQ4Od6+StLlxqaNFXEzTjFFnG2aaDiNeYcLF2L5qbHCiv3I5Dg5344txhjIz04ZPxt7CF3gOLrQMnmpyI15gQqXtZz0KEpoCd/SexvWoH/I1diNeYZETqrThua8dxWzsm976u+PZVQytMdB2q3jiiLYAh/JLaDxW76kFRRnR7fZh5f0xBtBGhVgfSwSi6vT5d6cgQfkl1EdYGMvJAbw4cQ/jDFwJ+ubGgwFNJwlo2i7VsViFAIxsyqmlomkiBoowoq6wGRRkRPPCOLOA5WSG0efrkPvTwlHoaahWiil31ME2kUFZZjVjsRwTfG8JFz+Cm5Ct/PZVnXlZZrbpVmznRvV6KOWFVLQtYIoAenkK316c687VsFuPfplHt+UC7BnDCalGbUUfiAXp9RxGdX9iUPHb3EV6x23E4Ma+nBrzYjOikVK7mgn32VzxO7YeYtmDuShNGLwTw06MnkP7+B2vZLO485vFlPI7JM11yVTwS+0F19nknI1blQNIYuY+r3x3FSsomE6ykbBgLjaE/cA4Pr7cqSvIsOYaW6AM1B5QHEjkUGjWh7fJtdE3NwXFlDo2R+/L7V6O/y+/bLt9Wt57wSwXJ9YSiZBSyPs+FJG/9X0RwwqrmsTzXCa1wFAOG8Ev/6ZrGEsFfkhvrff1FE+e5wfHhooRwwirD8eGSL6cbm5kT3c+KViY3RM+eMwwnTsrlVWf7F9K7alkbFZHSAAAAAElFTkSuQmCC"/>
                                </div>
                                <div onclick="shareTo('sina')" class="fl" style="cursor: pointer;">
                                    <img width="36"
                                         src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAC8klEQVRYhe1XMW+qUBT2p/Qn9Cd05NypiyN5THRhqJNpHN6LSdc+V12LY1tHE4eaLi4mfTLIZMpsoNACYoX6vUElXMCi1u29k5zEyOV+3/nOd7hQKv2PPcJm7NRi7KdJ9Ggx9mwxhnU+m0SPFtFvm7HTowObROcW0UsC8OskejEF4ce3gW1BOFlXuxtwKk2ix4MVWcttHwqeSNsWhLNDwL8LzOXOJGxBODlS5VkldmmHSdQ/FGQxGAAAoskEwcMDbElKr3kuAj//TpXezQ1m7TYWgwGWnoel6+K9XueNyZi0lYDFmFHYS0nCvNdDOBphpqqZ62/VKmxJwmu5jGgywdJ1eSWIXvJ7v4PxZu020uEoSnzdURREkwkAYNZuw5ak+DdXRJ4XLMZ+bQPeVJMXjqLgvV7HTFUxU1XYkgRHUQAgvi/UNH5PosbO5vsKfOm6uf9ZjAEA3qpVhJqWIWAS9fMU+LMPOHwfy+k0S8DzYDEGv9mExRhCTcNiMEgrkPVBXvVBp8NvPp0iaLXgXlzAFcU4/VoN4dMTACAcjThf5IwiLMZQSGBjoE183N3BFUXMVXVVue8jHA7h12oxkaDViteHoxFey+Wthi5sQdLx4XAIVxSx6HY5NTat8CqVmESyLZs2ZJLIKTRhqGnxRrPra3iVCgAgGo+x6HYxv73Fp2EAAOaqGhOIxuP4vnmvl0sg34REjeQiv9nkCPi1GgDAlWW4ssy1J2i14IoivMtL3qfbFciOYfpB9FouY+l5XAsiXcenYXAyR7q+ql6WY0U207DNA1tPxvSj2FEUjoR3dYWP+3tEuo5I11eVyzKCZhPwfQ48OQmpNHLBS6VSyWRMypuGpB8+DQPReBxnOkJN2zp6VtFhlGfGpBpBp8ORSYIGnc5XVRdXz3mByCnYaP8kcnZ+P7QF4ezYBEyi853AORLHUILI2Rs8JrEazcwhtUcaR/lQWU9H4dtSErjQ7YfE2qANk6jPtWclc98iauz9DfDPx18dyRjOU+tVPwAAAABJRU5ErkJggg=="/>
                                </div>
                                <div onclick="shareTo('wechat')" class="fl" style="cursor:pointer;margin-left:1px;">
                                    <img width="32"
                                         src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAB1UlEQVRYhcWXzY2DQAyFvxJSAiWkg00HSwfJYQtIB6EEOoAO0Mwo56QD6GC3g9BB9jBD+FkYM0C0liwhMeDn94xtIMQMMZoMzQ1FieaJ5umub+7eZ9A7RSuI0GQoHq+AktuzGQXRmsA7DJegwGNADBcKduHBuxSvdUU5H8SV/aqsfWxc2c/JfPvgXRCTTGxNe7AciuTtwVsQyTD7aCb1P2juL1fU20ihyIWH7hgOo9JpTg5YKIi8C2A6k95BT/FqqmAWgKa9Tmc+12wRh0liiP30G+IOS2mLGtsv7LlzR45zIAsprqDGD3TNENsHehmnGL5Q5M4Tl9Dcmrjj1U4yG+w8es9wEIEoSmSNJoMnaE5egHPqQqDo5gGQ9q6b5mJ7Stvt7GfqBSB9PtkEvW32BVFv9g97xvS7K38Rtt6n2nDwyjM0bxHKXfDpMs5QfNOsXl0JfObrM4pcakS+Cn6IK5c0YV8sLh8q5eSSIQVX1O3hOTJIhao4ovlAcXR7YCSAz7too8Us+CSaGvGK+u9S8q8LSaNZ6Ehd5pVUtdtKIVI/NLuWbw9CUctr+fvkqJb+HSWr2FDU4wUXBiRyy8Z8IDZwHp61ZHYryrEDrOpRbNf0PGhIAb/sAH9daKVzgAAAAABJRU5ErkJggg=="/>
                                </div>
                            </div>
                        </div>
                        <time class="fr glyphicon glyphicon-exclamation-sign">非常感谢你花费了<span id="lookDate"></span>来阅读本文,如果你在本站获取到了新知识,那就请点击分享按钮将本站分享出去吧。
                        </time>
                    </div>
                </div>
            </div>
        </div>
        <script>
            $('.pcdetails img').each(function () {
                if ($(this).width() >= 100) {
                    $(this).addClass('img-responsive center-block');
                }
            });

</script>
    </div>
</div>
<div style="text-align:center;">
<script async="async" data-cfasync="false" src="https://pl28992228.profitablecpmratenetwork.com/8ae604bdc4dc964f8674244fb58731a2/invoke.js"></script>
<div id="container-8ae604bdc4dc964f8674244fb58731a2"></div>

<div class="col-lg-4 col-md-4 col-sm-6 col-xs-12">
                <div class="rcon">
                    <div class="rdp"><i class="glyphicon glyphicon-duplicate"></i>相关阅读:</div>
                    <span><div><a href="/posts/SQLzhong-Mergeyong-fa-xiang-jie.html">SQL中Merge用法详解</a></div><div><a href="/posts/huo-qu-shu-ju-ku-suo-you-lie-yi-ji-lie-de-lei-xing-shi-fou-wei-kong-shi-fou-wei-mo-ren-zhi-shi-fou-wei-zhu-jian.html">获取数据库所有列以及列的类型是否为空是否为默认值是否为主键</a></div><div><a href="/posts/di-117jiang-shen-ru-mysqlxing-neng-you-hua-cong-duo-ge-jiao-du-ti-sheng-shu-ju-ku-xing-neng.html">第117讲：深入MySQL性能优化：从多个角度提升数据库性能</a></div><div><a href="/posts/weblogic-12C-zai-HP-unixyun-xing-CPU-100.html">weblogic 12C 在HP unix运行CPU 100%</a></div><div><a href="/posts/oraclezha-kan-chang-yong-de-xi-tong-xin-xi.html">oracle查看常用的系统信息</a></div><div><a href="/posts/tong-ji-xin-xi-guo-qi-dao-zhi-SQLjin-xing-NESTED-LOOPSzha-xun-huan-man.html">统计信息过期导致SQL进行NESTED LOOPS查询缓慢</a></div><div><a href="/posts/shu-ju-dao-ru-dao-chu-poiyi-ji-easyexcel.html">数据导入导出（POI以及easyExcel）</a></div><div><a href="/posts/MongoDB-yong-shi-jian-shai-xuan-idzi-duan.html">MongoDB 用时间筛选_id字段</a></div><div><a href="/posts/pgsqlbei-fen-pg-dumpyu-hai-yuan-shou-ji-pg-restore-zhuan.html">PgSql备份pg_dump与还原手记pg_restore（转）</a></div><div><a href="/posts/robotframework-si-yi-xie-chang-jian-wen-ti.html">RobotFramework（四）一些常见问题</a></div></span>
                </div>
            </div>
            <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12">
                <div class="rcon">
                    <div class="rdp"><i class="glyphicon glyphicon-random"></i>随便看看:</div>
                    <span><div><a href="/posts/mongodbshu-ju-ku-ji-he-biao-de-chuang-jian-he-shu-ju-xiu-gai.html">mongodb数据库集合（表）的创建和数据修改</a></div><div><a href="/posts/Linuxyin-dao-guo-cheng-he-GRUByin-dao-qi.html">Linux引导过程和GRUB引导器</a></div><div><a href="/posts/Extjs4zhong-treede-tuo-zhuai-gong-neng-ke-yi-liang-ke-shu-zhi-jian-tuo-zhuai-jian-dan-shi-li.html">Extjs4中tree的拖拽功能(可以两棵树之间拖拽) 简单实例</a></div><div><a href="/posts/linux-make-gong-ju-he-makefile-wen-jian-de-yin-ru.html">【Linux】make 工具和 Makefile 文件的引入</a></div><div><a href="/posts/3kuan-zui-qiang-de-aishi-pin-sheng-cheng-qi-zhi-chi-wen-sheng-shi-pin-tu-sheng-shi-pin.html">3款最强的AI视频生成器，支持文生视频、图生视频</a></div><div><a href="/posts/mysql-qian-wan-ji-shu-ju-biao-partition-shi-zhan-ying-yong.html">MySQL 千万级数据表 partition 实战应用</a></div><div><a href="/posts/Spring-Cloud-Bus-shi-xian-pei-zhi-shi-shi-geng-xin.html">Spring Cloud Bus 实现配置实时更新</a></div><div><a href="/posts/atitit-ormkuang-jia-de-hibernate-shi-yong-SQLQuery-createSQLQuery-addEntity.html">atitit. orm框架的hibernate 使用SQLQuery createSQLQuery addEntity</a></div><div><a href="/posts/she-ji-mo-shi-zhi-ge-zhong-shi-pei-qi.html">设计模式之各种适配器</a></div><div><a href="/posts/Zorkajian-kong-ping-tai-Collectorduan-de-pei-zhi-fang-fa.html">Zorka监控平台Collector端的配置方法</a></div></span>
                </div>
            </div>
        </div>
    </div>
</div>

<section class="rightnav">
    <div class="rnlist" style="display:none;">
        <div class="rimg"><img
                src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAMAAACahl6sAAAAn1BMVEUAAADndGvmcm3mcm3ncW3mcm3mcm3mcm3ncm3mcm3ncm7mcm3ncm3mcm3mcmzncm3mcm3mcm3ncm3ncm3mcm3mcm3mcm3ncm3ncm3mcmzmcm3mcG3mcm3ncm3mcm3oc2zncm3ncm3mcm3ncm3mcm3ncm3ncm3ncW3mcm3mcm3mcm3mcm3mcm3ncmzmcm3ncW3mcm3mcW3ncmzncm3mcm2BuVw1AAAANHRSTlMACPdpvuXwgRJ8PDKfdyf01eAslnJORrerOMQOm7BeF+qnkNzQi8gjzMFthmJZQBykUx9VoEk3cQAACftJREFUeNrdnWm3mjAQhieAgogLgogLct2tV+uW///b2p6uk4BgEiT2+djTewQymfdNMkmgInbD0J55sWWt/AalDX9lWbHn2eGwC29C6s7ty/aD5vKxXdhH9ww6M5gvJwYtxzY4DkBHuifmJYoxJsu5ZpHmbtZUkPXGBU0Yt75QKb60xlA7XTPpUWl6iVlrjJFoYVBFGIuIQD2kpkWVYpkpvJ5zOKHKmYQ3eC27zpZWwr7zys7Sba1pZfTtVwklMZu0FA2/b1kLL7DtwLtYVt9v0FI0QwIvYJjQInzLa53GKXCk41NrZvm0iNEdqmYaGI+zqGVHDhTgRLZVkLc9B6pketg/kjVrcy+ddW7XT+tRiK7DCl9lMHnQFPHJefq7XC/GgwQ2hmqYtj5y3yI5dAXzuBnntkvTrqRR2l6ujNluRabzUkGjtH2aTeKCNGPPyMngEaiFdLI14CNQ9Etfg5wfaE2V9vJZ9vdafgVluJvsNvfaVYeVsTyDUtKlkfm5XFDEcUUzmFXRETPl1jdBCYesrGvNoRJOo6w83AEFtHqUw7dvUBHnVlb720RaBT8pj/cVKuRrlmAtU5CCxBkNPYSKuWaIfSKVhrsXyhF/hcpx44zfbUvE1TajjQm8ALKkHP1UuN/x7dE34UUc13yb7ETHUHygyoSVfHh5Ym2y5DWQwAshAf8mQvpBWT4JvJaWwT2CgJ6zOtjrwMsJOVPx9EMcP1g/fYAaMH1WxEx4ijbXHleoBZd9EMOFJxhYbNo9QU1c9+zA+hlhTNj2GENtdNkgH0FpOuzQZg41cmftcKt0aza4DlYrR+Z5PkrGeZuZnTE6UDOHnkg3mXoUY0PtsLHuTQUUfUmgfj6f7yYDg8kROrwHwIIJ90FhYMVcOGoBq2xxUXAduAShCUMmdR0KXnyvXUfP6fD7wTNjkIsD2kBmTBJ62H5N/NYa1IggfSs7meMk+L/OQSvu2HUl+eFiUkQAmmFThJmbenFgNaagGcTHETMtp+kmaMexlL7v8EzSQg9Jx3h4CXtXIlE3ItAQd1U8FXHeMhMvWoLDf3sGnhB7LM3KP39zHhUZFYIbTTMJ+cuQ/suKFGjIF428CYaMHqdWx2KaTFtwCrYcwJywydK4dN3BlusEGGwta59uKD9kmgGii8S/r2nKytIJHz+rqetwqli5zfw5Ul+TcXoe3T5y86jMqKe1fWfZcPPS2cJ/Bc2J8jwwQRltq904hMNC4k3+yv472MX87j7Mjjmqde79yRlNh27gNyiyRvAGxCi2/qQzlLNCeAPMzIngOZokHYBSSGh9x05BKTs06DhmTS8moJSh9cv1HEEplyzhm2RlZdWry4ZadTogwchaEYlAIdG6qhVVl/5Lm+8iK0flr6F02FfZJmSNjCPfRRagjkFCEXuVrT3jByV9geQrVrf2ZQwq4OOoAd9JkYq4oIppQDkSdbm9zbkRF8UxUbkQy7PYgSq2KEWx0w6xWl/HM0uVdRK2t9uVDHJzt/gtSRVfasNqpCr9PfkUo/5b3VEksbH2FZQwXNN8OhX09j3AFC3M3ZQLIU/zACpw/g3epoNfbKVGCEc0A+VmZY9NylX5oIpMKINRSUFejCdMQk7q5X+AIeg22Dbpqp4UCrFudaoQwpkD1z5rVlzFo8RPCBQv73QyxXzOtslooHbJJ8DrpEP1Qjhqo39XaFa+opo6HNGRciHcfs1rqVmqUkhiQKlyrFoI+3/b2FZtVrqo4fGAXTJw3ckDxSBLxWbljFahYY2EXa0Q9pCGpzO1ZsVBRRCAJogckOB2oY9rQXcLpWaFGMiToLxIlI4IN/wgXqlZ+UCD3d6/X0i1ELKMLYqQm1nx/41i/CKKhZAn2lJ2ZkXRizChpVYIeVSZFT60mM6uWgh5ss2KfGdXk36HfV4IM1BnVvj0ywiieiHk6Ri8WZEXRMaiKBdCnmyzIm9R5E3jbVEghCxkQxk+5U2jvI13eCEkRX/CmxV5G+/JDqw2vBCWcTPyZiXCL7KR/DCtUkJYbFaOkkNd2cmHQzkhLDYrq7vk5MNdajpo3igphOrNCk5Td2aCTl4Ixf/2iys1QcdPmaoXwmzmPheVElOmMpPY7XJCWJFZaWOHArAQXVbYFQhhMaHBHeogsaxgC0qsMysrhOrNCr/Qwy29SYwIYwHHFFCGUHDpTXwx1P3gAlyFv+mPhRdDz4bQ8vSMfQJHzRrEUnh5GlZCTbsVEsJiszISLhiAQKiEA0dWrw2ipFgYfZGI8Pjy/5Uj8iJGBOLgZaCRUFGNRJnTLFMI5Uf8HaEyJ4nCs6HChS7X+BtZTkktRX5TqhRwgxKNHMMe6msipYB8AhhAOcivowiNEATh90AmO7HiTMly2cFi3ewHY1BC17TnbbH9ScbgfQuYF2ggkzN/sAPtySspH77Tfp6MIv/33XYxytl2AS3mDTWH2QjzvluTPvMrdBLkt/S8PCdn433yvtv3Qmb7Xv6GyrXWGThlNlT+n1tcmUTQ0PG8h+yN99H/ug38v9mYD8R/x6MSfFJ4eIWmies8KpzPu+3fYX9oC6+p3P7nA16YbeL0omMKntEyJyHY2h+CNC9XSzjt6X4s1arcsVQQUr37e6vsEkQ60vRsw58MsdSNUsjl3tPytMnMMyd79ydWkDyNugkJnjkhr71mlze1genA64JoCbU9AtR/brHRSfQ8lLU7ouwhjQWM6Vsckzt+fu17o8ObfArsD3Au+h8lvUihBOMt04y1n8thNsXu5Tt9MKnrCDXCF4U156Llfatak/CwLxzrZEQxzS7UBreJcUKgNO0JxeyvUBND7lHcJxeMMb0IasFtUowRSW6jaJhQA8cVlU2hHbmb49TdlyftYm25m+OU3ZcnbzM8/a5/ioUeIPV0u5DrcgMhdrFeV6SJHw/j9P+PS+sA2rE+1wgmY5BgmuhyseNkKntFLOW5vP6qzeAmHa2fVIPLTzcOyNNp1n0drdEiakLWoBkszqCc9EIzMExlUduo88rmjwiU0fZecIn20qdZLFxQyLT1Uc+15k07BbW4jRoumufD6k2v/l+MoQo6Bs1jcpwKxuzconkYld22OpjQXIz45Dz9FtcL/jYvu7NpetjTfHrW5l5a8W/XT6tJ81mHDlTJNDDoIwzLjgqfwIlsy6AP8RyommFCi/Atr3Uap8CRjk+tmeXTIkZ3eAHEbNJSNPy+ZS28wLYD72JZfb9BS9EMCbyGbmtNK6NvD+B17DpbWgn7ThdeyzmcUOVMwhu8ntS0qFIsM4V6INHCoIowFhGBGumaSY9K00tMDS5CQKZPhC8tbS6QdDd94Wy7cUErBsdg+3SuDY56boxom7N16ZbwTE2qQ7Ih3cjcxPsmzaW5jjdm1NWhnqLU+wxDe+bFlrXyGz9c18qyYs+zw+Ggojf4BvPECQPi+ShVAAAAAElFTkSuQmCC"/>
        </div>
        <div class="rntit">
            <div class="rnt1">返回</div>
            <div class="rnt2">顶部</div>
        </div>
    </div>
</section>
<footer class="copyright">
    <div class="container">
                    <span class="glyphicon glyphicon-exclamation-sign" style="text-align: center;">
                        © <script type="text/javascript">document.write("" + new Date().getFullYear())</script> <a
                            href="/">源码集中营</a> 版权所有
                    </span>
    </div>
</footer>