Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.crmapp;
- import java.sql.*;
- import javax.sql.DataSource;
- import javax.naming.*;
- public class MySqlDAOFactory extends DAOFactory {
- public static final String DRIVER = "com.mysql.jdbc.Driver";
- public static final String dbURL = "jdbc:mysql://localhost:3306/crmdb?autoReconnect=true&useSSL=false";
- private static final String user = "root";
- private static final String pass = "krut";
- private static Connection conn = null;
- private static DataSource ds = null;
- public static Connection createConnection() {
- try {
- InitialContext ctx = new InitialContext();
- ds = (DataSource)ctx.lookup("java:jboss/datasources/crmdb");
- conn = ds.getConnection();
- } catch (NamingException e) {
- e.printStackTrace();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- return conn;
- }
- @Override
- public CustomerDao getCustomerDAO() {
- return new CustomerDaoImpl();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement