loginbean.java

structejbmysql开发工程源码

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

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

import javax.ejb.SessionBean;

import course.sys.Param;
import course.sys.login.ParamLogin;

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

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