userdao.java

通过jsp,servlet,javaBean,三成架构实现的好友通讯录系统

package com.Dao;

import com.db.DBManager;
import com.entity.UserBean;
import java.sql.*;

public class userDao {
    public Connection conn;
    public PreparedStatement ps;
    public ResultSet rs;
    public userDao()
    {
        conn=DBManager.getConnetion();
    }
    public UserBean findUser(String name,String pwd)
    {
        UserBean user=new UserBean();
        String sql="select * from USERS where userName=? and password=?";
        try
        {
            ps=conn.prepareStatement(sql);
            ps.setString(1,name);
            ps.setString(2,pwd);
            rs=ps.executeQuery();
            if(rs.next())
            {
                user.setUserId(rs.getInt(1));
                user.setUserName(rs.getString(2));
                user.setPassword(rs.getString(3));
                user.setRealName(rs.getString(4));
                user.setSex(rs.getString(5));
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return user;
    }

}