public int update(Member member) throws Exception
    {
        Connection connection = null;
        PreparedStatement stmt = null;

        try
        {
            connection = ds.getConnection();
            stmt = connection.prepareStatement("UPDATE MEMBERS SET EMAIL=?,MNAME=?,MOD_DATE=now() WHERE MNO=?");
            stmt.setString(1, member.getEmail());
            stmt.setString(2, member.getName());
            stmt.setInt(3, member.getNo());

            return stmt.executeUpdate();
        }
        catch(Exception e)
        {
            throw e;
        }
        finally
        {
            try { if(stmt != null) stmt.close(); } catch(Exception e) {}
            try { if(connection != null) connection.close(); } catch(Exception e) {}
        }
    }