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 |
How can I write to the log used by DriverManager and JDBC drivers?
What is createstatement method in java?
What is an encrypted internet connection?
Why should we close database connections in java?
What is getconnection method in java?
What are the different types of modifiers?
After creating conntinpool in weblogic how to write the code in programe where i can use that pool object in the programe connecting to the database and how to debug programe withou eclipse
What is the difference between jdbc and odbc?
Explain how data flows from view to db and reverse
What are the standard isolation levels defined by JDBC?
Does JDBC support stored procedures?
What is jdbc servlet?