I'm using a lite version of Oracle.
1 Importing an Oracle driver package
Oracle Down Path
D:\oracle\app\oracle\product\11.2.0\server\jdbc\lib\ojdbc6.jar
2 views Listenerduankouhao
D:\oracle\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora
3 Code
Connection conn = Drivermanager.getconnection ("Jdbc:oracle:thin: @localhost: 1521:xe", "Yu", "123");
The Lite version is named XE by default.
Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.SQLException; Public classJDBC {/** * @paramargs *@throwsSQLException*/ Public Static voidMain (string[] args)throwsSQLException {Try{class.forname ("Oracle.jdbc.driver.OracleDriver"); //new Oracle.jdbc.driver.OracleDriver (); Connection conn = Drivermanager.getconnection ("Jdbc:oracle:thin: @localhost: 1521:xe", "Yu", "123"); if(Conn! =NULL) {System.out.println ("Database connection succeeded!"); Conn.close (); }Else{System.out.println ("Database connection Failed!"); } }Catch(ClassNotFoundException e) {e.printstacktrace (); } } }
Connect to Oracle JDBC