2021-08-07 按条件来更新数据

更新数据：

package com.kuang.lesson02;

import com.kuang.lesson02.utils.jdbcUtils;

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

public class TestUpdate {
    public static void main(String[] args) {
        Connection con=null;
        Statement st=null;
        ResultSet rs=null;
        try {
            con= jdbcUtils.getConnection ();
            st=con.createStatement ();
  String sql="UPDATE users SET `name`='yyf1' WHERE id=1";
  int i=st.executeUpdate (sql);
  if(i>0){
      System.out.println ("更新成功");
  }
        } catch (SQLException throwables) {
            throwables.printStackTrace ();
        }
        finally {
            jdbcUtils.release (con,st,rs);
        }
    }
}