使用PreparedStatement实现添加表数据

来自姬鸿昌的知识库
跳到导航 跳到搜索

https://www.bilibili.com/video/BV1eJ411c7rf?p=13

An object that represents a precompiled SQL statement.

建表

CREATE TABLE `jdbc_test`.`customers` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(15) NULL,
  `email` VARCHAR(20) NULL,
  `birth` DATE NULL,
  `photo` MEDIUMBLOB NULL,
  PRIMARY KEY (`id`));


java.sql.Connection

package java.sql;

……

public interface Connection  extends Wrapper, AutoCloseable {
……
    PreparedStatement prepareStatement(String sql) throws SQLException;
……
}

https://github.com/jihch/jdbc/blob/main/src/main/java/io/github/jihch/preparedstatement/crud/PreparedStatementUpdateTest.java