p1000101dataaccessbean.java

物流管理系统的登录模块及其他功能模块

package com.zzrd.j60.p100.dataaccessbean;

import java.sql.ResultSet;
import java.sql.Statement;

import com.zzrd.j60.p100.common.ConnDb;
import com.zzrd.j60.p100.databean.MJ10P000DataBean;

/**
系统名：物流系统 <br>
功能概要: 取得用户信息 <br>
完成者: <br>
完成日: <br>
*/
public class P1000101DataAccessBean {
	
	/**
	 * 检索用户信息 <br>
	 * @param usrCd 用户代码 <br>
	 * @return mj10p000DataBean用户信息 <br>
	 * @throws Exception <br>
	 */
	public MJ10P000DataBean selUsrMsg(String usrCd) throws Exception{
		/*变量定义*/
		StringBuffer sqlBuffer = new StringBuffer();
		Statement statement = null;
		ResultSet resultSet = null;
		MJ10P000DataBean dataBean = new MJ10P000DataBean();
		/*检索语句*/
		sqlBuffer.append("SELECT \n");
		sqlBuffer.append("       USR_CD \n");
		sqlBuffer.append("       ,PASSWORD \n");
		sqlBuffer.append("       ,USR_NAME \n");
		sqlBuffer.append("FROM \n");
		sqlBuffer.append("       MJ60S010 \n");
		sqlBuffer.append("WHERE \n");
		sqlBuffer.append("       USR_CD = '" + usrCd + "' \n");
		try{
			/*连接数据库*/
			ConnDb.dbOpen();
			statement = ConnDb.conn.createStatement();
			//检索结果
			resultSet = statement.executeQuery(sqlBuffer.toString());
			/*将检索结果赋值到databean中*/
			while(resultSet.next()){
				dataBean.setUSR_CD(resultSet.getString("USR_CD"));
				dataBean.setPASSWORD(resultSet.getString("PASSWORD"));
				dataBean.setUSR_NAME(resultSet.getString("USR_NAME"));
			}	
		}catch(Exception e){
			ConnDb.conn.rollback();
			throw e;			
		}finally{
			//ResultSet关闭
			resultSet.close();
			//statement关闭
			statement.close();
			//数据库关闭
			ConnDb.dbClose();
		}
		//返回值 用户信息
		return dataBean;
	}
}