Spring4-通過Maven構建Spring+JDBC

1.創建Maven項目,項目名(springdemo13),操作如圖所示

2.配置Maven,修改pom.xml文件,內容如下

<project xmlns="http://maven.apache.org/POM/4.0.0" 
xmlns:xsi="  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>1.0.0</modelVersion>
  <groupId>shequ</groupId>
  <artifactId>springdemo13</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
  <properties>
  	<java.version>1.7</java.version>
  	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  	<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  </properties>
  
  <repositories>
  	<repository>
  		<id>codelds</id>
  		<url>https://code.lds.org/nexus/content/groups/main-repo</url>
  	</repository>
  </repositories>
  
  <dependencies>
      <dependency>
          <groupId>junit</groupId>
  	  <artifactId>junit</artifactId>
  	  <version>4.10</version>
      </dependency>
  	
      <dependency>
  	  <groupId>org.springframework</groupId>
  	  <artifactId>spring-core</artifactId>
  	  <version>4.1.4.RELEASE</version>
      </dependency>
  	
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-context</artifactId>
          <version>4.1.4.RELEASE</version>
      </dependency>
    
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>4.1.4.RELEASE</version>
      </dependency>
    
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.34</version>
      </dependency>
      
  </dependencies>
  <build/>
</project>

3.在src/main/java下創建實體Bean Forum,包名(com.mycompany.shequ.bean),如圖所示

4.實體Bean Forum的內容如下

package com.mycompany.shequ.bean;

public class Forum {
	private int fid;
	private String name;
	public int getFid() {
		return fid;
	}
	public void setFid(int fid) {
		this.fid = fid;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

5.在src/main/java下創建接口ForumDao,包名(com.mycompany.shequ.dao),如圖所示

6.接口ForumDao的內容如下

package com.mycompany.shequ.dao;

import java.util.List;

import com.mycompany.shequ.bean.Forum;



public interface ForumDao {
	public List<Forum> query() throws Exception ;
}

7.在src/main/java下創建接口ForumDao的實現類ForumDaoImpl,包名(com.mycompany.shequ.dao.impl),如圖所示

8.接口ForumDao的實現類ForumDaoImpl的內容如下

package com.mycompany.shequ.dao.impl;


import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;

import com.mycompany.shequ.bean.Forum;
import com.mycompany.shequ.dao.ForumDao;

public class ForumDaoImpl implements ForumDao{

	private DataSource dataSource;
	
	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

	public List<Forum> query() throws Exception {
		Connection conn = dataSource.getConnection();
		
		String sql = "select * from hnsq_forum";
		Statement smt = conn.createStatement();
		
		ResultSet rs = smt.executeQuery(sql);
		List<Forum> forumList = new ArrayList<Forum>();
		while(rs.next()){
			Forum forum = new Forum();
			forum.setFid(rs.getInt("fid"));
			forum.setName(rs.getString("name"));
			forumList.add(forum);
		}
		
		return forumList;
	}
}

9.在src/main/resources下創建database目錄,存儲spring數據源spring-datasource.xml文件,如圖所示

10.數據源spring-databsource.xml文件的內容如下

<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">

		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/b_shequ_two" />
		<property name="username" value="root" />
		<property name="password" value="" />
	</bean>

</beans>

11.在src/main/resources下創建dao目錄,存儲相應的bean文件,文件名稱spring-forum.xml,如圖所示

12.spring-forum.xml的內容如下

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans.xsd">

   <bean id="forumDao"
       class="com.mycompany.shequ.dao.impl.ForumDaoImpl">
       <property name="dataSource" ref="dataSource" />
   </bean>

</beans>

13.在src/main/resources下創建spring核心配置文件spring-module.xml,如圖所示

14.spring核心配置文件spring-module.xml的內容如下

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans.xsd">

   <!-- Using mysql datasource -->
   <import resource="database/spring-datasource-mysql.xml" />
   <import resource="dao/spring-forum.xml" />

</beans>

15.在src/test/java目錄下創建測試類ForumDaoImplTest,包名(com.mycompany.shequ.dao.impl),如圖所示

16.測試類ForumDaoImplTest的內容如下

package com.mycompany.shequ.dao.impl;

import java.util.List;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.mycompany.shequ.bean.Forum;
import com.mycompany.shequ.dao.ForumDao;

public class ForumDaoImplTest {
	@Test
	public void queryTest(){
		ApplicationContext context = new ClassPathXmlApplicationContext("spring-module.xml");
		
		ForumDao forumDao = (ForumDao) context.getBean("forumDao");
		
		try {
			List<Forum> forumList = forumDao.queryDepartment();
			for (Forum forum : forumList) {
				System.out.println(forum.getFid());
				System.out.println(forum.getName());
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

17.在測試類ForumDaoImplTest的queryTest方法上右鍵執行,輸出結果如圖所示