1) What are the types of JDBC Drivers in Java?
JDBC Drivers are of four types are:
- JDBC-ODBC bridge driver
- Native-API driver
- Network Protocol driver
- Thin driver
2) What are the five steps to connect to the database in Java?
Five steps to connect to the database are :
- Step1: Register the driver class
- Step2: Creating connection
- Step3: Creating statement
- Step4: Executing queries
- Step5: Closing connection
3) What are the commonly used methods of DriverManager class in Java?
Commonly used methods of DriverManager class are:
- public static void registerDriver(Driver driver)
- public static void deregisterDriver(Driver driver)
- public static Connection getConnection(String url)
- public static Connection getConnection(String url,String userName,String password)
4) What are the commonly used methods of Statement interface in Java?
The commonly used methods of Statement interface in java are:
- public ResultSet executeQuery(String sql)
- public int executeUpdate(String sql)
- public boolean execute(String sql)
- public int[] executeBatch()
5) What are the commonly used methods of ResultSet interface in Java?
The commonly used methods of ResultSet interface are:
- public boolean next()
- public boolean previous()
- public boolean first()
- public boolean last()
- public boolean absolute(int row)
- public boolean relative(int row)
- public int getInt(int columnIndex)
- public int getInt(String columnName)
- public String getString(int columnIndex)
- public String getString(String columnName)
6) What are the commonly used methods of PreparedStatement interface in Java?
The commonly used methods of PreparedStatement interface are:
- public void setInt(int paramIndex, int value)
- public void setString(int paramIndex, String value)
- public void setFloat(int paramIndex, float value)
- public void setDouble(int paramIndex, double value)
- public int executeUpdate()
- public ResultSet executeQuery()
7) What are the commonly used methods of ResultSetMetaData interface in Java?
The commonly used methods of ResultSetMetaData interface are:
- public int getColumnCount()throws SQLException
- public String getColumnName(int index)throws SQLException
- public String getColumnTypeName(int index)throws SQLException
- public String getTableName(int index)throws SQLException
8) What are the commonly used methods of DatabaseMetaData interface in Java?
The commonly used methods of DatabaseMetaData interface are:
- public String getDriverName()throws SQLException
- public String getDriverVersion()throws SQLException.
- public String getUserName()throws SQLException
- public String getDatabaseProductName()throws SQLException
- public String getDatabaseProductVersion()throws SQLException
- public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)throws SQLException
9) What are the types of ResultSet in Java?
There are three types of ResultSet in Java are:
- TYPE_FORWARD_ONLY
- TYPE_SCROLL_INSENSITIVE
- TYPE_SCROLL_SENSITIVE
10) How can I connect Java Application with Oracle database in java?
Example:
import java.sql.*;
class OracleConn
{
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","oracle"); // Here system is username and oracle is password.
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from emp");
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
11) How can I connect Java Application with mysql database in java?
Example:
import java.sql.*;
class MysqlConn
{
public static void main(String args[])
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/atul","root","root"); // Here atul is database name and root is username and password.
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from emp");
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
12) How many packages are available in JDBC API?
There are two types of packages are available in JDBC API:
13) What are the commonly used implementation classes of RowSet interface in Java?
The commonly used implementation classes of RowSet interface are:
- JdbcRowSet
- CachedRowSet
- WebRowSet
- JoinRowSet
- FilteredRowSet
14) What are the advantages of RowSet interface in Java?
Advantages of RowSet interface are:
- easy to use
- Flexible to use
- Scrollable
- Updatable bydefault
15) Result Sets index starts with 0 or 1?
ResultSet index starts with 1.