public class SQLconnection {
/** Name of connection database */
private static String username;
/** password to connect to database */
private static String userpwd;
/** Path to connection database */
private static String URL;
/**
* Static initialization block, get the necessary parameters of database connection from the properties file
The contents of the *properties file include
*url:jdbc:mysql://127.0.0.1:3306/crm\?useunicode=true&characterencoding=utf-8
*name:root
*pwd:admin
*/
static{
Properties Pro = new properties ();
try {
Pro.load (New FileInputStream ("./src/sql.properties"));
Url=pro.getproperty ("url");
Username=pro.getproperty ("name");
Userpwd=pro.getproperty ("pwd");
} catch (IOException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
/**
* Join Database
* @return a digital library connection
*/
public static Connection getconnection () {
Connection conn = null;
try {
Class.forName ("Com.mysql.jdbc.Driver");
conn = Drivermanager.getconnection (URL,USERNAME,USERPWD);
} catch (ClassNotFoundException e) {
TODO auto-generated Catch block
E.printstacktrace ();
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
Return conn;
}
/**
* Close Database connection
* @param conn A database connection
*/
public static void CloseConnection (Connection conn) {
try {
Conn.close ();
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
}
MySQL program and database connection Help