Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import com.mysql.jdbc.Connection;
- import java.sql.*;
- import java.sql.DriverManager;
- /**
- * @desc A singleton database access class for MySQL
- * @author Ramindu
- */
- public final class MysqlConnect {
- public Connection conn;
- private Statement statement;
- public static MysqlConnect db;
- private MysqlConnect() {
- String url= "jdbc:mysql://localhost:3306/";
- String dbName = "database_name";
- String driver = "com.mysql.jdbc.Driver";
- String userName = "username";
- String password = "password";
- try {
- Class.forName(driver).newInstance();
- this.conn = (Connection)DriverManager.getConnection(url+dbName,userName,password);
- }
- catch (Exception sqle) {
- sqle.printStackTrace();
- }
- }
- /**
- *
- * @return MysqlConnect Database connection object
- */
- public static synchronized MysqlConnect getDbCon() {
- if ( db == null ) {
- db = new MysqlConnect();
- }
- return db;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement