package gov.gdlt.ssgly.taxcore.taxblh.gzda.service.xmlinterface.impl;
import java.sql.*;
import java.util.Properties;
import java.io.*;
import java.util.*;
import javax.sql.*;
import javax.ejb.*;
import javax.sql.DataSource;
import java.rmi.RemoteException;
import javax.naming.*;
//import com.sybase.jdbc2.jdbc.*;
import javax.transaction.UserTransaction;

import gov.gdlt.ssgly.taxcore.comm.dao.*;
import gov.gdlt.ssgly.taxcore.comm.servicelocator.SqlMapLocator;
import gov.gdlt.ssgly.taxcore.comm.config.ApplicationContext;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.common.util.PaginatedList;

public class ConFactor {
    private static DataSource datasource=null;
    private static UserTransaction tx=null;

    /**
        public static  Connection getConnJdbc(){
           Connection conn=null;
           SqlMapClient sqlMap=SqlMapLocator.getInstance().getSqlMapClient();
           //System.out.print("11111111111111="+sqlMap);
        try {
            sqlMap.startTransaction();
            conn = sqlMap.getCurrentConnection();
            System.out.print("22222222222222="+conn);
            sqlMap.commitTransaction();

        } catch (SQLException ex) {
            System.out.print(ex.toString());
        }finally{
        try {
            sqlMap.endTransaction();
        } catch (SQLException ex1) {
        }
        }
           //String drive=ReadXml.getInstance().readInit("JDBC.Driver");
           //String url=ReadXml.getInstance().readInit("JDBC.ConnectionURL");
           //String user=ReadXml.getInstance().readInit("JDBC.Username");
           //String pass=ReadXml.getInstance().readInit("JDBC.Password");

           //try{
           //  Class.forName(drive);
           //  conn = DriverManager.getConnection(url,user,pass);
           //}catch (ClassNotFoundException ce){
           //  System.out.println(ce.toString());
           //}catch (SQLException se){
           //  System.out.print(se.toString());
           //}
          return conn;
         }
**/
         public static Connection getConnectFromT3(String type){
           Connection conn=null;

           try{
             String datasource=XmlConfig.getInstance().readInit("datasource");
             Context initContext = new InitialContext();
             Context envContext = (Context) initContext.lookup("java:/comp/env");
             DataSource ds = (DataSource) envContext.lookup(datasource);
             conn = ds.getConnection();
           }catch(SQLException e){
               }
           catch(javax.naming.NamingException ne){
           }

           return conn;
         }

public static Connection getConnectFromT3(){
           Connection conn=null;
           setEntityContext();
           try
           {
             return datasource.getConnection();
           }
           catch(SQLException e){System.out.println("不能取到pool中的datasource:"+e.toString());
             return null;
           }


         }

 private static Context getInitialContext() throws Exception{
   String user = null;
   String password = null;
   Properties properties = null;
   String ls_tserver;
 try {

    //XmlConfig xmlconfig=XmlConfig.getInstance();

    //ls_tserver=xmlconfig.readInit("tserver");
    //ls_tserver=ReadXml.getInstance().readInit("DataSource");
    ls_tserver="t3://localhost:7001";

   properties = new Properties();
   properties.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
   properties.put(Context.PROVIDER_URL, ls_tserver);
   if (user != null){
     properties.put(Context.SECURITY_PRINCIPAL, user);
     properties.put(Context.SECURITY_CREDENTIALS, password == null ? "" : password);
   }

   return new InitialContext(properties);
 } catch(Exception e) {
    throw e;
 }
}

 private static void setEntityContext(){
 try{
   String ls_datasource;
   //XmlConfig xmlconfig=XmlConfig.getInstance();
   ls_datasource=ReadXml.getInstance().readInit("DataSource");
    System.out.println("99999999999999="+ls_datasource);
   javax.naming.Context context = new javax.naming.InitialContext();
   context=getInitialContext();
   try    {
     datasource = (DataSource) context.lookup(ls_datasource);
   }catch(Exception e) {
     throw new EJBException("Error looking up dataSource: " + e.toString());
   }
 }catch(Exception e) {
      throw new EJBException("Error initializing context:" + e.toString());
  }
 }

 public static UserTransaction getTransaction() throws NamingException{
   javax.naming.Context context=null;
   try{
        context = new javax.naming.InitialContext();
        context = getInitialContext();

   }catch(Exception e){
   }
   tx = (UserTransaction)context.lookup("javax.transaction.UserTransaction");
  return tx;

 }

}