本人参照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>