在JDBC中使用预编译Statement 以及它的优点

步骤 1 : 相同点
execute与executeUpdate的相同点：都可以执行增加，删除，修改

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJDBC {
public static void main(String[] args) {
try {
Class.forName(“com.mysql.jdbc.Driver”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}

    try (Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/how2java?characterEncoding=UTF-8","root", "admin");
        Statement s = c.createStatement();) {

        String sqlInsert = "insert into Hero values (null,'盖伦',616,100)";
        String sqlDelete = "delete from Hero where id = 100";
        String sqlUpdate = "update Hero set hp = 300 where id = 100";

        // 相同