servlet实现管理系统的增删改查

再在昨天的代码之上进行修改，增加修改功能
可以对数据进行修改

首先在IUserDao中添加以下代码

User findUserById(int id);
void update(int id,String username,String password);

在UserDaoimpl中也同样添加以下代码

@Override
    public User findUserById(int id) {
        User user = null;
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        try {
            connection = DBUtil.getConnection();
            //3写sql
            String sql = "select * from tb_user where id=?";
            statement = connection.prepareStatement(sql);
            statement.setInt(1, id);
            resultSet = statement.executeQuery();
            while (resultSet.next()) {
                user = new User();
                user.setId(resultSet.getInt(1));
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.closeALL(resultSet,statement,connection);
        }
        return user;
    }

    @Override
    public void update(int id, String username, String password) {
        Connection connection=null;
        PreparedStatement statement=null;
        ResultSet resultSet = null;
        try {
            connection=DBUtil.getConnection();
            statement=connection.prepareStatement("update tb_user set username=?,password=? where id=?