JDBC连接数据库 查询 用户信息

package cn.tedu;

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

//JDBC连接数据库 查询  用户信息
public class Test01 {
    public static void main(String[] args) throws Exception {
        //1.注册驱动(反射)
        Class.forName ("com.mysql.jdbc.Driver");
        //2.获取链接
        String url = "jdbc:mysql://localhost:3306/db10?characterEncoding=utf8&useSSL=false";//百度查
        String name = "root";
        String ps = "root";
        Connection conn = DriverManager.getConnection(url, name, ps);
        System.out.println(conn);
        //3.获取传输器
        Statement stat = conn.createStatement();
        //4.执行SQL语句
        String  sql = "select * from stu where name ='张三'";
        ResultSet rs = stat.executeQuery(sql);
        //5.遍历结果集
        while (rs.next()){
            int id = rs.getInt("id");
            String name1 = rs.getString("name");
            int age = rs.getInt("age");
            String job = rs.getString("job");
            System.out.println(id+name1+age+job);
        }
        //6.关闭资源
        rs.close();
        stat.close();
        conn.close();
    }
}