whats the code that we need to connect oracle10g with the netbeans

[katko0ota]

hi every one

i need to connect oracle 10 with jave (netbeans 6)

how can i??

and whats the code i have to use connect them??

please replay quickly

i neeeeeeeeeeed it help me

[danielstoner]

I am not sure what you mean by connecting Oracle with Netbeans but if I get it right you might just want to search for a JDBC tutorial. There is one right on this site: Java Database Connectivity

[katko0ota]

thanx danielstoner

i mean how can i connect the oracle10g with netbeans6 that i need it in my

project that its a website like e-voting that can we vote by internet >>the data base and interface i use oracle10g<<<

and by sms >>> so that i use netbeans

so i dont know how to connect them

i hope thats clear to help me

[katko0ota]

i need the code that help me to connect the oracle10g with netbeans??

and can you show me how to connect step by step

thanx for reading my post

[roo7]

package yourPackage;

import java.sql.*;


public class connection {

/** Creates a new instance of connection */
public connection() {
}

public static Connection getConnection(){
Connection connect =null;

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


connect = DriverManager.getConnection("jdbcracle:thin:@loc alhost:1521:xe","system","manager");
}
catch(ClassNotFoundException cnfe){
cnfe.printStackTrace();
}
catch(SQLException sqle){
sqle.printStackTrace();
}
return connect;
}

}

[Eku]

Same as roo7, i just detailed some parts ^_^

Code:

ResultSet Rs = null; 
try {Class.forName("oracle.jdbc.OracleDriver");
            connection conn = "Oracle:thin:@<IP>:<port>:<SID>","<username>","<password>";
            Statement Stmt = conn.prepareStatement(query);
             RS = Stmt.executeQuery();
            } catch (Exception ex) { ex.printStackTrace(); }

Just make sure you have properly configured your oracle, database and also installed the oracle driver.,

[linuxswan]

You can find the Database connectivity in the menus where you can provide all the information like ODBC connectivity.