how can connection with oracle10g with java
Answers were Sorted based on User's Feedback
Answer / rajshri
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:XE", "system", "system");
//(system,system is username and passward of oracle 10g)
Statement st=con.createStatement();
String sql="(here your sql statement must be of select
pattern)";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
AND SO ON...
Is This Answer Correct ? | 33 Yes | 4 No |
Answer / kishan
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
public class Database {
static final String USERNAME="hr";
static final String PASSWORD="hr";
public static Connection getConnection()
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:XE",
USERNAME, PASSWORD);
return con;
}
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
}
}
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
Diff bet.. Function and Trigger?
I have written a program to connect to database using odbc.Can this Application run on any Platform????
Why do I have to reaccess the database for Array, Blob, and Clob data?
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
What is drivermanager in jdbc?
what is call level interface?
What are the different types of classes in the api component?
What is de-normalization?
What is benefit of using preparedstatement in java?
What are the three parts of a jdbc url?
What causes no suitable driver error?
What are the methods which can verify the cursor particular position?