1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

JDBC Tutorials

Q. Basic CRUD(CREATE,UPDATE,DELETE) functionality using Statements in JDBC ?

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();
}

}

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy