jdbc program

import java.sql.*;

public class JdbcPreparedstatementUpdate {

  public static void main(String args[]) {

  Connection con = null;
  PreparedStatement pst = null;

  String url = "jdbc:mysql://localhost:3306/";
  String db = "test";
  String driver = "com.mysql.jdbc.Driver";
  String user = "root";
  String pass = "root";

  try {
  Class.forName(driver);
  con = DriverManager.getConnection(url + db, user, pass);

  pst = con.prepareStatement("update employee set salary=? where name=?");

  pst.setInt(1, 6000);
  pst.setString(2, "P.Ramu");

  pst.executeUpdate();


  pst.close();
  con.close();

  } catch (Exception e) {
  System.out.println(e);
  e.printStackTrace();
  }
  }
}

import java.sql.*;

public class JdbcPreparedstatementUpdate {

  public static void main(String args[]) {

  Connection con = null;
  PreparedStatement pst = null;

  String url = "jdbc:mysql://localhost:3306/";
  String db = "test";
  String driver = "com.mysql.jdbc.Driver";
  String user = "root";
  String pass = "root";

  try {
  Class.forName(driver);
  con = DriverManager.getConnection(url + db, user, pass);

  pst = con.prepareStatement("update employee set salary=? where name like ?");

  pst.setInt(1, 6000);
  pst.setString(2, "P.Ramu%");

  pst.executeUpdate();


  pst.close();
  con.close();

  } catch (Exception e){
  System.out.println(e);
  e.printStackTrace();
  }
  }
}