Connecting to the Oracle Database helper class is to encapsulate the method that connects the Oracle database, just call it on the other page and do not need to repeat the write.
Import Java.sql.connection;import Java.sql.drivermanager;import java.sql.sqlexception;import Oracle.jdbc.driver.OracleDriver;/** * Database Connection Help class * @author ZQL_PC **/ Publicclass Dbhelp {/** Database Connection*/ Publicstatic Connection Lianjie () {//Database Configuration String driver="Oracle.jdbc.driver.OracleDriver";//Drive String URL="Jdbc:oracle:thin:@localhost:1521: Jbitdb "; StringUser ="Epet"; String pwd="123456"; try {//First step: Load the driver class.forname (driver);// --> ReflectionConnection Conn=Drivermanager.getconnection (URL,User, PWD); returnConn } catch (ClassNotFoundException e) {e.printstacktrace (); } catch (SQLException e) {e.printstacktrace (); } return null;
}
}
Connecting Oracle Database Help classes