courseejbtest.java

structejbmysql开发工程源码

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

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.ejb.login.Login;
import course.sys.Param;

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

//	private course.ejb.SearchHome getHome() throws NamingException {
//		return (course.ejb.SearchHome) getContext().lookup(
//				course.ejb.SearchHome.JNDI_NAME);
//	}
	private course.ejb.login.LoginHome getHome() throws NamingException {
		return (course.ejb.login.LoginHome) getContext().lookup(
				course.ejb.login.LoginHome.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 void testBean() {

		try {
//			course.ejb.Search myBean = getHome().create();
            course.ejb.login.Login   login= getHome().create();
			//--------------------------------------
			//This is the place you make your calls.
			
//			ArrayList list = myBean.getScoreByCourse("1");
//			KeChengChengJi k = (KeChengChengJi)list.get(0);
//			System.out.println("name"+k.getName());
//			ArrayList list1 = myBean.getScoreByName("1");
//      ChengJi c = (ChengJi)list1.get(0);
//			System.out.println("name"+c.getScore());
//			ArrayList list2 = myBean.getScoreById("0001");
//      ChengJi c1 = (ChengJi)list2.get(0);
//			System.out.println("name"+c1.getScore());
//			
//			
//			System.out.println("0");

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

	public static void main(String[] args) {
		CourseEjbTest test = new CourseEjbTest();
		test.testBean();
//		String name = null;
//		try {
//			Class.forName(Param.JDBCDriver).newInstance();
//			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
//			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetName);
//			pstmt.setString(1, "0001");
//			ResultSet rs = pstmt.executeQuery();
//			if (rs.next()) {
//				name = rs.getString("name");
//				System.out.println(name);
//			}
//			rs.close();
//			pstmt.close();
//			conn.close();
//		} catch (Exception e) {
//			e.printStackTrace();
//		}

	}
}