以修改用户前的查询为例
编写Mapper.xml
< ! -- 修改前查询 -- >
< select id= "findUserById" parameterType= "java.lang.Integer" resultType= "com.zhongruan.bean.user" >
select * from tb_user where id = #{ id}
< / select>
编写 service (service+ impl)
user findUserById ( int id) ;
@Override
public user findUserById ( int id) {
return userDao. findUserById ( id) ;
}
配置 Spring - MVC.xml 和 web.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: 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- 4.3 . xsd
http: / / www. springframework. org/ schema/ mvc
http: / / www. springframework. org/ schema/ mvc/ spring- mvc- 4.3 . xsd
http: / / www. springframework. org/ schema/ context
http: / / www. springframework. org/ schema/ context/ spring- context- 4.3 . xsd
http: / / www. springframework. org/ schema/ aop
http: / / www. springframework. org/ schema/ aop/ spring- aop- 4.3 . xsd
http: / / www. springframework. org/ schema/ tx
http: / / www. springframework. org/ schema/ tx/ spring- tx- 4.3 . xsd">
< ! -- 1. 注解扫描位置-- >
< context: component- scan base- package= "com.zhongruan.controller" / >
< ! -- 2. 配置映射处理和适配器-- >
< bean class= "org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping" / >
< bean class= "org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter" / >
< ! -- 3. 视图的解析器-- >
< bean class= "org.springframework.web.servlet.view.InternalResourceViewResolver" >
< property name= "prefix" value= "/pages/" / >
< property name= "suffix" value= ".jsp" / >
< / bean>
< ? xml version= "1.0" encoding= "UTF-8" ? >
< web- app xmlns: xsi= "http://www.w3.org/2001/XMLSchema-instance"
xmlns= "http://xmlns.jcp.org/xml/ns/javaee"
xsi: schemaLocation= "http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version= "3.1" >
< ! -- 配置加载类路径的配置文件 -- >
< context- param>
< param- name> contextConfigLocation< / param- name>
< param- value> classpath* : applicationContext. xml< / param- value>
< / context- param>
< ! -- 配置监听器 -- >
< listener>
< listener- class> org. springframework. web. context. ContextLoaderListener< / listener- class>
< / listener>
< listener>
< listener- class> org. springframework. web. context. request. RequestContextListener< / 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>
写Controller
@RequestMapping ( "/findUserById.do" )
public ModelAndView findUserById ( int id) {
user user = userService. findUserById ( id) ;
ModelAndView mv = new ModelAndView ( ) ;
mv. addObject ( "user" , user) ;
mv. setViewName ( "user-update" ) ;
return mv;
}