JDBC连接

JDBC连接

public class JdbcFirstTest {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //用户信息和连接配置
        String url = "jdbc:mysql://localhost:3306/jdbcstudy?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF8&useSSL=true";
        String username = "root";
        String password="123456";
        //获取连接
        Connection connection = DriverManager.getConnection(url,username,password);
        //创建statement，用来执行sql语句
        Statement statement = connection.createStatement();
        //sql语句
        String sql="SELECT * FROM `users`";
        //得到结果集
        ResultSet resultSet = statement.executeQuery(sql);
        //取出数据
        System.out.println("-------------"+resultSet);
        while (resultSet.next()){
            System.out.print("id="+resultSet.getObject("id")+"\t");
            System.out.print("name="+resultSet.getObject("name")+"\t");
            System.out.print("password="+resultSet.getObject("password")+"\t");
            System.out.print("email="+resultSet.getObject("email")+"\t");
            System.out.println("birthday="+resultSet.getObject("birthday"));
        }
        //释放连接
        resultSet.close();
        statement.close();
        connection.close();
    }
}