userloginmanager.java

基于java的图文报表系统的设计与实现,报表的生成一直是企业级应用系统开发时专案人员所面临的严峻课题.同时也是信息化系统中重要的一环。优秀的报表工具以实现将数据转化为信息.为决策提供良好的依据.为信息

package manager;

import java.sql.Connection;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import pojo.UserBean;
import dbmaster.DbMaster;

public class UserLoginManager {
	QueryRunner run = new QueryRunner();

	ResultSetHandler rsh = null;

	public String validateIt(List param) {
		String username = (String) param.get(0);
		String password = (String) param.get(1);
		String j = "0";
		Connection con = null;
		try {
			con = DbMaster.createConn();

			String getUsersSql = "select * from yhb";

			rsh = new BeanListHandler(UserBean.class);
			List list = (List) run.query(con, getUsersSql, rsh);
			for (int i = 0; i < list.size(); i++) {
				UserBean userBean = (UserBean) list.get(i);
				String username2 = userBean.getYhxm().trim();
				String password2 = userBean.getMm().trim();
				if (username2.equals(username.trim())) {
					if (!password2.equals(password.trim())) {
						j = "1";
					} else {
						j = "2";
					}
				}
			}
		} catch (Exception e) {
			System.out.println("-->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e1) {
				System.out.println("-->" + e1);
			}
		}
		return j;
	}
}