userimpl.java

JBuilder 2006 +SQL Server2000 +JavaBean+JSP开发的宠物医院管理系统

package com.pet.user.model.DAO.impl;

import com.pet.user.model.DAO.UserDao;
import com.pet.user.model.DTO.UserBean;
import java.sql.*;
import com.pet.util.DBCon;

public class Userimpl implements UserDao {
    public Userimpl() {
    }

    ResultSet rs = null;
    DBCon db = new DBCon();

    /**
     * getuserbean
     * 判断普通用户登陆方法，返回UserBean
     * @param name String
     * @param password String
     * @return UserBean
     * @todo Implement this com.pet.user.model.DAO.UserDao method
     */
    public UserBean getuserbean(String name, String password) {
        UserBean userbean = new UserBean();
        String querySql = "select UID,Uname,Upassword,Uquestion,Uanswer,Uemail,Usex,Uage,Uaddress,Utruename,Uphone from users where";
        if (name != null && !name.equals("") && password != null &&
            !password.equals("")) {
            querySql += "  Uname ='" + name + "' and Upassword ='" +
                    password + "'";
        }

        try {
            rs = db.querySQL(querySql);
            while (rs.next()) {
                userbean.setUID(rs.getInt("UID"));
                userbean.setUname(rs.getString("Uname"));
            }
            db.closeConn();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return userbean;
    }

    /**
     * customer
     * 普通用户注册功能
     * @param strsql String
     * @return UserBean
     */

    public UserBean customer(String uname, String upassword, String uquestion,
                             String uanswer, String umail, String usex,
                             String uphone, String utruename, String uaddress) {
        //拼写sql语句
        String sqlstr = "insert into users(uname,upassword,uquestion,uanswer,uemail,usex,uphone,utruename,uaddress) values('" +
                        uname + "','" +
                        upassword + "','" + uquestion + "','" + uanswer + "','" +
                        umail + "','" + usex + "','" + uphone +
                        "','" + utruename + "','" + uaddress + "')";
        UserBean userbean = new UserBean();
        try {
            db.updateResult(sqlstr);
            userbean.setUname(uname);
            userbean.setUquestion(uquestion);
            userbean.setUanswer(uanswer);
            userbean.setUemail(umail);
            userbean.setUsex(usex);
            userbean.setUphone(uphone);
            userbean.setUtruename(utruename);
            userbean.setUaddress(uaddress);
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return userbean;
    }

    /**
     * 判断用户名是否存在
     * @param strsql String
     * @return boolean
     */

    public boolean cusname(String strsql) {
        boolean aa =false;
        try {
            rs = db.querySQL(strsql);
            aa=rs.next();
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return aa;
    }
}