【MySql】 JDBC复习

JDBC

Java数据库连接，（Java Database Connectivity，简称JDBC）是Java语言中用来规范客户端程序如何来访问数据库的应用程序接口，提供了诸如查询和更新数据库中数据的方法。JDBC也是Sun Microsystems的商标。我们通常说的JDBC是面向关系型数据库的。

JDBC固定步骤

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

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.li.jdbc</groupId>
    <artifactId>jdbc-demo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>
    </dependencies>
</project>

package com.li.test;

import java.sql.*;

public class test {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //配置信息
        String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
        String username = "root";
        String password = "123456";

        //1。加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2。链接数据库
        Connection connection = DriverManager.getConnection(url, username, password);

        //向数据库发送SQL对象的Statement
        Statement statement = connection.createStatement();

        //4.编写SQL
        //增
        String sqladd = "insert into users(id,name,password,email,birthday) value (?,?,?,?,?)";
        PreparedStatement preparedStatement = connection.prepareStatement(sqladd);
        preparedStatement.setInt(1,6);
        preparedStatement.setString(2,"lisi");
        preparedStatement.setString(3,"23456");
        preparedStatement.setString(4,"999@qq.com");
        preparedStatement.setString(5,"2020-1-1");

        preparedStatement.executeUpdate();//执行

        //删
        String sqldel = "delete from users where id = 4;";
        //改

        //查
        String sql = "select  * from jdbc.users;";



        //5.执行sql
        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"));

        }

        //6.关闭连接
        resultSet.close();
        statement.close();
        connection.close();


    }
}