JDBC allows java applications to connect to relational databases.
Database can be reside in local, network or cloud.
Database can be reside in local, network or cloud.
JDBC Features
- Provide portable access to various databases
- Can build custom sql statements
JDBC Supported Databases
- MySQL
- Oracle
- DB2
- PostgreSQL
Key Classes of JDBC
- java.sql.DriverManager
- java.sql.Connection
- java.sql.Statement
- java.sql.ResultSet
- java.sql.DataSource
JDBC Development Process
- Get a connection to the database
- ex : jdbc:<driver protocol>:<driver connection details>
- Create a statement object
- Execute the Query
- Process the result set
Comments
Post a Comment