userdao.java

北大青鸟 S2 论坛短消息项目源代码提供给大家！呵呵！~

/*
 * s2jsp.xmal.dao.UserDao.java
 * 2007-08-10
 * 用户数据库访问类
 */
package s2jsp.xmal.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import s2jsp.xmal.entity.User;

public class UserDao extends BaseDao{
    private Connection        conn  = null;   // 数据库连接
    private PreparedStatement pstmt = null;   // 创建PreparedStatement对象
    private ResultSet         rs    = null;   // 创建结果集对象

    /**
     * 根据用户名查找
     * @param uname
     * @return
     */
    public User findByUname(String uname) {
        User user = null;
        String sql = "select * from TBL_USER where name=?";
        try {
            conn  = this.getConn();
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, uname);
            rs    = pstmt.executeQuery();
            while(rs.next()) {
                user = new User();
                user.setName(rs.getString("name"));
                user.setPass(rs.getString("pass"));
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            this.closeAll(conn, pstmt, rs);
        }
        return user;
    }
}