userinfobean.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuBean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class UserInfoBean {
	private User aUser;

	public UserInfoBean() {
		// default
	}

	public User getUserInfo(String username) {
		try {
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找该用户的定单
			String query = "select * from UserInfo where username like '"
					+ username + "'";
			ResultSet rs = sqlstatement.executeQuery(query);

			while (rs.next()) {
				String realname = rs.getString("realname");
				String email = rs.getString("email");
				String accountNum = rs.getString("accountNum");
				aUser = new User(username, realname, email, accountNum);
			}

			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());
		} catch (Exception e) {
			System.out.println(e.toString());
		}

		return aUser;
	}

	public String updateUserInfo(String username, String realname,
			String email, String accountNum) {
		String msg = "";
		try {
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找该用户的定单
			if (!realname.equals("") && !email.equals("")
					&& !accountNum.equals(""))

			{
				String update1 = "update UserInfo set realname='" + realname
						+ "'where username like '" + username + "'";
				sqlstatement.executeUpdate(update1);

				String update2 = "update UserInfo set email='" + email
						+ "'where username like '" + username + "'";
				sqlstatement.executeUpdate(update2);

				String update3 = "update UserInfo set accountNum='"
						+ accountNum + "'where username like '" + username
						+ "'";
				sqlstatement.executeUpdate(update3);

				msg = "成功上传您的新信息";
			}
			else if(realname.equals(""))
			{
				msg = "必须填写真实姓名";
			}
			else if(email.equals(""))
			{
				msg = "必须填写Emial地址";
			}
			else if(accountNum.equals(""))
			{
				msg = "必须填写银行帐户";
			}
			
			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());
			msg = "修改失败";
		} catch (Exception e) {
			System.out.println(e.toString());
			msg = "修改失败";
		}
		return msg;
	}
}