Spring中配置数据源以及简单实现

在Spring的配置文件中

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/spring" />
		<property name="username" value="root" />
		<property name="password" value="123456" />
	</bean>

利用spring数据原来实现数据的插入

	public void save(User user) {
		try {
			Connection conn = dataSource.getConnection();
			conn.createStatement().executeUpdate("insert into user value(null,'Tom')");
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
			System.out.println("---是dataSource插入数据出错---");
		}
		System.out.println("user saved!");
	}