"Go" example code for a very standard Java connection to an Oracle database

Original address: http://www.cnblogs.com/liuxianan/archive/2012/08/05/2624300.html

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:

1 /**2 * A very standard example code for connecting to an Oracle database3  */4  Public voidtestoracle ()5 {6Connection con =NULL;//Create a connection to a database7PreparedStatement pre =NULL;//Create precompiled statement objects, usually with this instead of statement8ResultSet result =NULL;//Create a result set object9     TryTen     { OneClass.forName ("Oracle.jdbc.driver.OracleDriver");//load the Oracle driver ASystem.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";//user name, system default account name theString Password = "147";//The password you selected when you installed the settings -con = drivermanager.getconnection (url, user, password);//Get Connections -SYSTEM.OUT.PRINTLN ("Connection Successful! "); -String sql = "SELECT * from student where name=?";//precompiled statement, "? The delegate parameter +Pre = con.preparestatement (SQL);//Instantiating precompiled Statements -Pre.setstring (1, "Liu Xianhan");//The parameter is set, and the previous 1 indicates the index of the parameter, not the index of the column name in the table +result = Pre.executequery ();//Execute the query, note that no additional arguments are required in parentheses A          while(Result.next ()) at             //When the result set is not empty -System.out.println ("School Number:" + result.getint ("id") + "name:" -+ result.getstring ("name")); -     } -     Catch(Exception e) -     { in e.printstacktrace (); -     } to     finally +     { -         Try the         { *             //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 closePanax Notoginseng             if(Result! =NULL) - result.close (); the             if(Pre! =NULL) + pre.close (); A             if(Con! =NULL) the con.close (); +SYSTEM.OUT.PRINTLN ("The database connection is closed! "); -         } $         Catch(Exception e) $         { - e.printstacktrace (); -         } the     } -}

This is my copy of a piece of code, feeling written more organized than I, so specifically turn around

"Go" example code for a very standard Java connection to an Oracle database