useroperate.java

一个完整的办公资源管理系统

package org.qiming.tianke.operate;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.qiming.tianke.common.DataBaseConnection;



public class UserOperate {

	public UserOperate() {

	}

	public static boolean checkUser(String userAccount, String password) {
		boolean flag = false;
		String sql = "select * from userInfo where userAccount='" + userAccount
				+ "' and password='" + password + "'";
		System.out.print(sql);
		DataBaseConnection aConnection=new DataBaseConnection();
        ResultSet re=aConnection.doQuery(sql);
        try {
			while(re.next()){
				flag=true;			
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			aConnection.doClose();
		}
		return flag;
	}
}