userdbimp.java

来自「BUG跟踪系统是用来对开发软件时发现的bug进行跟踪。里面包括用户管理模块」· Java 代码 · 共 33 行

package su.bts1.imp;

import java.sql.Connection;
import java.sql.SQLException;

import su.bts1.bean.UserFormBean;
import su.bts1.dao.DbOperator;
import su.bts1.dao.IUserDB;

public class UserDBImp extends IUserDB {

	private static final String SELECT_USER = "select * from user Where u_name='";

	private  DbOperator db = null;

	public UserDBImp(UserFormBean userBean) {
		this.userBean = userBean;
	}

	@Override
	public boolean selectUser(Connection conn) throws SQLException {

		this.db = new DbOperatorImp(conn);
		if (db.select(
				SELECT_USER + userBean.getUserName() + "' and u_psd ='"
						+ userBean.getPassword() + "'" + " and u_dep ='"
						+ userBean.getDepartID() + "'").next())
			return true;
		return false;
	}

}