loginbo.java

网上论坛系统,是一个功能很完善的系统,推存给大家,很好用的

package bo;

import myjdbc.DatabaseOperation;
import struts.actionform.LoginForm;
import java.util.List;
import util.uid.UUIDGener;
import util.Util;
import vo.Users;

public class LoginBo {
    private static LoginBo bo = null;
    private static DatabaseOperation db = null;
    private LoginBo() {
        db = DatabaseOperation.getInstance();
    }

    public static LoginBo getInstance() {
        if (bo == null) {
            return new LoginBo();
        } else {
            return bo;
        }
    }

    /**
     * 用户登陆验证
     * @param form LoginForm
     * @return String 登陆失败返回失败信息，登陆成功则返回用户id
     */
    public String verifyUser(LoginForm form) {
        String name = Util.convertEncoding(form.getUsername());
        String pw = Util.convertEncoding(form.getPassword());
        StringBuffer sb = new StringBuffer();
        sb.append("select password , name  from users where name = '" + name +
                  "' ");
        List result = db.executeSQL(sb.toString());
        if (result.size() == 0) {
            return "用户名输入有误！";
        }
        String pwFromDb = (String) ((Object[]) result.get(0))[0];
        if (!pw.equals(pwFromDb)) {
            return "密码输入有误！";
        }
        return "";
    }

    public String getUserIdByName(String name){
       List list =  db.executeSQL("select * from users where name = '"+ name+"'");
        if(list.size() == 0){
            return "";
        }else{
            return ((Users)list.get(0)).getUserId();
        }
    }

    /**
     * 添加一个新的用户
     * @param form LoginForm
     * @return String
     */
    public String addUser(LoginForm form) {

        StringBuffer sb = new StringBuffer();
        sb.append("insert into users values ('" + UUIDGener.getUUID() + "',");
        sb.append("'" + Util.convertEncoding(form.getUsers().getName()) + "',");
        sb.append("'" + Util.convertEncoding(form.getUsers().getPassword()) + "',");
        sb.append("'" + Util.convertEncoding(form.getUsers().getPhone()) + "',");
        sb.append("'" + Util.convertEncoding(form.getUsers().getAddress()) + "',");
        sb.append("'" + Util.convertEncoding(form.getUsers().getEmail()) + "')");
        db.executeSQL(sb.toString());
        return "";
    }

    /**
     * 验证是否有重复的用户名
     * @param form LoginForm
     * @return boolean
     */
    public boolean isExist(LoginForm form) {
        StringBuffer sb = new StringBuffer();
        sb.append("select * from users where name = '" +
                  form.getUsers().getName() + "'");
        List result = db.executeSQL(sb.toString());
        if (result.size() != 0) {
            return true;
        } else {
            return false;
        }

    }

}