The Oracle database connection test is a database connection test class, which can be easily used after being saved. Www.2cto.com DBTest. java testing Java code import java. SQL. *; public class DBTest {/*** @ param args */public static void main (String [] args) {// TODO Auto-generated method stub try {OracleConn oc = new OracleConn (); Connection conn = oc. oracleGetConn (); Statement stmt = conn. createStatement (); stmt.exe cute ("select * from SECURITY_ASSETS"); ResultSet rs = stmt. getResultSet (); System. out. println ("------ [Java connection to Oracle Database test] ------"); System. out. println ("----------------------------------------------"); System. out. println ("ID" + "|" + "NAME" + "|" + "SYSTEM" + "|" + "IP" + "|" + "STATUS "); system. out. println ("----------------------------------------------"); while (rs. next () {System. out. println (rs. getString (1) + "|" + rs. getString (2) + "|" + rs. getString (3) + "|" + rs. getString (4) + "|" + rs. getString (5) ;}} catch (Exception e) {e. printStackTrace () ;}} OracleConn. java --- oracle database connection information Java code import java. SQL. connection; import java. SQL. driverManager; public class OracleConn {Connection conn; public Connection oracleGetConn () {String driver = "oracle. jdbc. driver. oracleDriver "; String url =" jdbc: oracle: thin: @ 111.1.46.68: 1521: smp "; try {Class. forName (driver); conn = DriverManager. getConnection (url, "smp", "smpsmp");} catch (Exception e) {System. out. println ("database connection failed for the following reasons:"); e. printStackTrace () ;}return conn ;}}