Several ways Java uses JDBC to connect to a database

/**

* 1 Curing the connection parameters in the method

*

* @return Database connection

*/

public Connection getconnection () {

Connection conn = null;

try {

class.forname ("Com.mysql.jdbc.Driver");

conn = drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test", "Root", "");

return conn;

} catch (Exception e) {

e.printstacktrace ();

}

return null;

}

/**

* 2 Pass Connection parameters by method parameter mode

*

* @return Database connection

*/

Public Connection getconnection (string driver, string URL, string user, string password) {

Connection conn = null;

try {

Class.forName (driver);

conn = drivermanager.getconnection (URL, user, password);

return conn;

} catch (Exception e) {

e.printstacktrace ();

}

return null;

}

/**

* 3 Flexibility to configure the connection parameters through the properties configuration file, property name curing

*

* @return Database connection

*/

public Connection openconnection () {

Connection conn = null;

String Driver = "";

String url = "";

String user = "";

String password = "";

Properties Props = new properties ();

try {

Props.load (This.getclass (). getClassLoader ()

. getResourceAsStream ("db.properties"));

url = props.getproperty ("Mysql_url");

Driver = Props.getproperty ("Mysql_driver");

user = Props.getproperty ("Mysql_user");

password = props.getproperty ("Mysql_password");

Class.forName (driver);

conn = drivermanager.getconnection (URL, user, password);

return conn;

} catch (Exception e) {

e.printstacktrace ();

}

return null;

}

Several ways Java uses JDBC to connect to a database