日期:2014-05-16 浏览次数:20550 次
用到的包大家可以百度上找,稍后给出所有源代码
jar包下载
1. 建立mysql数据库 名称 test
CREATE TABLE `person` ( `id` int(11) NOT NULL , `name` varchar(100) , `password` varchar(100), PRIMARY KEY (`id`) )
2.在 net.spring.bean下面建立一个实体Person
package net.spring.bean;
public class Person {
	int id;
	String name;
	String password;
	public Person(int id,String name,String password){
		this.id=id;
		this.name=name;
		this.password=password;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}
3.建立一个dao以及imp
package net.spring.dao;
import net.spring.bean.Person;
public interface PersonDAO {
	void save(Person person);
	void del(Person person);
	void update(Person person);
	void searchAll();
}
package net.spring.dao.imp;
import org.springframework.jdbc.core.JdbcTemplate;
import net.spring.bean.Person;
import net.spring.dao.PersonDAO;
public class PersonDAOIMP implements PersonDAO{
	JdbcTemplate jdbcTemplate;
	public void del(Person person) {
		// TODO Auto-generated method stub
			}
	public void save(Person person) {
		// TODO Auto-generated method stub
		jdbcTemplate.update("insert into person values(?,?,?)",
				new Object[]{person.getId(),person.getName(),person.getPassword()});
	}
	public void searchAll() {
		// TODO Auto-generated method stub
		
	}
	public void update(Person person) {
		// TODO Auto-generated method stub
		
	}
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
}
4.修改web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <display-name>Spring3MVC</display-name> <servlet> <servlet-name>spring</servlet-name> <servlet-class> org.springframework.web.servlet.DispatcherServlet </servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath*:spring-servlet.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>spring</servlet-name> <url-pattern>*.html</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>
 
5.建立一个配置文件spring-servlet.xml 路径在web.xml已经定义。在classpath也就是src根目录
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
   http://www.springframework.org/schema/context http://www.springframew