Spring4.0.2,基于xml版本的操作，包括jdbc【附完整源码下载】

源代码下载地址+jar包：https://git.oschina.net/zhuhongliang/spring4.0.2_Study

 

先看下文档目录结构：

这是我们要查看的数据：

很好，只有这三个文件，下面看源代码。

App.java:

 

package com.zhl.xml;

import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class App {
	public static void main(String[] args) {
		ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); 
		
		HelloWorld obj = (HelloWorld) context.getBean("helloBean");
		
		//obj.setName("打南边来了一个喇嘛 \t ");
		obj.printHello();
		obj.find();
	}
	
}

HelloWorld.java:

package com.zhl.xml;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;

/**
 * Spring bean
 * 
 */
public class HelloWorld {
	private String name;

	public void setName(String name) {
		this.name = name;
	}

	public void printHello() {
		System.out.println( name +" \t 手里提着五斤鳎蚂! ");
	}
	
	

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

	public void find() {
		Connection conn = null;
		
		try {
			conn = dataSource.getConnection();
			String sql = "select * from `user` ";
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				
				System.out.println("----------------------------------");
				System.out.println("name\t"+rs.getString("name"));
				System.out.println("age\t"+rs.getInt("age"));
				System.out.println("sex\t"+rs.getString("sex"));

			}
	
		}catch(Exception e){
			System.out.println(e);
		}
	}
}

applicationContext.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="jdbcDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
	    <property name="driverClassName">  
	        <value>org.gjt.mm.mysql.Driver</value>  
	    </property>  
	    <property name="url">  
	        <value>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8</value>  
	    </property>  
	    <property name="username">  
	        <value>root</value>  
	    </property>  
	    <property name="password">  
	        <value>root</value>  
	    </property>  
	</bean>  
	
	<bean id="helloBean" class="com.zhl.xml.HelloWorld">
		<property name="name" value="打北边来了个哑巴" />
		<property name="dataSource" ref="jdbcDataSource" />  
	</bean>

	
</beans>

运行结果：(控制台上面有两行log4j的提示，我们不要管他)

log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
log4j:WARN Please initialize the log4j system properly.
打北边来了个哑巴 	 手里提着五斤鳎蚂! 
----------------------------------
name	tom
age	88
sex	man
----------------------------------
name	孙悟空
age	99999
sex	齐天大圣

 

源代码下载地址+jar包：https://git.oschina.net/zhuhongliang/spring4.0.2_Study