UserDao

package com.dao;

import com.entity.User;
import com.zhenghong.database.DBManager;

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

public class UserDao extends DBManager {

public User loadUser( User user) throws SQLException {
    User u = null ;
    String sql = "select * from users where userName = ? and userPwd = md5(?)" ;
    Connection conn = this.openConnection() ;
    Object[] obs = { user.getUserName() , user.getUserPwd() } ;
    ResultSet rs = this.query( conn  , sql , obs ) ;

    while (rs.next()){
        u = new User() ;
        u.setUserId( rs.getInt(1));
        u.setUserName( rs.getString(2));
        u.setUserPwd( rs.getString(3));
    }
    return u ;
}

}