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

What is the different between ResultSet and RowSet?

1065

---

How can I write to the log used by DriverManager and JDBC drivers?

1050

---

What is represented by the connection object?

1127

---

RowSetInternal caller and returns void. What can I do in the readData method?

1020

---

What is JDBC RowSet? What are different types of RowSet?

1127

---

In which ways is driver class is registered with drive manager?

956

---

How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?

1036

---

Explain the difference between rowset vs. Resultset in jdbc?

1038

---

What are the differences between execute, executequery, and executeupdate?

992

---

What packages are used by jdbc?

995

---

Why do I have to reaccess the database for Array, Blob, and Clob data?

1137

---

What is odbc and jdbc?

1077

---

What is jdbc connection interface?

1075

---

What are the components of jdbc?

1031

---

Explain how data flows from view to db and reverse

2085

---