Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.92 KB | None | 0 0
  1. public class DBHelperMysql {
  2.     private final String dbHost;
  3.     private final String dbUser;
  4.     private final String dbPassword;
  5.     private org.slf4j.Logger logger;
  6.     public final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  7.  
  8.     public DBHelperMysql(String dbHost, String dbUser, String dbPassword, Logger logger) {
  9.         //STEP 2: Register JDBC driver
  10.         this.logger = logger;
  11.         this.dbHost = dbHost;
  12.         this.dbUser = dbUser;
  13.         this.dbPassword = dbPassword;
  14.     }
  15.  
  16.     public void init() throws ClassNotFoundException {
  17.         Class.forName(JDBC_DRIVER);
  18.     }
  19.  
  20.     synchronized public Statement open() throws ClassNotFoundException, SQLException {
  21.         Connection conn = DriverManager.getConnection(String.format("jdbc:mysql://%s?useUnicode=true&characterEncoding=UTF-8", dbHost), dbUser, dbPassword);
  22.         Statement stmt = conn.createStatement();
  23.         return stmt;
  24.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement