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
Post a Comment