TechFAQ

Statement is an interface to execute queries.
CRUD(CREATE,UPDATE,DELETE) :
public class TestJDBC {

public static void main(String[] args) {
try {

Class.forName("com.mysql.jdbc.Driver");


Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/art1",art1,art1);

// This is for Create
Statement stmt = Connection.Statement("CREATE TABLE EMP(ID NUMBER,NAME VARCHAR2");
stmt.executeUpdate();
// This is for INSERT DATA
Statement stmt = Connection.Statement("INSERT INTO EMP VALUES(1,"SAT")");
stmt.executeUpdate();

// This is for UPDATE
Statement stmt = Connection.Statement("UPADTE EMP SET NAME="DAS" WHERE ID=1");
stmt.executeUpdate();

// This is for DELETE
Statement stmt = Connection.Statement("DELETE FROM EMP WHERE ID=1");
stmt.executeUpdate();


catch (Exception e) {
e.printStackTrace();
}

}