New > Spring Legacy Project > Spring MVC Project > "MyBatisTest" > "com.test.mybatis" > Finish
μ΄κΈ° μΈν
μ μ΄λμ λ ν΄μ£Όλμ μ°¨μ΄
spring bootκ° μΈν
μ λ§μ΄ ν΄μ€λ€.
μ€λΉκ° λ§μΉκ³ λλ©΄ μ€ννλ λ°©λ²μ λμΌνλ€.
C:\class\dev\pom_23.11.23.xml
μ±κ³΅
μ€ν¨
- List > DBUtil.open() > conn.close()
- View > DBUtil.open()
- Add > DBUtil.open()
μμ λ λ§μ + νμμ
νλ‘μ νΈ λ μ close μ μνλκ°? -> μμ΄ λ§μ΄ κ°μ.
νμ§λ§ λ§€λ² λμ΄μ£Όλκ² μ’λ€.
CPκ° λ―Έλ¦¬ connectionμ λ§λ€μ΄ λκ³ DBμ μ°κ²°ν΄λλ€.
첫 λ²μ§Έ μ¬λμ΄ connectionμ΄ νμνλ€
-> μ°κ²°λ connectionμ λμ¬ν΄μ€λ€.
-> DB μμ
λ
-> connection νμ
λ§μ½ 미리 λ§λ€μ΄λ κ°μ²΄κ° μλ€λ©΄ μλ‘μ΄ μ¬μ©μλ κΈ°λ€λ¦¬κ² νλ€.
κΈ°λ€λ¦¬λ μκ°μ΄ 짧μΌλ―λ‘ ν° λ¬Έμ κ° μλ€.
package com.test.mybatis.persistence;
import static org.junit.Assert.assertNotNull;
import javax.sql.DataSource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import lombok.extern.log4j.Log4j;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
@Log4j
public class DBCPTest {
@Autowired
private DataSource dataSource;
@Test
public void testConnection() {
assertNotNull(dataSource);
}
}
μμ±
"com.test.controller" > "MyBatisController.java"
"com.test.persistence"
> "MyBatisDAO.java"(I)
> "MyBatisDAOImpl.java"(C)
"com.test.domain" > "MyBatisDTO.java"
src/main/resources > mapper > "mybatis.xml"
views
> "list.jsp"
> "add.jsp"
> "addok.jsp"
MyBatisTest > "script.sql"
Controllerλ§ λ§λ λ€κ³ νμ§λ§
μμλ₯Ό λ€μ¬λ€λ³΄λ©΄ μ°μμ μΌλ‘ μ¬λ¬ κ°μ²΄λ₯Ό μμ±νλ€.
1κ°μ controller κ°μ²΄ μμ± -> μ΄ 6κ° κ°μ²΄ μμ±