Oracle Database Help
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;
}
}