[Java] mybatis(ibatis) 적용시 NoClassDefFoundError에러

JAVA 2012. 6. 6. 15:15

mybatis 적용하면서

유닛테스트에서는 문제가 없는데,

톰캣 기동후에 웹환경에서 실행시키면

자꾸 에러가 발생.

path문제인지 알았으나.

결국 임포트문제.


해결은

이클립스에서

Window > Preperence 

> Tomcat > JVM 설정

 > 클래스 패스 / 마이바티스jar 설정



저작자표시 (새창열림)
Posted by tenn
,

[Java] MyBatis 사용하기

JAVA 2012. 5. 31. 15:39

1. 라이브러리 배치


http://mybatis.org/


jar 파일들을 /WEB-INF/lib에 배치

jar파일 임포트


2. 프로퍼티 파일 작성


db.properties 

 driver=org.postgresql.Driver
 url=jdbc:postgresql://ip/dbname
 username=user

 password=pw



3. 설정파일


! > 공백, 공라인이 있으면 에러 발생


MyBatisConfig.xml 

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

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <properties resource="mybatis/db.properties" />

    <environments default="development">

        <environment id="development">

            <transactionManager type="JDBC" />

            <dataSource type="POOLED">

                <property name="driver" value="${driver}" />

                <property name="url" value="${url}" />

                <property name="username" value="${username}" />

                <property name="password" value="${password}" />

            </dataSource>

        </environment>

    </environments>

    <mappers>

        <mapper resource="mybatis/employee.xml" />

    </mappers>

 </configuration>


4. sql 작성


employee.xml

<?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="Test">
     <select id="getEmployee" resultType="app.data.model.Employee">
             SELECT * FROM Employee WHERE id = #{id}  
     </select>

     <select id="getAllEmployees" resultType="app.data.model.Employee">

             SELECT * FROM "Employee"  

     </select>

 </mapper>



5. bean 클래스 생성


Employee.java

package app.data.model;


public class Employee{

private String no;

private String userId;

private String name;



public String getUserId() {

return userId;

}

public void setUserId(String userId) {

this.userId = userId;

}

public String getNo() {

return no;

}

public void setNo(String no) {

this.no = no;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

}





5. 실행


package test; 




import java.util.List;


import org.apache.ibatis.session.SqlSession;

import db.SqlMapClient;

import app.data.model.*;


public class Test{


public static void main(String[] args){

SqlSession session = SqlMapClient.getSqlSession();

        

        Employee employee = session.selectOne("Test.getEmployee", "1112");

        System.out.println("name : " + employee.getName());

        

        List<Employee> list = session.selectList("Test.getAllEmployees");

        

        for(int i=0; i<list.size(); i++){

        System.out.println(list.get(i).getName());

        }

        

        session.close();

}


}


저작자표시 (새창열림)
Posted by tenn
,

[Java] CustomTag.2 속성이 있는 커스텀태그.

JAVA 2012. 5. 29. 18:39

커스텀 태그 만들기


1. 라이브러리 임포트



jsp-api.jar



2. Tag Servlet 작성


package tags;


import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;

public class helloTagServlet implements Tag {
  private PageContext pageContext;
  private Tag parentTag;
  private String name;

  public void setPageContext(PageContext pageContext) {
    this.pageContext = pageContext;
  }

  public void setParent(Tag parentTag) {
    this.parentTag = parentTag;
  }

  public Tag getParent() {
    return this.parentTag;
  }

  public void setName(String name){
     this.name = name;
  }

  public int doStartTag() throws JspException {
    try {
      JspWriter out = pageContext.getOut();

      out.print("Hello World!");
      out.println("name : "+this.name);

    } catch(Exception e) {
      throw new JspException(e.getMessage());
    }
      return SKIP_BODY;
    }

    public int doEndTag() throws JspException {
      return EVAL_PAGE;
    }

  public void release() {}
}


3. tld 작성


<?xml version="1.0" ?>

<taglib xmlns="http://java.sun.com/xml/ns/j2ee"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
            web-jsptaglibrary_2_0.xsd"
        version="2.0">

  <tlib-version>1.0</tlib-version>
  <jsp-version>2.0</jsp-version>
  <short-name>helloTag</short-name>
  <tag>
    <name>helloTag</name>
    <tag-class>tags.helloTagServlet</tag-class>
    <body-content>empty</body-content>
<attribute>
<name>name</name>
<type>java.lang.String</type>
<rtexprvalue>true</rtexprvalue>  <- EL식, servlet식을 사용해서 값 설정 가능.
</attribute>
  </tag>
</taglib>

4. web.xml에 추가


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

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
             web-app_2_4.xsd"
         version="2.4">
  <jsp-config>
    <taglib>
      <taglib-uri>tags/hello</taglib-uri>
      <taglib-location>/WEB-INF/lib/hello.tld</taglib-location>
    </taglib>
  </jsp-config>
</web-app>


5. jsp에 사용


//uri web.xml에서 설정한 <taglib-uri>의 값을 설정



<%@ page contentType="text/html; charset=windows-31j"

         import="tags.*" %>


<%@ taglib uri=" tags/hello "

    prefix="hello" %>


<HTML>

<BODY>


<hello:helloTag name="hello"/>






저작자표시 (새창열림)
Posted by tenn
,

티스토리툴바