Update Data.


import  java.sql.*;
import java.util.*;
Class insert
{
public static void main(String args[])
{
try
{
Scanner scan=new Scanner(System.in);
System.out.println("Enter the id:-");
int id=scan.nextInt();
System.out.println("Enter Ur Name:-");
String name=scan.next();

System.out.println("Enter Ur Address:-");
String add=scan.next();
System.out.println("Enter Ur Mail:-");
String mail=scan.next();


Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Databasename","username","password");
PreparedStatement pst=con.prepareStatement("update demo set name=?,mail=?,address=? where id=?");
pst.setString(1,name);
pst.setString(2,mail);

pst.setString(3,add);
pst.setInt(4,id);
pst.executeUpdate();
con.close();
pst.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}

Popular posts from this blog

Simple Sign up design. Android.

Cart page design in android.

Set Date on jDateChooser and retrieve record from database.