jdbc连接mysql

jdbc连接数据库步骤
数据库名为zjgm表名为stu 列 ‘id’主键 自增 ‘name’ ‘age’
1、加载驱动

Class.forName("com.mysql.jdbc.Driver");

2、创建连接

  Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/zjgm?user=root&password=123456&characterEncoding=utf-8&useSSL=true");
  System.out.println("创建连接成功");

3、写sql

String sql ="select * from stu";

4、得到statement

  PreparedStatement statement = connection.prepareStatement(sql);

5、执行sql

ResultSet resultSet =statement.executeQuery();

6、处理结果集

 while (resultSet.next()){
            int id =resultSet.getInt(1);
            String name =resultSet.getString(2);
            int age = resultSet.getInt(3);
            System.out.println(id+name+age);
        }

7、关闭资源

        resultSet.close();
        statement.close();
        connection.close();