package com.cxs.dao;

import com.cxs.model.User;
import com.cxs.utils.DBUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.sql.SQLException;

public class ChangePasswordDao {

    QueryRunner queryRunner = new QueryRunner(DBUtils.getDs());

    public User getUserByUsername(String username) throws SQLException {
        return queryRunner.query("select * from loginuser where username = ?", new BeanHandler<>(User.class), username);
    }

    public Integer updatePassword(String username,String newPassword) throws SQLException {
        return queryRunner.update("update loginuser set password = ? where username = ?",newPassword,username);
    }
}