练习springMVC的一个小例子，为了方便以后继续学习springmvc和别的框架整合

本人参照http://www.admin10000.com/document/6436.html试着做了一个小例子

本人用的是mysql数据库 

web-xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
id="WebApp_ID" version="2.5">
<display-name>springMVC</display-name>
<welcome-file-list>
<welcome-file>hello.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc-servlet.xml</param-value>
</init-param>
<!-- <load-on-startup>1</load-on-startup> -->
</servlet>


<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
</web-app>

springmvc-servlet.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" xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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.springframework.org/schema/context/spring-context-4.1.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd">


<!-- scan the package and the sub package -->
<context:component-scan base-package="test.SpringMVC" />


<!-- don't handle the static resource -->
<mvc:default-servlet-handler />


<!-- if you use annotation you must configure following setting -->
<mvc:annotation-driven />


<!-- configure the InternalResourceViewResolver -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver"
id="internalResourceViewResolver">
<!-- 前缀 -->
<property name="prefix" value="/WEB-INF/jsp/" />
<!-- 后缀 -->
<property name="suffix" value=".jsp" />
</bean>
<bean id="config"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:db-config.properties</value>
</list>
</property>
</bean>
<!-- 获取数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>${db.dirverClass}</value>
</property>
<property name="url">
<value>${db.url}</value>
</property>
<property name="username">
<value>${db.username}</value>
</property>
<property name="password">
<value>${db.password}</value>
</property>
</bean>
<bean name="jdbcTemelate" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="personDaoImpl" class="test.SpringMVC.daoImpl.PersonDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemelate"></property>
</bean>

</beans>

db-config.properties

db.url= jdbc:MySQL://localhost:3306/mydb?useUnicode=true&characterEncoding=utf8


db.username=root


db.password=123456


db.dirverClass= com.mysql.jdbc.Driver

mvcController 类

@Controller
@RequestMapping("/mvc")
public class mvcController {
@Autowired
PersonDaoImpl personDao;
private String name;
private String age;
    @RequestMapping("/login")
    public String login(){        
        return "login";
    }
    
    //insert
    @RequestMapping("/person1")
    public String toPerson(Person person){
    personDao.insertPerson(person);
        System.out.println(person.getName()+" "+person.getAge());
        return "index";
    }
    //login
    @RequestMapping("/loginUser")
    public String loginUser(Person person,Model model){
    List<Person> list = personDao.ListPerson();
    if(list == null || list.equals("")){
    return "error";
    }
    model.addAttribute("list",list);
    return "index";
    }
    //login
    @RequestMapping("/editPerson")
    public String editPerson(Person person){
    System.out.println(person.getId());
    return "index";
    }
  
public String getName() {
return name;
}


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


public String getAge() {
return age;
}


public void setAge(String age) {
this.age = age;
}




public PersonDaoImpl getPersonDao() {
return personDao;
}




public void setPersonDao(PersonDaoImpl personDao) {
this.personDao = personDao;
}

PersonDao 接口

@Service
public interface PersonDao {


public void insertPerson(Person person);
public Person selectPerson(Person person);
public List<Person> ListPerson();
}

public class PersonDaoImpl extends JdbcDaoSupport implements PersonDao {
// @Autowired
// DataSource dataSource;
private JdbcTemplate jdbcTemplate;




public JdbcTemplate getTemplate() {
return jdbcTemplate;
}


public void setTemplate(JdbcTemplate template) {
this.jdbcTemplate = template;
}


@Override
public void insertPerson(Person person) {
String sql = " insert into user (name,age) values('"+person.getName()+"','"+person.getAge()+"')";
this.getJdbcTemplate().update(sql);
}


@Override
public Person selectPerson(Person person) {
return person;
}


@Override
public List<Person> ListPerson() {
String sql = "select * from user";
List<Person> list = this.getJdbcTemplate().query(sql,  new BeanPropertyRowMapper(Person.class));
return list;
}


}

public class Person {
public int id;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
  
    public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}


private String name;
    private String age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
     
}

login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录</title>
</head>
<body>
<form action="loginUser.do" method="post">
<input type="text" name="name"/>
<input type="text" name="age"/>
<input type="submit" value="登录">
</form>
</body>
</html>

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<table border="1" width="500px" height="300px" align="center">
<tr>
<td>姓名</td>
<td>年龄</td>
<td>操作</td>
</tr>
<c:forEach items="${list}" var="test">
<tr>
   <td  style="display:none;">${test.id}</td>
<td>${test.name}</td>
<td>${test.age}</td>
<td><a name="${test.id}" href="editPerson.do">修改</a></td>
</tr>
</c:forEach>


</table>
</body>
</html>