[Spring] DB setting

Dependencies:

• Spring context
• Spring core
• Spring jdbc
• commons-dbcp
• mysql-connector

Add these on POM.xml

<project>
    ...
    </build>
    <dependencies>
        // You write Dependencies here.
    </dependencies>
</project>

Spring context

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.2.5.RELEASE</version>
</dependency>

Spring core

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>4.2.5.RELEASE</version>
</dependency>

Spring jdbc

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.2.5.RELEASE</version>
</dependency>

Commons-dbcp

<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
</dependency>

MySQL connector

Download MySQL Connector
Project Folder Right Click > Build Path > Configure Build Path > Add External JARs > (Add this jar file)

Insert

1. BookDaoSpring.java
2. Test.java
3. applicationContext.xml

BookDaoSpring.java

public class BookDaoSpring {
    // dao relies on this Object
    private JdbcTemplate jdbcTemplate;
    // Constructor, Setter for DI
    public BookDaoSpring() {}
    public BookDaoSpring(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
////////////////////////////////////////////////////////
    public int insert(BookVO book) {
        String sql = 
            "INSERT INTO BOOK(TITLE,PUBLISHER,PRICE,WRITER)"
            +"VALUES(?,?,?,?)"; 
        return jdbcTemplate.update(sql,
                book.getTitle(),
                book.getPublisher(),
                book.getPrice(),
                book.getWriter());
    }
}

Test.java

public class Test {
    public static void main(String[] args) {
        ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("test02_spring/applicationContext.xml");
        BookDaoSpring dao = context.getBean("dao", BookDaoSpring.class);
  
        BookVO book = new BookVO("Spring textbook", "meme", 30000, "Samsung");
 System.out.println("insert Result"+dao.insert(book));
    }
}

applicationContext.xml

Right Click its package > New > Spring Bean Configuration File > name it 'applicationContext'

<bean id="ddd" class="org.apache.commons.dbcp.BasicDataSource">
 <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
 <property name="url" value="jdbc:mysql://127.0.0.1./spring"/>
 <property name="username" value="root"/>
 <property name="password" value="sds1501"/>
</bean>

<bean id="jjjj" class="org.springframework.jdbc.core.JdbcTemplate">
 <property name="dataSource" ref="ddd"/>
</bean>

<bean id="dao" class="test02_spring.BookDaoSpring">
 <property name="jdbcTemplate" ref="jjjj"/>
</bean>