Connect to Oracle Database Help class, connect to Oracle Database
The Oracle Database Help class encapsulates the methods used to connect to the Oracle database, which can be called on other pages without repeated writes.
Import java. SQL. connection; import java. SQL. driverManager; import java. SQL. SQLException; import oracle. jdbc. driver. oracleDriver;/*** database Connection help class * @ author zql_pc **/public class DbHelp {/** database Connection */public static Connection lianjie () {// Database Configuration String driver = "oracle. jdbc. driver. oracleDriver "; // driver String url =" jdbc: oracle: thin: @ localhost: 1521: JBITDB "; String user =" epet "; String pwd =" 123456 "; try {// Step 1: load the driver Class. forName (driver); // --> reflection Connection conn = DriverManager. getConnection (url, user, pwd); return conn;} catch (ClassNotFoundException e) {e. printStackTrace ();} catch (SQLException e) {e. printStackTrace ();} return null;
}
}