jdbc PreparedStatement执行insert、delete、update语句-马育民老师

# 执行曾加

```
String url="jdbc:mysql://127.0.0.1:3306/test?useSSL=false";
String username="root";
String password="123456";

String sql="INSERT INTO USER (id,username,PASSWORD,age,sex,STATUS) VALUES (?,?,?,?,?,?)";

Connection conn=null;
try {
    //加载驱动
    Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection(url,username,password);
    if(conn!=null && !conn.isClosed()){
        System.out.println("数据库连接成功！");
    }

PreparedStatement ps=conn.prepareStatement(sql);
    ps.setObject(1,"1");
    ps.setObject(2,"lucy");
    ps.setObject(3,"123456");
    ps.setObject(4,20);
    ps.setObject(5,"0");
    ps.setObject(6,"1");
    int num=ps.executeUpdate();
    System.out.println(num);

} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException throwables) {
    throwables.printStackTrace();
} finally {
    try {
        if(conn!=null && !conn.isClosed()){
            conn.close();
            System.out.println("关闭数据库连接！");
        }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }
}
```

# 执行删除

```java
String url="jdbc:mysql://127.0.0.1:3306/test?useSSL=false";
String username="root";
String password="123456";

String sql="delete from user where id=?";

Connection conn=null;
try {
    //加载驱动
    Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection(url,username,password);
    if(conn!=null && !conn.isClosed()){
        System.out.println("数据库连接成功！");
    }

PreparedStatement ps=conn.prepareStatement(sql);
    ps.setObject(1,"10003");
    int num=ps.executeUpdate();
    System.out.println(num);

# 执行更新

```java
String url="jdbc:mysql://127.0.0.1:3306/test?useSSL=false";
String username="root";
String password="123456";

String sql="update user set password=? where id=?";

Connection conn=null;
try {
    //加载驱动
    Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection(url,username,password);
    if(conn!=null && !conn.isClosed()){
        System.out.println("数据库连接成功！");
    }

PreparedStatement ps=conn.prepareStatement(sql);
    ps.setObject(1,"12345678");
    ps.setObject(2,"1000");

int num=ps.executeUpdate();
    System.out.println(num);

原文出处：http://www.malaoshi.top/show_1EF63mPOljfR.html