Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class DBHelperMysql {
- private final String dbHost;
- private final String dbUser;
- private final String dbPassword;
- private org.slf4j.Logger logger;
- public final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
- public DBHelperMysql(String dbHost, String dbUser, String dbPassword, Logger logger) {
- //STEP 2: Register JDBC driver
- this.logger = logger;
- this.dbHost = dbHost;
- this.dbUser = dbUser;
- this.dbPassword = dbPassword;
- }
- public void init() throws ClassNotFoundException {
- Class.forName(JDBC_DRIVER);
- }
- synchronized public Statement open() throws ClassNotFoundException, SQLException {
- Connection conn = DriverManager.getConnection(String.format("jdbc:mysql://%s?useUnicode=true&characterEncoding=UTF-8", dbHost), dbUser, dbPassword);
- Statement stmt = conn.createStatement();
- return stmt;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement