使用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;
……
}