userbo.java

一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份文件

package com.BO;

import com.CDB.dataBase;
import java.sql.*;
import java.util.*;
import com.VO.*;

public class userBO {
	dataBase db;

	public userBO() {
		db = new dataBase();
	}

	public int userLogin(String userName, String userPass) {

		String sql = "select * from admin where userName='" + userName + "'";
		ResultSet rs = db.sqlFind(sql);

		try {
			if(rs.next()) {
				if (userName.equals(rs.getString(3))) {
					if (userPass.equals(rs.getString(5))) {
						if (rs.getString(6).equals("1")) {
							return 1;
						} else
							return 2;
					} else

						return 3;

				} else
					return 4;
			}

		} catch (Exception e) {
			System.out.println("userLogin Error!!" + e.toString());

		}
		return 0;
	}

	/*
	 * public ArrayList userCheck() { ArrayList list = new ArrayList(); String
	 * sql = "select * from admin"; ResultSet rs = db.sqlFind(sql); try { while
	 * (rs.next()) { String userID = rs.getString(1); String userName =
	 * rs.getString(2); String userNumber = rs.getString(3); String userPass =
	 * rs.getString(4); String userCheck = rs.getString(5); userVO vo = new
	 * userVO(); vo.setUserID(userID); vo.setUserName(userName);
	 * vo.setUserNumber(userNumber); vo.setUserPass(userPass);
	 * vo.setUserCheck(userCheck); list.add(vo); } } catch (Exception e) {
	 * System.out.println("usercheck" + e.getMessage()); } return list; }
	 */
	public ArrayList userCheck1(String username) {
		ArrayList list = new ArrayList();
		String sql = "select * from admin where userName like'%" + username
				+ "%'";
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
				String userID = rs.getString(1);
				String userNumber = rs.getString(2);
				String userName = rs.getString(3);
				String userTime = rs.getString(4);
				String userPass = rs.getString(5);
				String userCheck = rs.getString(6);
				userVO vo = new userVO();
				vo.setUserID(userID);
				vo.setUserNumber(userNumber);
				vo.setUserName(userName);
				vo.setUserTime(userTime);
				vo.setUserPass(userPass);
				vo.setUserCheck(userCheck);
				list.add(vo);

			}
		} catch (Exception e) {
			System.out.println("usercheck" + e.getMessage());
		}
		return list;
	}

	public boolean stopUser(String userID) {
		String sql = "update admin set userCheck='" + 0 + "' where userID='"
				+ userID + "'";
		db.sqlUpdata(sql);
		return true;
	}

	public boolean startUser(String userID) {
		String sql = "update admin set userCheck='" + 1 + "' where userID='"
				+ userID + "'";
		db.sqlUpdata(sql);
		return true;
	}

	public boolean updateUser(String userName, String newPass) {

		String sql = "select * from admin where userName='" + userName + "'";
		ResultSet rs = db.sqlFind(sql);
		try {
			if (rs.next()) {
				sql = "update admin set userPass='" + newPass
						+ "' where userName='" + userName + "'";
				db.sqlUpdata(sql);
				return true;
			} else {
				return false;
			}
		} catch (Exception e) {
			System.out.println("updateUser Error!!" + e.getMessage());
			return false;
		}

	}

	public boolean rootUser(String userName, String userPass) {

		if (userName.equals("root") && userPass.equals("root")) {
			return true;
		} else {
			return false;
		}
	}

	public boolean addUser(String userNumber,String userName,String userTime,String userPass) {
		String sql = "insert admin values('" + userNumber + "','" + userName
				+ "','" + userTime + "','" + userPass + "','1')";
		db.sqlUpdata(sql);
		return true;
	}

	public boolean updateTime(String userName, String ZCCJtime) {
		String sql = "update admin set userTime='" + ZCCJtime
				+ "' where userName='" + userName + "'";
		db.sqlUpdata(sql);
		return true;
	}
}