步骤

Class.forName(com.mysql.jdbc.Driver);
Connection con = DriverManager(dbUrl, dbUser, dbPassword);
String sql = "insert into book_table values (null, ?, ?, ?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, ...);
pstmt.setFloat(2, ...);
pstmt.setInt(3, ...);
// 返回受影响数据的条数
int result = pstmt.executeUpdate();
pstmt.close();
con.close();

4.PreparedStatement

原文：https://www.cnblogs.com/pensieve/p/13612966.html