java连接mysql数据库基本代码

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

public class mysql05 {
	public static final String DRIVER_MANAGER="com.mysql.cj.jdbc.Driver";
	public static final String URL = "jdbc:mysql://localhost:3306/student";
	public static final String USER = "root";
	public static final String PASSWORD="ms1005";
	public static Statement sttt=null;
	public static Connection conn=null;
	
	static String sql="select * from ms03";

	public static void main(String[] args) {
		try {
			Class.forName(DRIVER_MANAGER);
			conn=DriverManager.getConnection(URL,USER,PASSWORD);
			sttt=conn.createStatement();
			ResultSet rs=sttt.executeQuery(sql);
			while(rs.next()) {
				String id=rs.getString("id");
				String name=rs.getString("name");
				String sex=rs.getString("sex");
				System.out.println(id+" "+name+" "+sex);

			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(sttt!=null) {
				try {
					sttt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}

}