xmluserdao.java

用java开发的QQ管理系统

					data.add("10001");
				} else {
					for (int i = 0; i < userList.size(); i++) {
						Element e = (Element) userList.get(i);

						if (Integer.parseInt(e.attribute("userId").getText()) > max) {
							max = Integer.parseInt(e.attribute("userId")
									.getText());
						}
					}
					max++;
					String maxStr = String.valueOf(max);
					data.add(maxStr);
				}

			} else if (st.equals("5")) {
				// 返回是否存在该用户id
				int count = 0;
				for (int i = 0; i < userList.size(); i++) {
					Element e = (Element) userList.get(i);
					//System.out.println(e);
					if (e.attribute("userId").getText().equals((String) h.get("5"))) {
						count++;
						data.add(String.valueOf(count));
					}
				}
			} else if (st.equals("6")) {
				// 返回用户的状态，是否在线的状态
				for (int i = 0; i < userList.size(); i++) {
					Element e = (Element) userList.get(i);
					if (e.attribute("userId").getText().equals((String) h.get("6"))) {
						data.add(e.selectSingleNode("userOnline").getText());
					}
				}
			} else if (st.equals("7")) {
				// 返回用户的密码
				for (int i = 0; i < userList.size(); i++) {
					Element e = (Element) userList.get(i);
					if (e.attribute("userId").getText().equals((String) h.get("7"))) {
						data.add(e.selectSingleNode("userPwd").getText());
					}
				}
			} else if (st.equals("8")) {
				// 返回数据库中用户表所有用户信息
				for (int i = 0; i < userList.size(); i++) {
					Element e = (Element) userList.get(i);

					Vector user = new Vector();
					user.add(e.attribute("userId").getText());
					user.add(e.selectSingleNode("userPwd").getText());
					user.add(e.selectSingleNode("userName").getText());
					user.add(e.selectSingleNode("userNickName").getText());
					user.add(e.selectSingleNode("userSex").getText());
					user.add(e.selectSingleNode("userIcon").getText());
					//System.out.println(e.selectSingleNode("userAge"));
					user.add(e.selectSingleNode("userAge").getText());
					user.add(e.selectSingleNode("departmentid").getText());
					user.add(e.selectSingleNode("userPhone").getText());
					user.add(e.selectSingleNode("userLastLogin").getText());
					user.add(e.selectSingleNode("userAddr").getText());
					user.add(e.selectSingleNode("userRegDate").getText());
					user.add(e.selectSingleNode("userLoginNum").getText());
					user.add(e.selectSingleNode("userOnline").getText());
					data.add(user);

				}
			}else if(st.equals("9")){
//				 返回在线用户的信息
				for (int i = 0; i < userList.size(); i++) {
					Element e = (Element) userList.get(i);
					if (e.selectSingleNode("userOnline").getText().equals("1")){
						Vector user = new Vector();
						
						user.add(e.attribute("userId").getText());
						user.add(e.selectSingleNode("userName").getText());
						user.add(e.selectSingleNode("userNickName").getText());
						user.add(e.selectSingleNode("userSex").getText());
						//根据部门编号返回部门名称
						HashMap hashMap=new HashMap();
						hashMap.put("5", e.selectSingleNode("departmentid").getText());
						String deptName= (String) new XmlDeptDao().selectDept(hashMap).get(0);
						user.add(deptName);
						user.add(e.selectSingleNode("userLastLogin").getText());
						data.add(user);
					}
				}
			}else if(st.equals("10")){
				//查询某个用户所在的部门的编号
				for (int i = 0; i < userList.size(); i++) {
					Element e = (Element) userList.get(i);
					if (e.attribute("userId").getText().equals((String) h.get("10"))) {
						data.add(e.selectSingleNode("departmentid").getText());
					}
				}
			}else if (st.equals("11")){
				//根据条件查询用户
				HashMap m=(HashMap) h.get("11");
				Set s=m.keySet();
				Iterator it=s.iterator();
				while (it.hasNext()){
					String str=(String) it.next();
					if (str.equals("1")){
						for (int i = 0; i < userList.size(); i++){
							Element e = (Element) userList.get(i);
							if (e.attribute("userId").getText().equals(m.get("1"))){
								Vector user = new Vector();
								user.add(e.attribute("userId").getText());
								user.add(e.selectSingleNode("userName").getText());
								user.add(e.selectSingleNode("userNickName").getText());
								user.add(e.selectSingleNode("userSex").getText());
								//根据部门编号返回部门名称
								HashMap hashMap=new HashMap();
								hashMap.put("5", e.selectSingleNode("departmentid").getText());
								String deptName= (String) new XmlDeptDao().selectDept(hashMap).get(0);
								user.add(deptName);
								user.add(e.selectSingleNode("userLastLogin").getText());
								data.add(user);
							}
						}
					}else if (str.equals("2")){
						for (int i = 0; i < userList.size(); i++){
							Element e = (Element) userList.get(i);
							if (e.selectSingleNode("userName").getText().equals(m.get("2"))){
								Vector user = new Vector();
								user.add(e.attribute("userId").getText());
								user.add(e.selectSingleNode("userName").getText());
								user.add(e.selectSingleNode("userNickName").getText());
								user.add(e.selectSingleNode("userSex").getText());
								//根据部门编号返回部门名称
								HashMap hashMap=new HashMap();
								hashMap.put("5", e.selectSingleNode("departmentid").getText());
								String deptName= (String) new XmlDeptDao().selectDept(hashMap).get(0);
								user.add(deptName);
								user.add(e.selectSingleNode("userLastLogin").getText());
								data.add(user);
							}
						}
					}else if (str.equals("3")){
						for (int i = 0; i < userList.size(); i++){
							Element e = (Element) userList.get(i);
							if (e.selectSingleNode("departmentid").getText().equals(m.get("3"))){
								Vector user = new Vector();
								user.add(e.attribute("userId").getText());
								user.add(e.selectSingleNode("userName").getText());
								user.add(e.selectSingleNode("userNickName").getText());
								user.add(e.selectSingleNode("userSex").getText());
								//根据部门编号返回部门名称
								HashMap hashMap=new HashMap();
								hashMap.put("5", e.selectSingleNode("departmentid").getText());
								String deptName= (String) new XmlDeptDao().selectDept(hashMap).get(0);
								user.add(deptName);
								user.add(e.selectSingleNode("userLastLogin").getText());
								data.add(user);
							}
						}
					}
				}
				
			}
			

			this.outputXML(doc);
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		//System.out.println(data);
		return data;
	}

	public int updateOnLine(int onLine, String userId) {

		Document doc = this.getDocument();

		try {
			Element root = doc.getRootElement();

			List userList = root.selectNodes("/users/user");

			for (int i = 0; i < userList.size(); i++) {

				Element e = (Element) userList.get(i);

				if (e.attribute("userId").getText().equals(userId)) {

					e.selectSingleNode("userOnline").setText(String.valueOf(onLine));

					System.out.println(e.selectSingleNode("userOnline").getText());

				}

			}

			this.outputXML(doc);
			return 1;
		} catch (Exception e) {
			e.printStackTrace();
			return 0;
		}
	}

	public int updatePwd(String userId,String userPwd) {

		Document doc = this.getDocument();

		try {
			// users
			Element root = doc.getRootElement();
			// user
			List userList = root.selectNodes("/users/user");
			
			for (int i = 0; i < userList.size(); i++) {

				Element e = (Element) userList.get(i);
				if (!userId.equals("")){
					if (e.attribute("userId").getText().equals(userId)) {
						e.selectSingleNode("userPwd").setText(userPwd);
					}
				}else{
					e.selectSingleNode("userPwd").setText(userPwd);
				}
			}

			this.outputXML(doc);
			return 1;
		} catch (Exception e) {
			e.printStackTrace();
			return 0;
		}
	}
	
	


	public int updateUser(User user) {
		if ((deleteUser(user.getUserId()) > 0) && (addUser(user)) > 0){
			return 1;
		}else
			return 0;
	}



}