Java连接MySql的步骤

//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接对象
Connection connection =DriverManager.getConnection(
  "jdbc:mysql:///student","root","317499");
//获取Sql语句的执行对象
Statement statement=connection.createStatement();
//执行Sql语句，获得结果集对象
ResultSet resultSet=statement.executeQuery("select *from demo");
//对结果集进行数据处理
for (;resultSet.next() ; ){                     
        String id=resultSet.getString("学号");    
        String name=resultSet.getString("姓名");  
        String phone=resultSet.getString("电话"); 
        System.out.println(id+\t+name+\t+phone);
}

对应的Maven jar包依赖

<dependency>                                       
    <groupId>mysql</groupId>                       
    <artifactId>mysql-connector-java</artifactId>  
    <version>5.1.47</version>                      
</dependency>

url的多种写法

String url = “jdbc:mysql://127.0.0.1:3306/itcaststore?useSSL=false&serverTimezone=UTC”;

String url = “jdbc:mysql://127.0.0.1:3306/itcaststore?Encoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true”;