import javax.sql.*;
import java.sql.*;
import javax.naming.*;
/**
 *
 * @author snowman
 */
public class Connector {
    public static Connection conn=null;
    /** Creates a new instance of Connector */
    public Connector() {
    }
    public static Connection getConnection(){
        String driver="net.sourceforge.jtds.jdbc.Driver";
        String dbUsr="sa";
        String dbPass="12345";
        String dbUrl="jdbc:jtds:sqlserver://127.0.0.1:1433/db_adi";
       // Context initCtx;
        try {
            Class.forName(driver);
            conn=DriverManager.getConnection(dbUrl,dbUsr,dbPass);
//initCtx = new InitialContext();
            //DataSource ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/mssql");
        } catch (Exception ex) {
            try {
                conn.close();
            } catch (SQLException sqle) {
                LM.warn(sqle.getMessage());
                System.out.println(sqle);            }
        }
        return conn;
    }
    
}