Java - JDBC


JDBC: (Java Database connectivity.)
Uses:
·         Connect to database
·         Executing queries and update statements to database.
·         Retrieve results from database.
Steps:
·         Register the driver class
·         Create Connection
·         Create Statement
·         Execute queries
·         Close connection
Types:
·         DDL – Data Definition language – Create, Alter, Drop
·         DML – Data Manipulation Language




Statement:
                Used to execute normal SQL queries – DDL
Statement s = con.createStatement();
s.executeUpdate(“create query”);
Prepared Statement:
Used to execute dynamic or parameterized queries
Its extends statement
High performance
Callable Statement:
Used to execute the store procedures


Basic Queries :


create database sonoo;  
use sonoo;  
create table emp(id int(10),name varchar(40)); 
Select * from emp;
Update emp set name=’Ambani’ where id=1;
Alter table emp add age int(3) not null;
Drop table emp;
Truncate table emp;
INSERT INTO emp(id,name,salary) VALUES (7, 'Sonoo', 40000); 
INSERT INTO emp VALUES (7, 'Sonoo', 40000);  
Delete from emp where id=1;

Comments

Popular posts from this blog

How to set Java Object into JaxBElement ?

GitLab