java通过JDBC连接MySQL

import java.sql.*;

public class JdbcFirstDemo {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //加载驱动
        Class.forName("com.jdbc.mysql.Driver");
        //用户信息和URL
        String url = "jdbc:mysql:localhost:3306/jdbcStudy?useSSL=true&characterEncoding=utf8&useUnicode=true";
        String username = "root";
        String password = "123456";
        //连接成功,数据库对象
        Connection connection = DriverManager.getConnection(url, username, password);

        //执行SQL对象
        Statement statement = connection.createStatement();
        //执行SQL对象,执行SQL对象对执行SQL,可能存在结果,查看返回结果
        String sql = "select * from users";
        ResultSet resultSet = statement.executeQuery(sql);


        while(resultSet.next()){
            System.out.println("id=" + resultSet.getObject("id"));
            System.out.println("NAME=" + resultSet.getObject("NAME"));
            System.out.println("PASSWORD=" + resultSet.getObject("PASSWORD"));
            System.out.println("email=" + resultSet.getObject("email"));
            System.out.println("birthday=" + resultSet.getObject("birthday"));
        }

        //释放连接
        resultSet.close();
        statement.close();
        connection.close();





    }
}

 

posted on 2022-08-09 22:18  sunny_2016  阅读(334)  评论(0)    收藏  举报

导航