Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package file;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class Utilities {
- // Constants
- public static String nameDriver = "com.mysql.jdbc.Driver";
- public static String url = "jdbc:mysql://127.0.0.1:3306/baitaplon";
- public static String user = "root";
- public static String password = "DaiCaPhong";
- // Static function - Open connection
- public static Connection createConnection() {
- Connection conn = null;
- try {
- // Load library of JDBC MySQL Driver into
- Class.forName(nameDriver);
- // Create connection
- conn = DriverManager.getConnection(url, user, password);
- } catch(Exception ex) {
- ex.printStackTrace();
- return null;
- }
- return conn;
- }
- public static void closeConnection(Connection conn) {
- try {
- if(conn!= null) {
- conn.close();
- conn = null;
- }
- }catch(SQLException ex) {
- ex.printStackTrace();
- conn = null;
- }
- }
- }
Add Comment
Please, Sign In to add comment