org.apache.commons.dbcp.BasicDataSource »ç¿ëÇؼ DataSource ¼³Á¤
»ç¿ëÀÚ Á¤º¸¿Í ºñ¹Ð¹øÈ£°¡ xml¿¡ ¼³Á¤µÇ¾î ³ëÃ⠵Ǵ °æ¿ì°¡ ÀÖ¾î
º¸¾È»ó ¾ÏÈ£È ÇÒ ÇÊ¿ä°¡ ÀÖ´Ù.
ÀÌ°æ¿ì org.apache.commons.dbcp.BasicDataSource »ó¼Ó¹Þ¾Æ Ŭ·¡½º¸¦ ¸¸µé¾î¼ »ç¿ë ÇÏ¸é µÈ´Ù.
1. Spring¿¡¼ DataSource ¼³Á¤
<bean id="dataSource" destroy-method="close"
class="net.jlancer.db.SecureBasicDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<property name="url"
value="jdbc:oracle:thin:@localhost:1521:oradb" />
<property name="username" value="¾ÏȣȵȾÆÀ̵ð" /> <!-- ¾ÏÈ£È »ç¿ëÀÚ¾ÆÀ̵𸦠³ÖÀº´Ù. -->
<property name="password" value="¾ÏȣȵȺñ¹Ð¹øÈ£" /> <!-- ¾ÏÈ£È ºñ¹Ð¹øÈ£¸¦ ³Ö´Â´Ù. -->
</bean>
2. »ó¼Ó¹Þ¾Æ ¸¸µç Ŭ·¡½º
package net.jlancer.db;
import org.apache.commons.dbcp.BasicDataSource;
import com.aurasoft.crypto.PasswordEncrypt;
public class SecureBasicDataSource extends BasicDataSource {
//»ç¿ëÀÚ¾ÆÀ̵ð ¾ÏÈ£È ÇØÁ¦ ¼³Á¤
public void setUsername(String username){
//¾ÏÈ£È/ÇØÁ¦ ¸ðµâÀº °¢ÀÚ ¸Â´Â °ÍÀ» »ç¿ë ÇÏ¸é µË´Ï´Ù.
super.setUsername(PasswordEncrypt.Decrypt(username));
}
//ºñ¹Ð¹øÈ£ ¾ÏÈ£È ÇØÁ¦ ¼³Á¤
public void setPassword(String password) {
//¾ÏÈ£È/ÇØÁ¦ ¸ðµâÀº °¢ÀÚ ¸Â´Â °ÍÀ» »ç¿ë ÇÏ¸é µË´Ï´Ù.
super.setPassword(PasswordEncrypt.Decrypt(password));
}
}
Ãâó http://www.jlancer.net/board/article_view.jsp?article_no=1375&board_no=8