关于java:C3P0测试工具类C3P0Utils

在上一篇文章C3P0-基于mysql8创立C3P0连接池(jdbcUrl写法)中, 咱们编写好了C3P0的配置文件, 并且自定义工具类C3P0Utils.

当初就通过调用该工具类中的办法的形式执行sql语句,以此测试该工具类可否失常应用(配置文件是否编写正确, 成员办法是否创立胜利 等)

这里应用的数据表是

/** *   我的项目形容: 应用自定义编写的数据库C3P0连接池的工具类获取连贯进行sql查问操作 *   作   者: chain.xx.wdm */ public class C3P0PoolTest {    public static void main(String[] args) {        Connection connection = null;        PreparedStatement preparedStatement = null;        ResultSet resultSet = null;        try {            // 1。获取连贯            connection = C3P0Utils.getConnection();            // 2。创立有占位符模式的sql查问语句            String sql = "select * from employee where name = ?";            // 3。创立prepareStatement对象，并设置占位符的数值            preparedStatement = connection.prepareStatement(sql);            preparedStatement.setString(1,"猪八戒");            // 4。执行sql语句            resultSet = preparedStatement.executeQuery();            // 5。处理结果集            while(resultSet.next()){                int id = resultSet.getInt("id");                String name = resultSet.getString("name");                String gender = resultSet.getString("gender");                double salary = resultSet.getDouble("salary");                String join_date = resultSet.getString("join_date");                System.out.println("id: " + id + ", name: " + name  + ", gender: " + gender + ", salary: " + salary + ", join_date:" + join_date);            }        } catch (SQLException throwables) {            throwables.printStackTrace();        } finally {            // 6。敞开对象            try {                C3P0Utils.close(connection, preparedStatement, resultSet);            } catch (SQLException throwables) {                throwables.printStackTrace();            }        }    }}

运行返回后果正确