userimpl.java~3~

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"));
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return userbean;
    }
}