Java Get database Connection __ Database

/**

*connectionutil. java

*

*

*/

Package COM.CAI.JDBC;

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import java.util.Properties;

public class Connectionutil {
/**
* 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/stud", "root", "root");

Return conn;

}catch (Exception e) {
E.printstacktrace ();
}
return null;
}

/**
* 2
* Passing connection parameters by means of parameter
* @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
* Flexible configuration of 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 ("dbconfig.properties"));
Driver = Props.getproperty ("Driver");
url = props.getproperty ("url");
user = Props.getproperty ("user");
Password = props.getproperty ("password");

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

Return conn;
}catch (Exception e) {
E.printstacktrace ();
}

return null;
}

public static void Main (String []args) {
Connectionutil cu = new Connectionutil ();

System.out.println ("1 、---->" + cu.getconnection ());
System.out.println ("2 、---->" + cu.getconnection ("Com.mysql.jdbc.Driver")
"Jdbc:mysql://localhost:3306/stud", "root", "root"));
System.out.println ("3 、---->" + cu.openconnection ());

}


}