zjgp1bean.java

structejbmysql开发工程源码

/*
 * Created on 2007-5-6
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package course.ejb.zjgp1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import javax.ejb.SessionBean;

import course.data.zjgp1.Zjgp1Data;
import course.sys.Param;
import course.sys.zjgp1.ParamZjgp1;

/**
 * 
 * <!-- 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>Zjgp1 </j2ee:display-name>
 * <j2ee:ejb-name>Zjgp1 </j2ee:ejb-name>
 * <j2ee:ejb-class>course.ejb.zjgp1.Zjgp1Bean </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="Zjgp1" jndi-name="Zjgp1" 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="Zjgp1" jndi-name="Zjgp1" -- <!-- end-xdoclet-definition
 *             -->
 * @generated
 */
public abstract class Zjgp1Bean implements javax.ejb.SessionBean {

	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getResCash(String userName) {
		ArrayList list = new ArrayList();
		try {

			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn
					.prepareStatement(ParamZjgp1.SQLGetResCash);
			pstmt.setString(1, userName);
			ResultSet rs = pstmt.executeQuery();
			if (rs.next()) {

				list.add(rs.getString("cashCanUsed"));
				list.add(rs.getString("sumOfWth"));
				list.add(rs.getString("numOfDone"));
				list.add(rs.getString("incOfDay"));
				list.add(rs.getString("incOfWeek"));
				list.add(rs.getString("inc"));
				list.add(rs.getString("dayOfReg"));
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * @ejb.interface-method view-type="remote"
	 */
	public ArrayList getResStk(String userName) {
		ArrayList list = new ArrayList();

		try {

			Class.forName(Param.JDBCDriver).newInstance();
			Connection conn = DriverManager.getConnection(Param.JDBCUrl);
			PreparedStatement pstmt = conn
					.prepareStatement(ParamZjgp1.SQLGetResStk);
			pstmt.setString(1, userName);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				Zjgp1Data zjgp1Data = new Zjgp1Data();
				zjgp1Data.setStkID(rs.getString("stkID"));
				zjgp1Data.setStkName(rs.getString("stkName"));
				zjgp1Data.setStkSumNum(rs.getString("stkSumNum"));
				zjgp1Data.setStkCanUsed(rs.getString("stkCanUsed"));
				zjgp1Data.setPriBuyIn(rs.getString("priBuyIn"));
				zjgp1Data.setPriSelNow(rs.getString("priSelNow"));
				zjgp1Data.setNumGetLos(rs.getString("numGetLos"));
				zjgp1Data.setPri(rs.getString("pri"));
				zjgp1Data.setPriStpLos(rs.getString("priStpLos"));
				zjgp1Data.setStkState(rs.getString("stkState"));
				list.add(zjgp1Data);
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
}