JDBC连接步骤

JDBC

引入依赖

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

1.JDBC固定步骤

1. 加载驱动
2. 连接数据库
3. 想数据库发送SQL的对象Statement：CRUD
4. 编写SQL
5. 执行SQL
6. 关闭连接

public class TestJdbc {

    public static void main(String[] args) throws Exception {
        //配置信息
        String url="jdbc:mysql://localhost:3306/opo?useSSL=false";
        String username="root";
        String password="123456";

            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //连接数据库
            Connection connection = DriverManager.getConnection(url, username, password);
            //向数据库发送SQL的对象Statement
            Statement statement = connection.createStatement();
            //编写SQL
            String sql="select * FROM user";
            //执行查询sql,返回一个ResultSet
        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();

    }

}