SpringMVC之简单的增删改查示例（SSM整合）

<?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:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd"> <!-- 文件扫描 --> <context:component-scan base-package="com.zhao"></context:component-scan> <!-- annotation-driven:默认创建了多个对象：RequestMappingHandlerMapping，RequestMappingHandlerAdapter 也就提供对json格式支持 --> <mvc:annotation-driven/> <!-- 视图解析器 --> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/WEB-INF/jsp/" /> <property name="suffix" value=".jsp" /> </bean></beans>

<?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:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd"> <context:component-scan base-package="com.zhao"></context:component-scan> <!-- 第一步：配置数据源 --> <context:property-placeholder location="classpath:jdbc.properties" /> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="jdbcUrl" value="${jdbc.url}"></property> <property name="driverClass" value="${jdbc.driver}"></property> <property name="user" value="${jdbc.username}"></property> <property name="password" value="${jdbc.password}"></property> </bean> <!-- 第二步：创建sqlSessionFactory。生产sqlSession --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"></property> <property name="configLocation" value="classpath:sqlMapConfig.xml"></property> </bean> <!-- 配置mybatis接口代理开发 * 接口类名和映射文件必须同名 *接口类和映射文件必须在同一个目录下 * 映射文件namespace名字必须是接口的全类路径名 *接口的方法名必须和映射Statement的ｉｄ一致 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.zhao.mapper"></property> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property> </bean> <!-- 第三步：事务 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"></property> </bean> <!-- 配置通知 --> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="save*" propagation="REQUIRED" /> <tx:method name="update*" propagation="REQUIRED" /> <tx:method name="delete*" propagation="REQUIRED" /> <tx:method name="insert*" propagation="REQUIRED" /> <tx:method name="*" propagation="REQUIRED" /> </tx:attributes> </tx:advice> <!-- 配置拦截service --> <aop:config> <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.zhao.service.*.*(..))"/> </aop:config></beans>

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc\:mysql\://localhost\:8888/blogjdbc.username=rootjdbc.password=123456

<?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" xmlns:web="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" version="2.5"> <display-name></display-name> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:beans.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <filter> <filter-name>CharacterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <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.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>springmvc</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping></web-app>

@RequestMapping("/list") public String UserList(Model model) { List<User> list =userService.findAll(); //传递数据至前端 model.addAttribute("list",list); //返回对应视图 return "itemsList"; }

@Overridepublic List<User> findAll() { UserExample example = new UserExample(); List<User> list= userMapper.selectByExample(example); return list;}

<table width="100%" border=1><tr> <td>ID</td> <td>用户名</td> <td>密码</td> <td>昵称</td> <td>电子邮箱</td> <td>操作</td></tr><c:forEach items="${list}" var="item"><tr> <td> <input type="checkbox" name="iduser" value="${item.iduser}"> </td> <td>${item.username }</td> <td>${item.password }</td> <td>${item.nickname }</td> <td>${item.email }</td> <td><a href="${pageContext.request.contextPath }/user/edit?iduser=${item.iduser}" rel="external nofollow" >修改</a> <a href="${pageContext.request.contextPath }/user/deleteByID?iduser=${item.iduser}" rel="external nofollow" >删除</a> </td></tr></c:forEach>

@RequestMapping("/edit")public String Edit(Integer iduser,Model model){ User user=userService.findById(iduser); model.addAttribute("item",user); return "editItem";}

@RequestMapping("/edit")public String Edit(Integer iduser,Model model){ User user=userService.findById(iduser); //将要修改的值传递到前端 model.addAttribute("item",user); return "editItem";}@RequestMapping(value ="/saveOrUpdate",method = RequestMethod.POST)public String saveOrUpdate(User user){ //保存修改的值 userService.update(user); //跳转到对应的list路由 return "redirect:list";}

<form id="itemForm" action="${pageContext.request.contextPath }/user/saveOrUpdate" method="post"><input type="hidden" name="iduser" value="${item.iduser }"/>修改商品信息：<table width="100%" border=1><tr> <td>用户名称</td> <td><input type="text" name="username" value="${item.username }"/></td></tr><tr> <td>密码</td> <td><input type="text" name="password" value="${item.password}"/></td></tr><tr> <td>昵称</td> <td><input type="text" name="nickname" value="${item.nickname}"/></td></tr><tr> <td>email</td> <td><input type="text" name="email" value="${item.email}"/></td></tr><tr><td colspan="2" align="center"><input type="submit" value="提交"/></td></tr></table></form>

@RequestMapping("/deleteByID")public String deleteByID(Integer iduser){ userService.deleteById(iduser); return "redirect:list";}

@Overridepublic void deleteById(Integer iduser) { // TODO Auto-generated method stub userMapper.deleteByPrimaryKey(iduser);}

//超链接到对应的页面@RequestMapping("/add")public String Add(){ return "AddUser";}//保存数据到数据库后跳转到列表页面@RequestMapping("/addUser")public String Insert(User user){ userService.insert(user); return "redirect:list";}

@Overridepublic void insert(User user) { userMapper.insert(user);}

<form id="itemForm" action="${pageContext.request.contextPath }/user/addUser" method="post">商品信息：<table width="100%" border=1><tr> <td>用户名称</td> <td><input type="text" name="username"/></td></tr><tr> <td>密码</td> <td><input type="text" name="password"/></td></tr><tr> <td>昵称</td> <td><input type="text" name="nickname" /></td></tr><tr> <td>email</td> <td><input type="text" name="email"/></td></tr><tr><td colspan="2" align="center"><input type="submit" value="提交"/></td></tr></table></form>