Example code for Java connection to an Oracle database

The most basic Oracle database connection code (for oracle11g only):

1, right-click Project, build path, configuration build path, select the third item "Library", then click "Add External Jar" and select "D:\Oracle\app\oracle\product\11.2.0\server \jdbc\lib\ Ojdbc6_g.jar "(Note: D:\Oracle is the installation path for the database).

2. The following code is a very standard example of Oracle database connection code:

/**
* A very standard example code for connecting to an Oracle database
*/
public void Testoracle ()
{
Connection con = null;//Create a database connection
PreparedStatement pre = null;//creates a precompiled statement object, which is usually used without statement
ResultSet result = null;//Create a results set object
Try
{
Class.forName ("Oracle.jdbc.driver.OracleDriver");//Load Oracle Driver
System.out.println ("Start trying to connect to the database!") ");
String url = "jdbc:oracle:" + "thin:@127.0.0.1:1521:xe";//127.0.0.1 is a native address, XE is the default database name for Lite Oracle
String user = "System";//username, system default account name
String Password = "147";//The password you chose to set when installing
con = drivermanager.getconnection (url, user, password);//Get connection
SYSTEM.OUT.PRINTLN ("Connection Successful! ");
String sql = "SELECT * from student where name=?"; /precompiled statement, "? The delegate parameter
Pre = con.preparestatement (SQL);//instantiation of precompiled statements
Pre.setstring (1, "Liu Xianhan");//Set the parameter, the preceding 1 indicates the index of the parameter, not the index of the column name in the table
result = Pre.executequery ();//Execute query, note that no additional arguments are required in parentheses
while (Result.next ())
When the result set is not empty
System.out.println ("School Number:" + result.getint ("id") + "name:"
+ result.getstring ("name"));
}
catch (Exception e)
{
E.printstacktrace ();
}
Finally
{
Try
{
Close each of the above objects individually, because if you do not close it, it will affect performance and consume resources
Note The order of the closing, the last used first close
if (result! = NULL)
Result.close ();
if (pre! = null)
Pre.close ();
if (con! = null)
Con.close ();
SYSTEM.OUT.PRINTLN ("The database connection is closed! ");
}
catch (Exception e)
{
E.printstacktrace ();
}
}
}

Example code for Java connection to an Oracle database