Dependencies:
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 ConnectorProject Folder Right Click > Build Path > Configure Build Path > Add External JARs > (Add this jar file)
Insert
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>