/*
 * Created on 2007/03/05
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package access.sell;

import java.rmi.RemoteException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Hashtable;

import javax.ejb.CreateException;
import javax.naming.InitialContext;
import javax.naming.NamingException;

import course.data.ChengJi;
import course.data.KeChengChengJi;
import course.data.buy.Buy;
import course.data.buy.UserInf;
import course.data.login.Login;
import course.ejb.login.LoginHome;

/**
 * @author itsuser
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class SellEjb {

    private course.ejb.sell.SellHome getHome() throws NamingException {
		return (course.ejb.sell.SellHome) getContext().lookup(
		        course.ejb.sell.SellHome.JNDI_NAME);
	}

	private InitialContext getContext() throws NamingException {
		Hashtable props = new Hashtable();

		props.put(InitialContext.INITIAL_CONTEXT_FACTORY,
				"org.jnp.interfaces.NamingContextFactory");
		props.put(InitialContext.PROVIDER_URL, "jnp://127.0.0.1:1099");

		// This establishes the security for authorization/authentication
		// props.put(InitialContext.SECURITY_PRINCIPAL,"username");
		// props.put(InitialContext.SECURITY_CREDENTIALS,"password");

		InitialContext initialContext = new InitialContext(props);
		return initialContext;
	}

	public String getStkCanUsed(String userName,String stkID) {
		String cashCanUsed = null;

		try {
		    course.ejb.sell.Sell sell = getHome().create();

			cashCanUsed = sell.getStkCanUsed(userName,stkID);

		} catch (RemoteException e) {
			e.printStackTrace();
		} catch (CreateException e) {
			e.printStackTrace();
		} catch (NamingException e) {
			e.printStackTrace();
		}
		return cashCanUsed;
	}

	public ArrayList getStkInf(String stkID) {
		ArrayList list = null;

		try {
		    course.ejb.sell.Sell sell = getHome().create();

			list = sell.getStkInf(stkID);

		} catch (RemoteException e) {
			e.printStackTrace();
		} catch (CreateException e) {
			e.printStackTrace();
		} catch (NamingException e) {
			e.printStackTrace();
		}
		return list;
	}

	public void InsertStkOwnInf(Buy buyData) {

		try {
		    course.ejb.sell.Sell sell = getHome().create();

		    sell.InsertStkOwnInf(buyData);

		} catch (RemoteException e) {
			e.printStackTrace();
		} catch (CreateException e) {
			e.printStackTrace();
		} catch (NamingException e) {
			e.printStackTrace();
		}
	}

	public void UpdateUserInf(UserInf userInf) {

		try {
		    course.ejb.sell.Sell sell = getHome().create();

		    sell.UpdateUserInf(userInf);

		} catch (RemoteException e) {
			e.printStackTrace();
		} catch (CreateException e) {
			e.printStackTrace();
		} catch (NamingException e) {
			e.printStackTrace();
		}

	}

}