searchbean.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 course.ejb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import course.data.ChengJi;
import course.data.Course;
import course.data.KeChengChengJi;
import course.data.Name;
import course.sys.Param;

/**
 * 
 * <!-- begin-user-doc --> A generated session bean <!-- end-user-doc --> * <!--
 * lomboz.beginDefinition --> <?xml version="1.0" encoding="UTF-8"?> <lomboz:EJB
 * xmlns:j2ee="http://java.sun.com/xml/ns/j2ee"
 * xmlns:lomboz="http://lomboz.objectlearn.com/xml/lomboz"> <lomboz:session>
 * <lomboz:sessionEjb><j2ee:display-name>Search </j2ee:display-name>
 * <j2ee:ejb-name>Search </j2ee:ejb-name> <j2ee:ejb-class>course.ejb.SearchBean
 * </j2ee:ejb-class> <j2ee:session-type>Stateless </j2ee:session-type>
 * <j2ee:transaction-type>Container </j2ee:transaction-type>
 * </lomboz:sessionEjb> </lomboz:session> </lomboz:EJB> <!--
 * lomboz.endDefinition -->
 * 
 * <!-- begin-xdoclet-definition -->
 * 
 * @ejb.bean name="Search" jndi-name="Search" type="Stateless"
 *           transaction-type="Container"
 *  -- This is needed for JOnAS. If you are not using JOnAS you can
 * safely remove the tags below.
 * @jonas.bean ejb-name="Search" jndi-name="Search"
 *  -- <!-- end-xdoclet-definition -->
 * @generated
 */
public abstract class SearchBean implements javax.ejb.SessionBean {

	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public String getName(String id) {

		String name = null;
		try {
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetName);
			pstmt.setString(1, id);
			ResultSet rs = pstmt.executeQuery();
			if (rs.next()) {
				name = rs.getString("name");
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return name;
	}
	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getNameList() {

		ArrayList list = new ArrayList();
		try {
			
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetNameList);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				list.add(rs.getString("name"));
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getCourseList() {

		ArrayList list = new ArrayList();
		try {
			
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetCourseList);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				list.add(rs.getString("course"));
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public String getId(String name) {
		String id = null;
		try {
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetId);
			pstmt.setString(1, name);
			ResultSet rs = pstmt.executeQuery();
			if (rs.next()) {
				id = rs.getString("id");
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return id;
	}

	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getScoreById(String id) {
		ArrayList list = new ArrayList();
		try {
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetScoreById);
			pstmt.setString(1, id);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
			    list.add(new ChengJi(rs.getString("course"),rs.getInt("score")));
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getScoreByName(String name) {
		
		ArrayList list = new ArrayList();
		try {
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetScoreByName);
			pstmt.setString(1, name);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				list.add(new ChengJi(rs.getString("course"),rs.getInt("score")));
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}return list;
	}
	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getScoreByCourse(String course) {
		
		ArrayList list = new ArrayList();
		try {
			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn.prepareStatement(Param.SQLGetScoreByCourse);
			pstmt.setString(1, course);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				list.add(new KeChengChengJi(rs.getString("id"),rs.getString("name"),rs.getInt("score")));
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}return list;
	}
}