/*
 * 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.zjgp1;

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.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 Zjgp1Ejb {

	private course.ejb.zjgp1.Zjgp1Home getHome() throws NamingException {
		return (course.ejb.zjgp1.Zjgp1Home) getContext().lookup(
				course.ejb.zjgp1.Zjgp1Home.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 ArrayList getResCash(String userName) {
		ArrayList list = null;

		try {
			course.ejb.zjgp1.Zjgp1 zjgp1 = getHome().create();

			list = zjgp1.getResCash(userName);

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

	public ArrayList getResStk(String userName) {
		ArrayList list = null;

		try {
			course.ejb.zjgp1.Zjgp1 zjgp1 = getHome().create();

			list = zjgp1.getResStk(userName);

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

}