MemberManager.java

package com.godoro.em;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class MemberManager {
  
  public boolean insert(Member member) throws Exception {
    Connection connection = DatabaseUtilities.getConnection();

    String sql = "insert into SiteMember(memberUsername,memberPassword) values(?,?)";
    PreparedStatement statement = connection.prepareStatement(sql);
    statement.setString(1, member.getMemberUsername());
    statement.setString(2, member.getMemberPassword());
    int affected = statement.executeUpdate();

    connection.close();
    return affected > 0;
  }
   public Member findByUsername(String memberUsername) throws Exception {
    Member member = null;
    Connection connection = DatabaseUtilities.getConnection();
    String sql = "select * from SiteMember where memberUsername=?";
    PreparedStatement statement = connection.prepareStatement(sql);
    statement.setString(1, memberUsername);
    ResultSet resultSet = statement.executeQuery();
    if (resultSet.next()) {
      long memberId = resultSet.getLong("memberId");
      String memberPassword = resultSet.getString("memberPassword");
      member = new Member(memberId,memberUsername,memberPassword);
    }
    connection.close();
    return member;
  }
}