java连接mysql数据库和结果集解析

package t;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCTest {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
	//mySql连接java
			Driver driver=null;
			try {
				driver = new com.mysql.cj.jdbc.Driver();//加载驱动
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				DriverManager.deregisterDriver(driver);//驱动注册
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			Connection connection=null;
			try {
				 connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/employee?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true", "root", "password");//获得连接
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			Statement statement=null;
			try {
				 statement=connection.createStatement();//获得statement对象
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			String sql="select * from course ";//编写sql
			ResultSet resultSet=null;
			try {
				resultSet=statement.executeQuery(sql);//获得结果集
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				while(resultSet.next()) {
					System.out.println(resultSet.getString(1));//结果集解析
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				statement.close();//关闭statement对象
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}//
			try {
				connection.close();//关闭连接
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	
  	}

}