삶을 코딩하다, 필드를 걷다

<< service-config.xml파일을 수정 >>

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

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"

 applicationComplete="init();">

 

 <mx:Script>

  <![CDATA[

   import mx.controls.Alert;

   import mx.rpc.events.FaultEvent;

   import mx.rpc.events.ResultEvent;

   import mx.rpc.remoting.RemoteObject;

   

   private function init():void {

    var remoteObject:RemoteObject = new RemoteObject();

    remoteObject.destination = "productmanager";

    remoteObject.addEventListener(ResultEvent.RESULT, resultHandler);

    remoteObject.addEventListener(FaultEvent.FAULT, faultHandler);

    remoteObject.getProducts();

   }

   

   private function resultHandler(event:ResultEvent):void{        

       dg.dataProvider = event.result;   

      }      

   

      private function faultHandler(event:FaultEvent):void{        

       Alert.show("실패 메세지 : " + event.fault.message);   

      }  

  ]]>

 </mx:Script>

 

 <mx:DataGrid id="dg" width="100%" height="100%" />

</mx:Application>

• Spring 프레임워크의 부족한 점 보안 
• Flex에서 DataBase의 연동시 처리 방법 보안
• iBatis의 데이터 베이스 정의 및 사용방법 보안

package springapp.service;


import java.util.List;

import springapp.domain.Product;


public interface ProductManager {

 public List<Product> getProducts();

}

package springapp.service;


import java.util.List;


import springapp.dao.ProductDao;

import springapp.domain.Product;


public class ProductManagerImpl implements ProductManager {


 private ProductDao productDao;

 

 @Override

 public List<Product> getProducts() {

  return productDao.getProductList();

 }


 public void setProductDao(ProductDao productDao) {

  this.productDao = productDao;

 }

}

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

<beans xmlns="http://www.springframework.org/schema/beans"

 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

 xmlns:p="http://www.springframework.org/schema/p"

 xmlns:aop="http://www.springframework.org/schema/aop"

 xmlns:tx="http://www.springframework.org/schema/tx"

 xsi:schemaLocation="http://www.springframework.org/schema/beans 

 http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

 http://www.springframework.org/schema/aop 

 http://www.springframework.org/schema/aop/spring-aop-2.5.xsd

 http://www.springframework.org/schema/tx 

 http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">


 <!-- Enable @Transactional support -->

 <tx:annotation-driven />


 <!-- Enable @AspectJ support -->

 <aop:aspectj-autoproxy />


 <aop:config>

  <aop:advisor pointcut="execution(* *..ProductManager.*(..))"

   advice-ref="txAdvice" />

 </aop:config>


 <tx:advice id="txAdvice">

  <tx:attributes>

   <tx:method name="save*" />

   <tx:method name="get*" read-only="true" />

  </tx:attributes>

 </tx:advice>


 <bean id="productManager"

  class="springapp.service.ProductManagerImpl">

  <property name="productDao" ref="productDao" />

 </bean>


</beans>

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

<beans xmlns="http://www.springframework.org/schema/beans"

 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

 xmlns:p="http://www.springframework.org/schema/p"

 xmlns:aop="http://www.springframework.org/schema/aop"

 xmlns:tx="http://www.springframework.org/schema/tx"

 xsi:schemaLocation="http://www.springframework.org/schema/beans 

 http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/aop 

    http://www.springframework.org/schema/aop/spring-aop-2.5.xsd

    http://www.springframework.org/schema/tx 

    http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">


 <bean id="propertyConfigurer"

  class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"

  p:location="classpath:properties/jdbc.properties" />


 <bean id="dataSource"

  class="org.springframework.jdbc.datasource.DriverManagerDataSource"

  p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.url}"

  p:username="${jdbc.username}" p:password="${jdbc.password}" />


 <!-- Transaction manager for iBATIS Daos -->

 <bean id="transactionManager"

  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

  <property name="dataSource" ref="dataSource" />

 </bean>


 <!-- SqlMap setup for iBATIS Database Layer -->

 <bean id="sqlMapClient"

  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

  <property name="dataSource" ref="dataSource" />

  <property name="configLocation"

   value="classpath:springapp/dao/SqlMapConfig.xml" />

 </bean>


 <!-- Add additional Dao definitions here -->

 <bean id="productDao"

  class="springapp.dao.ProductDaoImpl">

  <property name="sqlMapClient" ref="sqlMapClient" />

 </bean>

 

</beans>

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://DB주소

jdbc.username=DB아이디

jdbc.password=DB비밀번호

package springapp.domain;



public class Product {



 private int id;

 private String description;

 private Double price;



 public int getId() {

  return id;

 }



 public void setId(int id) {

  this.id = id;

 }



 public String getDescription() {

  return description;

 }



 public void setDescription(String description) {

  this.description = description;

 }



 public Double getPrice() {

  return price;

 }



 public void setPrice(Double price) {

  this.price = price;

 }

}

package springapp.dao;



import java.util.List;

import springapp.domain.Product;



public interface ProductDao {

 public List<Product> getProductList();

}

package springapp.dao;



import java.util.List;



import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;



import springapp.domain.Product;



public class ProductDaoImpl extends SqlMapClientDaoSupport implements

  ProductDao {



 protected final Log logger = LogFactory.getLog(getClass());



 @SuppressWarnings("unchecked")

 @Override

 public List<Product> getProductList() {

  logger.info("Getting products!");

  return getSqlMapClientTemplate().queryForList("getProductList");

 }

}

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



<!DOCTYPE sqlMapConfig      

    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      

    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">



<sqlMapConfig>

 <typeAlias alias="Product" type="springapp.domain.Product"/>



 <sqlMap resource="springapp/dao/MySQLProduct.xml" />

</sqlMapConfig>

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



<!DOCTYPE sqlMap      

    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      

    "http://ibatis.apache.org/dtd/sql-map-2.dtd">



<sqlMap namespace="Product">



 <resultMap id="ProductMap" class="Product">

  <result property="id" column="id" />

  <result property="description" column="description" />

  <result property="price" column="price" />

 </resultMap>



 <select id="getProductList" resultMap="ProductMap">

  select id, description, price from products

 </select>



</sqlMap>