how can connection with oracle10g with java
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
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is jdbc thin client?
What is odbc jdbc?
How can we maintain the integrity of a database by using jdbc?
What are common JDBC Exceptions?
Is jdbc an api?
Which jdbc drivers will run your program?
What are restrictions on triggers?
What is an encrypted internet connection?
How do I insert an image file (or other raw data) into a database?
What driver should I use for scalable Oracle JDBC applications?
What is jsp and jdbc?
What are the factors that the jdbc driver performance depends upon?
What is addbatch jdbc?
What is new in JDBC 2.0?
What is a statement in java?