struts 2.0 + mybatis3 INSERT 과정

Insert 과정

<insert.jsp> 객체타입으로 보냄

    <form method="post" action="insert.action">
        아이디<input type="text" name="membersVo.id" /><br /> 비밀번호<input type="text"
            name="membersVo.pwd" /><br /> 이메일<input type="text" name="membersVo.email" /><br />
 
 
        이름<input type="text" name="membersVo.name" /><br /> <input type="submit"
            value="가입" />
    </form>
 

<insertAction.java>

  MembersDao dao = MembersDao.getInstance();
 
  int result = dao.setMember(membersVo);
        
  if (result == 1) {
      System.out.println("Insert 완료");
      return SUCCESS;
  } else {
      System.out.println("Insert 실패");
      return null;
  }

<MembersDao.java>

public class MembersDao {
    //Lazy Holder 싱글톤 방식
    public static class SingletonHolder {
        private static final MembersDao ins = new MembersDao();
    }
 
    public static MembersDao getInstance() {
        return SingletonHolder.ins;
    }
 
    private SqlSessionFactory sqlSessionFactory;
 
    private MembersDao() {
        sqlSessionFactory = SqlSessionFactoryService.getSqlSessionFactory();
    }
 
    public int setMember(MembersVo membersVo) {
        SqlSession sqlSession = null;
 
        try {
            sqlSession = sqlSessionFactory.openSession(true);
            MembersMapper membersMapper = sqlSession.getMapper(MembersMapper.class);
            return membersMapper.insertMember(membersVo);
 
        } catch (Exception e) {
            // TODO: handle exception
            System.out.println(e.getMessage());
            return 0;
        } finally {
            if (sqlSession != null)
                sqlSession.close();
        }
    }
}

SessionFactory 싱글톤 객체로 가져오기 

public class SqlSessionFactoryService {
    private static SqlSessionFactory sqlSessionFactory;
    // static멤버변수를 초기화할때는 static블록을 사용한다.(생성자x)
    static {
        try {
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
        } catch (IOException ie) {
            System.out.println(ie.getMessage());
        }
    }
 
    public static SqlSessionFactory getSqlSessionFactory() {
        return sqlSessionFactory;
    }
}

<mybatis-config.xml>

<configuration>
 
    <!--//////// 접속할 DB서버에 대한 정보 설정 ///////////// -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="org.mariadb.jdbc.Driver" />
                <property name="url" value="jdbc:mariadb://localhost:3366/member" />
                <property name="username" value="root" />
                <property name="password" value="1234" />
            </dataSource>
        </environment>
    </environments>
    <!--/////// sql구문이 들어있는 SQL Mapper파일 포함 ////////// -->
    <mappers>
        <mapper resource="/map/MembersMapper.xml" />
    </mappers>
</configuration>

mapper -> MembersMapper.java

public interface MembersMapper {
 
    public int insertMember(MembersVo membersVo);
 
    public MembersVo getMember(HashMap<String, String> map);
 
}
 

map -> MembersMapper.xml  

<mapper namespace="mapper.MembersMapper">
     <insert id="insertMember" parameterType="vo.MembersVo">
        insert into userinfo
        values(#{id}, #{name}, #{email}, #{pwd}, #{reg_date} )
    </insert>
</mapper>