programerdbimp.java

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

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 ProgramerDBImp extends IUserDB {
	private static final String SELECT_PROGRAMER = "select * from user Where u_name='";

	private static DbOperator db = null;

	public ProgramerDBImp(UserFormBean adminBean) {
		this.userBean = adminBean;
	}

	@Override
	public boolean selectUser(Connection conn) throws SQLException {
		this.db = new DbOperatorImp(conn);
		if (db.select(
				SELECT_PROGRAMER + userBean.getUserName() + "' and u_psd ='"
						+ userBean.getPassword() + "'" + " and u_dep ='"
						+ userBean.getDepartID() + "'").next())
			return true;
		return false;
	}

}