就是在spring中，对mysql数据库进行增删改查的样例，很easy。

文件结构

maven的pom.xml文件，里面用到的几个很重要的jar包都有

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <groupId>MySpring</groupId>

  <artifactId>MySpring</artifactId>

  <version>0.0.1-SNAPSHOT</version>

  <name>MySpring</name>

  <description>MySpring</description>

  <dependencies>

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-context</artifactId>

        <version>4.1.0.RELEASE</version>

    </dependency>

    <dependency>

	<groupId>org.springframework</groupId>

	<artifactId>spring-jdbc</artifactId>

	<version>4.1.0.RELEASE</version>

</dependency>

<dependency> <groupId> mysql</groupId>

     <artifactId> mysql-connector-java</artifactId>

     <version> 5.0.5</version>

      </dependency>

</dependencies>

</project>

操作类

package nx.database;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import javax.sql.DataSource;

public class StudentsDaoImpl implements StudentsDao{

	private DataSource dataSource;

	public DataSource getDataSource() {

		return dataSource;

	}

	public void setDataSource(DataSource dataSource) {

		this.dataSource = dataSource;

	}

	public void saveStudents() {

		Connection conn=null;

		PreparedStatement stmt=null;

		try {

			conn=dataSource.getConnection();

			stmt=conn.prepareStatement("INSERT INTO `data`.`student` (`id`, `name`) VALUES (NULL, 'jiang');");

			stmt.execute();

			stmt.close();

			conn.close();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		System.out.println("保存学生信息成功。");

	}

}

beans.xml（注意，数据库的password替换成你自己的password）

<?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-2.5.xsd">

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

<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>

<property name="url" value="jdbc:mysql://www.itbuluoge.com:3306/wordpress"></property>

<property name="username" value="root"></property>

<property name="password" value="1234451"></property>

</bean>

<bean id="userImpl" class="nx.database.StudentsDaoImpl">

<property name="dataSource" ref="dataSource"></property>

</bean>

</beans>

測试类

package nx.database;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test {

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		// TODO Auto-generated method stub

		ApplicationContext ctx=new ClassPathXmlApplicationContext("nx/database/beans.xml");

		StudentsDaoImpl userImpl=(StudentsDaoImpl)ctx.getBean("userImpl");

		userImpl.saveStudents();

	}

}

在完毕后，查看数据库，发现已经有了数据