userbo.java

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

package C03.BO;

import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import C03.VO.*;

import C03.CDB.*;
import C03.CDB.*;

import java.util.*;
public class UserBO {
	dataBase db;

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

	public int findUserName(String name, String pwl) {
		int i = 0;
		String sql = "select * from maker where userName='" + name + "'";
		ResultSet rs = db.sqlFind(sql);
		try {
			if (rs.next()) {
				if (pwl.equals(rs.getString("userPass"))) {

					i = 1;
				} else
					i = 2;
			} else
				i = 0;

		} catch (Exception e) {
			System.out.println("CDB.Cdata.findUrserName 错误" + e.toString());
			i = -10;
		}
		return i;
	}

	public boolean insertUser(String username, String addUserPwl,
			String addUserGSMC, String addUserGSDZ,String ZCCJtime, String Maker_Cr_address,
			 String addUserZCmoney, String addUserQYFR,
			String Maker_fr_position, String Maker_Attribute,
			String addUserLXphone, String addUserEmail)
			throws UnsupportedEncodingException {
		String sql = "insert maker values('" + username + "','"
				+ addUserPwl + "','" + addUserGSMC + "','" + addUserGSDZ
				+ "','" + ZCCJtime + "','" + Maker_Cr_address + "','"
				+ addUserZCmoney + "','" + addUserQYFR + "','"
				+ Maker_fr_position + "','" + Maker_Attribute + "','"
				+ addUserLXphone + "','" + addUserEmail + "') ";
		sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
		return db.sqlUpdata(sql);

	}

	public userBean returnuser(String userName) {
		String sql = "select * from maker where userName='" + userName + "'";
		db = new dataBase();
		ResultSet rs = db.sqlFind(sql);

		try {
			if (rs.next()) {
				userBean bean = new userBean();
				bean.setMaker_id(rs.getString(1));
				bean.setUserName(rs.getString(2));
				bean.setUserPass(rs.getString(3));
				bean.setMaker_name(rs.getString(4));
				bean.setMaker_address(rs.getString(5));
			
				//bean.setMaker_address(rs.getString(6));
				bean.setMaker_Cr_time(rs.getString(6));
				bean.setMaker_Cr_address(rs.getString(7));
				bean.setMaker_Cr_cost(rs.getString(8));
				bean.setMaker_fr_name(rs.getString(9));
				bean.setMaker_fr_position(rs.getString(10));
				bean.setMaker_Attribute(rs.getString(11));
				bean.setMaker_phone(rs.getString(12));
				bean.setMaker_email(rs.getString(13));
				return bean;
			} else
				return null;
		} catch (Exception e) {
			System.out.println("BO.UserBO.returnuser()错误" + e.toString());
			return null;
		}

	}

	public boolean updatauserxinxi(String username, String Maker_name,
			String Maker_address, String Maker_Cr_address,
			String Maker_Cr_cost, String Maker_fr_name,
			String Maker_fr_position, String Maker_Attribute,
			String Maker_phone, String Maker_email)
			throws UnsupportedEncodingException {
		db = new dataBase();
		String sql = "update maker set Maker_name='" + Maker_name
				+ "',Maker_address='" + Maker_address + "',Maker_Cr_address='"
				+ Maker_Cr_address + "',Maker_Cr_cost='" + Maker_Cr_cost
				+ "',Maker_fr_name='" + Maker_fr_name + "',Maker_fr_position='"
				+ Maker_fr_position + "',Maker_Attribute='" + Maker_Attribute
				+ "',Maker_phone='" + Maker_phone + "',Maker_email='"
				+ Maker_email + "' where userName='" + username + "'";
		sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
		boolean i = db.sqlUpdata(sql);

		return i;
	}

	public boolean updatauserpass(String userName, String userPass) {
		System.out.println(userName);
		System.out.println(userPass);
		String sql = "update maker set userPass='" + userPass + "'";
		db = new dataBase();
		if (db.sqlUpdata(sql))
			return true;
		else
			return false;
	}
	public String reutrnmaker_id(String userName){
		String sql = "select * from maker where userName='"+userName+"'";
		db=new dataBase();
		ResultSet rs = db.sqlFind(sql);
		try{
			if(rs.next())
				return rs.getString(1);
			else return null;
		}catch(Exception e){
			
			System.out.println("BO.UserBO.returnmaker()错误"+e.toString());
			return null;
		}
		
	}

}