public Member selectOne(int no) throws Exception
    {
        System.out.println("selectOne() 호출");

        Connection connection = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try
        {
            connection = ds.getConnection();
            stmt = connection.prepareStatement("SELECT MNO,EMAIL,MNAME,CRE_DATE FROM MEMBERS WHERE MNO=?");
            stmt.setInt(1, no);
            rs = stmt.executeQuery();

            Member member = new Member();

            if(rs.next())
            {
                member.setNo(rs.getInt("MNO")).setName(rs.getString("MNAME")).setEmail(rs.getString("EMAIL")).setCreatedDate(rs.getDate("CRE_DATE"));
            }

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