package jabook.sql;

import java.sql.*;

public class ConnectionFactory {
	private static ConnectionFactory connectionFactory = new ConnectionFactory();
	
	private ConnectionFactory(){};
	
	public static ConnectionFactory getDefaultFactory(){
		if(connectionFactory == null){
			connectionFactory = new ConnectionFactory();
		}
		
		return connectionFactory;
	}
	
	public Connection createConnection() {
		Connection connection = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch(ClassNotFoundException cnfe) {
			System.out.println(cnfe);
		}
			
		String url = "jdbc:mysql://localhost:3306/novel";
		String user = "root";
		String password = "1053";
		
		try {
			connection = DriverManager.getConnection(url, user, password);
		} catch(SQLException sqle) {
			System.out.println(sqle);
		}
		
		return connection;
	}
}