封装java连接mysql

一个类进行连接封装，主方法调用。

package test_mysql;

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

import com.mysql.cj.xdevapi.Statement;

public class DBUtil2 {
	private static Connection con;
	public static void test(String url,
			String user,
			String password,
			String sql,
			String a,
			String b) {
		try {
		con = DriverManager.getConnection(url,user,password);
		if(!con.isClosed())
			System.out.println("Success connecting to the Database!");
		java.sql.Statement statement = con.createStatement();
		ResultSet rs = statement.executeQuery(sql);
		while(rs.next()) {
			String name = rs.getString(a);
			String pwd = rs.getString(b);
			System.out.println(name+"\t"+pwd);
		}
		rs.close();
		con.close();
		}catch (SQLException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			System.out.println("���ݿ����ݻ�ȡ�ɹ�");
		}
	}
}

public class Test {

	public static void main(String[] args) {
		final String url = "jdbc:mysql://localhost:3306/mydata?serverTimezone=UTC";
		final String user = "root";
		final String password = "root";
		String sql = "select * from user";
		String a = "username";
		String b = "password";
		DBUtil2.test(url,user,password,sql,a,b);
	}
}