Connect to the Oracle database using Java

Notes:

Method 1: connect to Oracle database with JDBC-ODBC Bridge

Try
{
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
Connection Ct = drivermanager. getconnection ("JDBC: ODBC: XXXX", "Scott", "orcl ");
Statement Sm = CT. createstatement ();
Resultset rs1_sm.exe cutequery ("select * from EMP ");
While (Rs. Next ())
{
System. Out. println ("username:" + Rs. getstring (2 ));
}

}
Catch (exception E)
{
E. printstacktrace ();
}

Method 2:The thin method of JDBC

try
{< br> class. forname ("oracle. JDBC. driver. oracledriver ");
connection Ct = drivermanager. getconnection ("JDBC: oracle: thin: @ 127.0.0.1: 1521: orcl", "Scott", "orcl");
statement Sm = CT. createstatement ();
resultset rs1_sm.exe cutequery ("select * from EMP");
while (RS. next ()
{< br> system. out. println ("username:" + Rs. getstring (2);
}< br> catch (exception e)
{< br> E. printstacktrace ();
}