오늘도 행복하다.

List<Xxx> params = new List<Xxx>();
params.add(new Xxx("a", "1"));
params.add(new Xxx("b", "2"));
params.add(new Xxx("c", "3"));

RESULT = getSqlMapClientTemplate().queryForList("xxx.getList", params);

<select id="xxx.getList" parameterClass="java.util.List" resultClass="Xxx">
    SELECT ...
    FROM TB_XXX
    WHERE 1 = 1
    <iterate prepend="AND" conjunction="OR" open="(" close=")">
        ( pk1 = #[].pk1# AND pk1 = #[].pk2# )
    </iterate>
</select>

List<Xxx> params = new List<Xxx>();
params.add(new Xxx("a", "1"));
params.add(new Xxx("b", "2"));
params.add(new Xxx("c", "3"));

HashMap paramMap = new HashMap();
paramMap.put("pks", params);

RESULT = getSqlMapClientTemplate().queryForList("xxx.getList", paramMap);

<select id="xxx.getList" parameterClass="java.util.Map" resultClass="Xxx">
    SELECT ...
    FROM TB_XXX
    WHERE 1 = 1
    <iterate prepend="AND" property="pks" conjunction="OR" open="(" close=")">
        ( pk1 = #pks[].pk1# AND pk1 = #pks[].pk2# )
    </iterate>
</select>

<action name="xxx_list" class="xxx.action.XxxAction" method="findList">
    <result>/jsp/xxx/list.jsp</result>
</action>

public class XxxAction extends BaseAction(ActionSupport){
    ...
    public String findList() throws Exception {
        return SUCCESS;
    }
}

public class XxxServiceImpl implements XxxService{
	
	private static XxxServiceImpl instance = new XxxServiceImpl();

	public static XxxServiceImpl getInstance(){
		return instance;
	}

	DaoManager daoManager = null;
	XxxDAO dao;

	private XxxServiceImpl(){  
		daoManager = DaoConfig.getDaoManager();
		dao = (XxxDAO)daoManager.getDao(XxxDAO.class);
	}

	public List findList() throws Exception{ //Exception 을 안던지게 하도록
		List list = null;
		try{
			list = dao.getList();
		} catch (DaoException de) { //여긴 없어도 될듯
			log.error(de, de);
			throw de;
		} catch (Exception e) {
			log.error(e, e);
			throw e;
		}
		return list;
	}

	public int insert(XxxVO vo) throws Exception{ //음...
		int result = 1;
		try{
			dao.insert(vo); //트랜잭션 처리를 하지 않아도 예외가 발생하면 Rollback된다.
		} catch (DaoException de) {
			result = 0;
			System.out.println("de="+de.toString());
		} catch (Exception e) {
			result = 0;
			System.out.println("e="+e.toString());
		}	
		return result;
	}

	public String change(XxxVO vo, String state) throws Exception{
		String err_msg = "FAIL";
		try{			
			daoMgr.startTransaction(); //명시적인 트랜잭션 처리
			
			err_msg = dao.update(vo);
			dao.insertState(vo, state);
			
			daoMgr.commitTransaction();
		} catch (DaoException de) {
			log.error(de, de);
			throw de;
		} catch (Exception e) {
			log.error(e, e);
			throw e;
		}finally{
			daoMgr.endTransaction();
		}
		return err_msg;
	}
	...
}

public class XxxDAOImpl extends SqlMapDaoTemplate implements XxxDAO{
	public XxxDAOImpl(DaoManager daoManager) {
		super(daoManager);
	}

	public List getList() throws DaoException{ //DaoException은 Runtime Exception이다.
		return (XxxVO) queryForObject("xxx.list");
	}
	...
}

<div id="Catalog">

  <h2><bean:write name="product" property="name"/></h2>

  <table>
    <tr><th>Item ID</th>  <th>Product ID</th>  <th>Description</th>  <th>List
      Price</th>  <th> </th></tr>
    <logic:iterate id="item" name="itemList">
      <tr>
        <td>
          <html:link paramId="itemId" paramName="item" paramProperty="itemId" page="/shop/viewItem.shtml">
            <bean:write name="item" property="itemId"/></html:link></td>
        <td><bean:write name="item" property="productId"/></td>
        <td>
          <bean:write name="item" property="attribute1"/>
          <bean:write name="item" property="attribute2"/>
          <bean:write name="item" property="attribute3"/>
          <bean:write name="item" property="attribute4"/>
          <bean:write name="item" property="attribute5"/>
          <bean:write name="product" property="name"/>
        </td>
        <td><bean:write name="item" property="listPrice" format="$#,##0.00"/></td>
        <td><html:link styleClass="Button" paramId="workingItemId" paramName="item" paramProperty="itemId" page="/shop/addItemToCart.shtml">
          Add to Cart</html:link></td>
      </tr>
    </logic:iterate>
    <tr><td>
      <logic:notEqual name="itemList" property="firstPage" value="true">
        <a class="Button" href="switchItemListPage.shtml?pageDirection=previous"><< Prev</a>
      </logic:notEqual>
      <logic:notEqual name="itemList" property="lastPage" value="true">
        <a class="Button" href="switchItemListPage.shtml?pageDirection=next">Next >></a>
      </logic:notEqual>
    </td></tr>
  </table>

</div>

<select id="getItemListByProduct" resultClass="item" parameterClass="string" cacheModel="itemCache">
	SELECT
		ITEMID,
		LISTPRICE,
		UNITCOST,
		SUPPLIER AS supplierId,
		I.PRODUCTID AS "product.productId",
		/* I.PRODUCTID, */
		NAME AS "product.name",
		DESCN AS "product.description",
		CATEGORY AS "product.categoryId",
		STATUS,
		ATTR1 AS attribute1,
		ATTR2 AS attribute2,
		ATTR3 AS attribute3,
		ATTR4 AS attribute4,
		ATTR5 AS attribute5
	FROM ITEM I, PRODUCT P
	WHERE P.PRODUCTID = I.PRODUCTID
	AND I.PRODUCTID = #value#
</select>

• *.shtml 는 Struts action에서 처리하도록 함.
• security-constraint 로 jsp파일을 직접 호출하지 못하게 함.

  <security-constraint>
  	<web-resource-collection>
  		<web-resource-name>Restrict access to JSP pages</web-resource-name> 
  		<url-pattern>*.jsp</url-pattern> 
  	</web-resource-collection>
  	<auth-constraint>
  		<description>With no roles defined, no access granted</description> 
  	</auth-constraint>
  </security-constraint>

<%@ include file="../common/IncludeTop.jsp" %>
내용
<%@ include file="../common/IncludeBottom.jsp" %>

<bean:define id="category" name="catalogBean" property="category"/>
<bean:define id="productList" name="catalogBean" property="productList"/>
<logic:iterate id="product" name="productList">
<tr>
    <td>
        <html:link paramId="productId" paramName="product" paramProperty="productId" page="/shop/viewProduct.shtml">
            <bean:write name="product" property="productId"/>
        </html:link>
    </td>
    <td><bean:write name="product" property="name"/></td>
</tr>
</logic:iterate>

<action path="/test.elf" type="org.apache.struts.beanaction.BeanAction"
   name="catalogBean" parameter="*" validate="false">
<forward name="success" path="/t.jsp"/>
</action>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Person">
<select id="getPerson" parameterClass=”int” resultClass="examples.domain.Person">
	SELECT
	PER_ID as id,
	PER_FIRST_NAME as firstName,
	PER_LAST_NAME as lastName,
	PER_BIRTH_DATE as birthDate,
	PER_WEIGHT_KG as weightInKilograms,
	PER_HEIGHT_M as heightInMeters
	FROM PERSON
	WHERE PER_ID = #value#
</select>
...

1. Dynamic Web Project 를 생성한다.
2. Import
       src : JavaSource
       web : WebContent
       lib : WebContent/WEB-INF/lib

1. JPetStore-5.0/src/ddl/ 의 스크립트를 사용하여 테이블을 생성하고 데이터를 입력한다.
2. WEB-INF/classes/properties/database.properties 를 설정한다.
3. Item.xml에서 getItem의 쿼리를 수정한다. : itemid 가 명확하지 않아 에러가 발생하므로 v.ITEMID로 변경한다.