JDBC的引入

JDBC访问数据库编码步骤

1∶加载Driver驱动
2:获取数据库连接(Connection)
3:创建会话-SQL命令发送器(Statement)

4:通过Statement发送SQL命令并得到结果

5:处理结果
6:关闭数据库资源(ResultSet、Statement、Connection) 

public class test001 {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //获取连接
        String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8&allowPublicKeyRetrieval=true";
        String username = "root";
        String password = "111111";
        Connection conn = DriverManager.getConnection(url,username,password);
        //创建会话
        Statement sta = conn.createStatement();
        //发送sql
        int i =sta.executeUpdate("insert into t_book (id,name,author,price) values (3,'炸鸡','王三',30)");
        if(i > 0 ){
            System.out.println("成功");
        }
        else{
            System.out.println("失败");
        }
        //关闭资源
        sta.close();
        conn.close();
    }
}