Java原始连接数据库

package tsp;

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

public class Test {
	
	private static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";	//驱动  mysql8以下的
//	private static final String JDBC_DRIVER = "com.mysql.cy.jdbc.Driver"; //启动  mysql8以上的
	
	private static final String JDBC_URL = "jdbc:mysql://127.0.0.1:3306/test?useSSL=false&serverTimezone=GMT%2B8";
	private static final String JDBC_USERNAME = "root";
	private static final String JDBC_PASSWORD = "ocpp123...";
	
	public static void main(String[] args) {
		Connection conn = null;
		Statement stat = null;
		try {
			//加载驱动
			Class.forName(JDBC_DRIVER);	
			
			//打开连接
			conn = DriverManager.getConnection(JDBC_URL, JDBC_USERNAME, JDBC_PASSWORD);
			
			//执行查询
			stat = conn.createStatement();
			
			//编写sql语句
			String sql = "select * from user";
			ResultSet rs = stat.executeQuery(sql);
			
			while(rs.next()){
				System.out.println(rs.getString("name"));
				System.out.println(rs.getInt("id"));
				System.out.println(rs.getString("age"));
			}
			
			//释放资源
			rs.close();
			stat.close();
			conn.close();
			
		} catch (Exception e) {
			// TODO: handle exception
		} finally {
			// TODO: handle finally clause
			try {
				if (stat == null) {
					stat.close();
				}
				if (conn == null) {
					conn.close();
				}
			} catch (Exception e) {
				// TODO: handle exception
			}
			
		}
	}
		
}