일반 Mybatis3 Simple Example

import java.io.IOException;

import java.io.InputStream;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.omnibuscode.model.Document;

public class DiaryExam {

public static void main(String[] args) {

String resource = "com/omnibuscode/mybatis/mybatis-config.xml";

try {

InputStream is = Resources.getResourceAsStream(resource);

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

Map<String, Object> map = new HashMap<String, Object>();

map.put("regdate_end", "20060124024135");

map.put("regdate_start", "20060108090812");

List<Document> documents = session.selectList("getDocumentByDate", map);

for (Document d : documents) {

System.out.println(d.toString());

}

session.close();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

package com.omnibuscode.model;

/**

 * @author otonapoi 

 * 테이블 구조 

CREATE TABLE IF NOT EXISTS `xe_documents` (

 `document_srl` bigint(11) NOT NULL,

 `module_srl` bigint(11) NOT NULL DEFAULT '0',

 `title` varchar(250) DEFAULT NULL,

 `content` longtext NOT NULL,

 `regdate` varchar(14) DEFAULT NULL,

 `last_update` varchar(14) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 */

public class Document {

private int document_srl; //문서 번호

private int module_srl; //게시판 번호

private String title; //제목

private String content; //내용

private String regdate; //등록일

private String last_update; //마지막 수정일

private String status; //공개여부

public Document() {

;

}

public Document(int document_srl, int module_srl, String title, String content, String regdate, String last_update, String status) {

super();

this.document_srl = document_srl;

this.module_srl = module_srl;

this.title = title;

this.content = content;

this.regdate = regdate;

this.last_update = last_update;

this.status = status;

}

public int getDocument_srl() {

return document_srl;

}

public void setDocument_srl(int document_srl) {

this.document_srl = document_srl;

}

public int getModule_srl() {

return module_srl;

}

public void setModule_srl(int module_srl) {

this.module_srl = module_srl;

}

public String getTitle() {

return title;

}

public void setTitle(String title) {

this.title = title;

}

public String getContent() {

return content;

}

public void setContent(String content) {

this.content = content;

}

public String getRegdate() {

return regdate;

}

public void setRegdate(String regdate) {

this.regdate = regdate;

}

public String getLast_update() {

return last_update;

}

public void setLast_update(String last_update) {

this.last_update = last_update;

}

public String getStatus() {

return status;

}

public void setStatus(String status) {

this.status = status;

}

public String toString() {

return "구분:"+this.module_srl+", 제목:"+this.title+", 등록일:"+this.regdate;

}

}

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.omnibuscode.mybatis.DocumentMapper">

    <select id="getDocumentByDate" parameterType="hashmap" resultType="com.omnibuscode.model.Document">

        select document_srl, module_srl, title, content, regdate, last_update, status from xe_documents

            where regdate BETWEEN ${regdate_start} AND ${regdate_end}

    </select>

</mapper>