I need to know about JDBC. Can you help me please?

JDBC is a java database connectivity.It has standard set of API which is used to interact with the database through JAVA.JDBC API provides interfaces and classes to work with databases. Connection interface encapsulate database connection functionality Statement interface encapsulates SQL query representation and execution functionlity ResultSet interface encapsulates retrieving data which is coming from execution of SQL query using Statement. read less

JDBC (Java Database Connectivity) is a Java API that can access any kind of tabular data, especially data stored in a Relational Database. It works with Java on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX. The JDBC library includes APIs for each of the tasks associated with database usage: 1. Making a connection to a database. 2. Creating SQL or MySQL statements. 3. Executing that SQL or MySQL queries in the database. 4. Viewing & Modifying the resulting records. Fundamentally, JDBC provides a complete set of interfaces that allows for portable access to an underlying database. read less

Java JDBC is a java API to connect and execute query with the database. JDBC API uses jdbc drivers to connect with the database. JDBC Driver is a software component that enables java application to interact with the database.There are 4 types of JDBC drivers: JDBC-ODBC bridge driver Native-API driver (partially java driver) Network Protocol driver (fully java driver) Thin driver (fully java driver) There are 5 steps to connect any java application with the database in java using JDBC. They are as follows: Register the driver class Creating connection Creating statement Executing queries Closing connection The forName() method of Class class is used to register the driver class. This method is used to dynamically load the driver class. public static void forName(String className)throws ClassNotFoundException Class.forName("oracle.jdbc.driver.OracleDriver"); The getConnection() method of DriverManager class is used to establish connection with the database. 1) public static Connection getConnection(String url)throws SQLException 2) public static Connection getConnection(String url,String name,String password) throws SQLException Example to establish connection with the Oracle database Connection con=DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:xe","system","password"); The createStatement() method of Connection interface is used to create statement. The object of statement is responsible to execute queries with the database. Syntax of createStatement() method public Statement createStatement()throws SQLException Statement stmt=con.createStatement(); Example to execute query ResultSet rs=stmt.executeQuery("select * from emp"); while(rs.next()){ System.out.println(rs.getInt(1)+" "+rs.getString(2)); } 5) Close the connection object By closing connection object statement and ResultSet will be closed automatically. The close() method of Connection interface is used to close the connection. Syntax of close() method public void close()throws SQLException Example to close connection con.close(); Hope this would help you. read less