JAVA连接数据库---JDBC_数据库连接

package JDBC_数据库连接_打印mess_Example11_1;

import java.sql.;
/
*another：任柏庆
*version：1.8
*Data：2020/8/26/14:43
*/
public class Test {
public static void main(String[] args) {
Connection con=null;
Statement sql;
ResultSet rs;
try {
Class.forName(“com.mysql.cj.jdbc.Driver”); //加载JDBC_MySQL驱动
}

    catch(Exception e){}

    String uri = "jdbc:mysql://localhost:3306/students?useSSL=false&serverTimezone=UTC";//定义连接（3306后为需要连接的数据库名称）
    String user ="root";
    String password ="root";
    try{
        con = DriverManager.getConnection(uri,user,password); //连接代码  建立连接


    }
    catch(SQLException e){ }
    try {
        sql=con.createStatement();
        rs=sql.executeQuery("SELECT * FROM mess"); //查询mess表传递sql语句
        while(rs.next()) {
            String number=rs.getString(1);
            String name=rs.getString(2);
            String birthday=rs.getString(3);
            System.out.print(number);
            System.out.print(name);
            System.out.print(birthday);
        }
        con.close();
    }
    catch(SQLException e) {
        System.out.println(e);
        System.out.println("出现异常");


    }
}

}