/*
 * Copyright (c) 2019. 黄钰朝
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package com.hyc.wechat.test;

import com.hyc.wechat.dao.DataSource;
import com.hyc.wechat.dao.impl.DataSourceImpl;
import com.hyc.wechat.model.po.User;
import com.hyc.wechat.model.po.abs.BaseEntity;
import com.hyc.wechat.util.JdbcUtils;
import com.mysql.cj.x.protobuf.MysqlxDatatypes;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;

/**
 * @author <a href="mailto:kobe524348@gmail.com">黄钰朝</a>
 * @program wechat
 * @description 测试数据源，用于验证数据源连接的获取和释放功能是否正常工作
 * @date 2019-05-01 16:49
 */
public class TestDataSource {
    public static void main(String[] args) throws SQLException {
        // 输出测试开始信息
        System.out.println("测试直接从数据源获取连接");
        // 获取数据源的单例实例
        DataSource dataSource = DataSourceImpl.getInstance();
        // 从数据源获取一个数据库连接
        Connection conn = dataSource.getConnection();
        // 输出获取到的连接信息
        System.out.println("获取一个连接\n");
        System.out.println(conn);
        // 输出当前已创建的连接数
        System.out.println("当前已创建连接数 = " + dataSource.getCurrentCount());
        // 输出当前空闲的连接数
        System.out.println("当前空闲连接数 = " + dataSource.getfreeCount());
        // 释放刚才获取的连接
        System.out.println("释放一个连接");
        dataSource.freeConnection(conn);
        
        // 循环获取和释放连接10次
        for (int i = 0; i < 10; i++) {
            conn = dataSource.getConnection();
            System.out.println(conn);
            // 使用工具类关闭连接
            JdbcUtils.close(conn);
        }
        // 注意：这里再次释放连接可能会导致空指针异常，因为conn在循环中已经被关闭
        System.out.println("释放一个连接");
        dataSource.freeConnection(conn);
        // 输出当前已创建的连接数
        System.out.println("当前已创建连接数 = " + dataSource.getCurrentCount());
        // 输出当前空闲的连接数
        System.out.println("当前空闲连接数 = " + dataSource.getfreeCount());

    }
}