userinfodao.java

来自「新闻管理系统」· Java 代码 · 共 34 行

package newsset;
import java.sql.*;
import newsset.UserInfo;
import newsset.DBFactory;
public class UserInfoDAO {
    public UserInfo findUser(String uid, String upwd) {
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;
        UserInfo v = null;


        DBFactory dbf = new DBFactory();
        try {
            conn = dbf.getConnection();
            stmt = conn.prepareStatement(
                    "select * from UserInfo where User_ID=? and User_PWD=?");
            stmt.setString(1, uid);
            stmt.setString(2, upwd);
            rs = stmt.executeQuery();
            if (rs.next()) {
                v = new UserInfo();
                v.setUser_ID(rs.getString("User_ID"));
                v.setUser_PWD(rs.getString("User_PWD"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

            return v;
        }

}