package webchurch.push.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Connector {
	private static Connection conn;
 
	public static Connection getConnection(){
		if(conn == null){
			setConnection();
		}
		return conn;
	}
	public static void setConnection(){
		String url = "jdbc:sqlserver://211.110.11.72:1433;databaseName=cmis";
		String user = "sa";
		String password = "sa72church";
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}		
		try {
			conn = DriverManager.getConnection(url, user, password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}