关于java:JDBC

JDBC连贯数据库（mysql）

public class Jdbc{public static final String url="jdbc:mysql:///数据库名?serverTimezone=GMT%2B8characterEncoding=utf8";public static final String username="账号";public static final String password="明码";public static void main(String[]args){        //1、加载驱动        Class.forName("com.mysql.cj.jdbc.Driver");        //2、连贯数据库        Connection conn=DriverManager.getConnection(Jdbc.url,Jdbc.username,Jdbc.password);        //3、创立申明        Statement st=conn.createStatement();        //4、执行SQL语句        ResultSet rs=st.executeQuery("SQL语句");        //5、遍历后果集        while(rs.next()){        String id=rs.getString("字段1");        String name=rs.getString("字段2");        String gender=rs.getString("字段3");        System.out.println(id+","+name+","+gender);        }        //6、敞开资源        rs.close();        st.close();        conn.close();    }}