usermanage.java

动态网站管理发布系统

package com.ntsky.news;

import com.ntsky.common.*;
import com.ntsky.database.SQLDBOperator;
import com.ntsky.persistence.NEWSUsr;
import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.Vector;

public class UserManage {
	private String user;

	private String passWd;

	private Vector vector;

	private SQLDBOperator sdbo;

	public UserManage() {
		user = null;
		passWd = null;
		vector = new Vector();
		sdbo = null;
	}

	public boolean isUser(String userName) {
		boolean isUser = false;
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		String sql = "select userName from newsusr where userName=?;";
		try {
			sdbo.prepareStatement(sql);
			sdbo.setString(1, userName);
			ResultSet rs = sdbo.executeQuery();
			rs.last();
			if (rs.getRow() > 0)
				isUser = true;
			rs.close();
		} catch (Exception e) {
			System.out.print("UserManage isUser()" + e.getMessage());
			Debug.writeLog("UserManage isUser(), Exception Occured ! Info :" + e.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return isUser;
	}

	public boolean isUsernameOk(String useName) {

		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		boolean isOk = false;
		String strSql = "select * from newsadmin where userName=?;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setString(1, useName);
			ResultSet rs = sdbo.executeQuery();
			rs.last();
			if (rs.getRow() > 0) {
				isOk = true;
				passWd = rs.getString("passWd");
				rs.close();
			}
		} catch (SQLException sqlE) {
			sqlE.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			sdbo.Close();
		}
		return isOk;
	}

	public boolean isPasswordOk(String passWord) {
		boolean isOn = false;
		if (passWd.equals(CodeFilter.toHtml(passWord)))
			isOn = true;
		return isOn;
	}

	public String setUser(String user) {
		this.user = user;
		return user;
	}

	public Iterator listPersonal() {
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		String sql = "select * from newsusr where userName=?;";
		ResultSet rs = null;
		try {
			sdbo.prepareStatement(sql);
			sdbo.setString(1, user);
			rs = sdbo.executeQuery();
			while (rs.next()) {
				NEWSUsr userTable = new NEWSUsr();
				userTable.setUserName(new String(rs.getString("userName").getBytes("ISO-8859-1"), "gbk"));
				userTable.setPassWd(rs.getString("passWd"));
				userTable.setSex(rs.getInt("sex"));
				userTable.setQuestion(new String(rs.getString("question").getBytes("ISO-8859-1"), "gbk"));
				userTable.setAnswer(new String(rs.getString("answer").getBytes("ISO-8859-1"), "gbk"));
				userTable.setEmailAddr(rs.getString("emailAddr"));
				userTable.setQq(rs.getString("qq"));
				userTable.setHttp(rs.getString("http"));
				vector.add(userTable);
			}
			rs.close();
		} catch (SQLException sqlE) {
			System.out.println("UserManage listPersonal()" + sqlE.getLocalizedMessage());
			Debug.writeLog("UserManage listPersonal(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} catch (UnsupportedEncodingException nullE) {
			System.out.print("Personal unNews() info :" + nullE.getMessage());
			Debug.writeLog("Personal unNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return vector.iterator();
	}

	public void upUserAdmin(String userName, String passWd, String userNameOld) {
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		String strSql = "update newsadmin set userName=?,passWd=? where userName=?;";
		String sql = "update news set author=? where author=?;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setString(1, userName);
			sdbo.setString(2, passWd);
			sdbo.setString(3, userNameOld);
			sdbo.executeUpdate();
			sdbo.Close();

			sdbo.prepareStatement(sql);
			sdbo.setString(1, userName);
			sdbo.setString(2, userNameOld);
			sdbo.executeUpdate();
		} catch (Exception sqlE) {
			System.out.println("UserManage upPersonal()" + sqlE.getLocalizedMessage());
			Debug.writeLog("UserManage upPersonal(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
	}

	public void upPersonal(String passWd, int sex, String question, String answer, String emailAddr, String qq, String http, String userName) {
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		String strSql = "update newsusr set passWd=?,sex=?,question=?,answer=?,emailAddr=?,qq=?,http=? where userName=?;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setString(1, passWd);
			sdbo.setInt(2, sex);
			sdbo.setString(3, question);
			sdbo.setString(4, answer);
			sdbo.setString(5, emailAddr);
			sdbo.setString(6, qq);
			sdbo.setString(7, http);
			sdbo.setString(8, userName);
			sdbo.executeUpdate();
		} catch (Exception sqlE) {
			System.out.println("UserManage upPersonal()" + sqlE.getLocalizedMessage());
			Debug.writeLog("UserManage upPersonal(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
	}

	public boolean isUserName(String userName) {
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		String sql = "select * from newsusr where userName=?;";
		ResultSet rs = null;
		boolean isUserName = false;
		try {
			sdbo.prepareStatement(sql);
			sdbo.setString(1, userName);
			rs = sdbo.executeQuery();
			try {
				rs.last();
				if (rs.getRow() > 0)
					isUserName = true;
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("UserManage listPersonal" + nullE.getMessage());
				Debug.writeLog("UserManage listPersonal(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.println("UserManage listPersonal()" + sqlE.getLocalizedMessage());
			Debug.writeLog("UserManage listPersonal(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return isUserName;
	}

	public boolean isPassWd(String userName, String answer) {
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		String sql = "select passWd from newsusr where userName=? and answer=?;";
		ResultSet rs = null;
		boolean isPassWd = false;
		try {
			sdbo.prepareStatement(sql);
			sdbo.setString(1, userName);
			sdbo.setString(2, answer);
			rs = sdbo.executeQuery();
			try {
				rs.last();
				if (rs.getRow() > 0) {
					isPassWd = true;
					passWd = rs.getString("passWd");
				}
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("UserManage listPersonal" + nullE.getMessage());
				Debug.writeLog("UserManage listPersonal(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.println("UserManage listPersonal()" + sqlE.getLocalizedMessage());
			Debug.writeLog("UserManage listPersonal(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return isPassWd;
	}

	public String getPassWd() {
		return passWd;
	}
}