JDBC 德鲁伊工具类的使用

package xyz.xiaonanbyq.datasource.druid;

import xyz.xiaonanbyq.datasource.utils.JDBCDatasouce;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class demoUTIL {
    public static void main(String[] args) throws SQLException {
        Connection conn =null;
        PreparedStatement preparedStatement = null;
        ResultSet rs = null;


        try {
             conn = JDBCDatasouce.getDataSource().getConnection();
            String sql = "select * from user where username = ? ";
             preparedStatement = conn.prepareStatement(sql);
            preparedStatement.setString(1,"byq");
             rs = preparedStatement.executeQuery();

        } catch (SQLException e) {
            e.printStackTrace();
        }

        while(rs.next()){
            String id = rs.getString(1); // rs.getString("id");
            String username = rs.getString(2);
            String password = rs.getString(3);
            System.out.println(id+username+password);
        }
        JDBCDatasouce.close(rs,preparedStatement,conn);


    }
}