import java.sql.*; /** * A JDBC test application for Oracle * @author Fane * @version 1.0.0 * @since JDK1.4 */ public class OracleTest { PRivate final String oracleDriverName = "oracle.jdbc.driver.OracleDriver";
//以下使用的Test就是Oracle里的表空间 private final String oracleUrlToConnect ="jdbc:oracle:thin:@192.168.0.36:1521:Test"; private Connection myConnection = null; /** * To load the jdbc driver * */ public OracleTest() { try { Class.forName(oracleDriverName); }catch(ClassNotFoundException ex) { System.out.println(getErrorMessage(ex,"The Driver loaded error,please contact to your Software Designer!").toString()); } }
public StringBuffer getErrorMessage(Exception ex,String alarmMessage) { StringBuffer errorStringBuffer = new StringBuffer(); errorStringBuffer.append(alarmMessage); errorStringBuffer.append(ex.getMessage()); return errorStringBuffer; }