Answer Posted / dipanshu

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class Driver4Test
{
public static void main(String[] Dipanshu)throws SQLException

try
{
//Loading the Driver Class Class.forName("oracle.jdbc.driver.OracleDriver");

// creating the Connection obj to takl to Db
Connection con = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:XE","USERNAME", "PASSWORD");

//create the Statement obj for sending and execute the query
Statement st=con.createStatement();

//Framing the Query with variable called sql
String sql="Select * from student";

//Sending and processing the query to DB
ResultSet rs=st.executeQuery(sql);

}
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
//Printing the results
while(rs.next())
{
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+getString(3);
}
//Closing the Objects
rs.close();
st.closee();
con.close();

}

This is the perfect Jdbc Application

How many types of statements are there in jdbc?

923

---

How many rowset are available in jdbc?

1109

---

What are the advantages of using jdbc datasource?

982

---

What do you mean by metadata and why we are using it?

1017

---

What are the flow statements of jdbc?

998

---

Is jdbc faster than odbc?

912

---

What is isolation level? How to set it?

2202

---

What is the JDBC syntax for using a literal or variable in a standard Statement?

989

---

What is createstatement method in java?

955

---

What are the classes and methods used for sending sql statements to database?

1073

---

Why do you use a data source object for a connection?

1026

---

What is jdbc thin client?

963

---

What is a lock in jdbc?

949

---

What is two-phase commit in the database?

1040

---

What are dml and ddl?

989

---