SpringMVC+myBatis简单示例

来源：互联网发布：信息化系统数据库选择编辑：程序博客网时间：2024/05/15 05:18

1. [代码]控制器片段

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
packagecom.wg.test;
 
importjavax.servlet.http.HttpServletRequest;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.stereotype.Controller;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.RequestMethod;
importorg.springframework.web.servlet.ModelAndView;
importcom.wg.bean.User;
importcom.wg.service.UserService;
 
@Controller
publicclass UserController {
 
    @Autowired
    privateUserService userService;
 
    @RequestMapping(value = "regist", method = RequestMethod.POST)
    publicModelAndView regist(HttpServletRequest request, User user) {
        try{
            userService.saveUser(user);
        }catch(Exception e) {
            e.printStackTrace();
        }
        request.setAttribute("username", user.getUsername());
        request.setAttribute("password", user.getPassword());
        System.out.println(user.toString());
        returnnew ModelAndView("succ");
    }
 
    /***
     * 用户登陆
     * <p>
     * 注解配置，只允许POST提交到该方法
     *
     * @param username
     * @param password
     * @return
     */
    @RequestMapping(value = "login", method = RequestMethod.POST)
    publicModelAndView login(String username, String password) {
        // 验证传递过来的参数是否正确，否则返回到登陆页面。
        if(this.checkParams(newString[] { username, password })) {
            // 指定要返回的页面为succ.jsp
            ModelAndView mav = newModelAndView("succ");
            // 将参数返回给页面
            mav.addObject("username", username);
            mav.addObject("password", password);
            System.out
                    .println("username="+ username + " password=" + password);
            returnmav;
        }
        returnnew ModelAndView("home");
    }
 
    /***
     * 验证参数是否为空
     *
     * @param params
     * @return
     */
    privateboolean checkParams(String[] params) {
        for(String param : params) {
            if(param == ""|| param == null|| param.isEmpty()) {
                returnfalse;
            }
        }
        returntrue;
    }
}

2. [代码]web.xml配置

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?xml version="1.0"encoding="UTF-8"?> 
<web-app version="3.0"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_3_0.xsd"> 
       
    <!-- 监听spring上下文容器 -->  
    <listener> 
        <listener-class> 
            org.springframework.web.context.ContextLoaderListener 
        </listener-class> 
    </listener> 
       
    <!-- 加载spring的xml配置文件到 spring的上下文容器中 -->  
    <context-param> 
        <param-name>contextConfigLocation</param-name> 
        <param-value>classpath:*-context.xml</param-value> 
    </context-param> 
       
    <!-- 配置Spring MVC DispatcherServlet -->  
    <servlet> 
        <servlet-name>MVC</servlet-name> 
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 
        <!-- 初始化参数 -->  
        <init-param> 
            <!-- 加载SpringMVC的xml到 spring的上下文容器中 -->  
            <param-name>contextConfigLocation</param-name> 
            <param-value> 
                /WEB-INF/classes/mvc-context.xml 
            </param-value> 
        </init-param> 
        <load-on-startup>1</load-on-startup> 
    </servlet> 
   
    <!-- 配置DispatcherServlet所需要拦截的 url -->  
    <servlet-mapping> 
        <servlet-name>MVC</servlet-name> 
        <url-pattern>*.do</url-pattern> 
    </servlet-mapping> 
   
    <welcome-file-list> 
        <welcome-file>index.jsp</welcome-file> 
    </welcome-file-list> 
   
   
</web-app>

3. [代码]spring-mvc配置

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?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:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context-3.0.xsd">
 
    <context:component-scan base-package="com.wg.*"/>
 
    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.UrlBasedViewResolver">
        <property name="viewClass"
            value="org.springframework.web.servlet.view.JstlView"/>
        <property name="prefix"value="/page/"/>
        <property name="suffix"value=".jsp"/>
    </bean>
</beans>

4. [代码]userMapper配置

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<?xml version="1.0"encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wg.dao.UserDao">
    <!-- 取得用户列表 -->
    <select id="getUser"resultType="User"parameterType="User">
        select
        id,
        username,
        password
        From user
        <where>
            <iftest="username != null and password != null">
                username =#{username} and password =#{password}
            </if>
            <iftest="id!=null">
                and id=#{id}
            </if>
        </where>
    </select>
    <!-- 新增用户 -->
    <insert id="insertUser"parameterType="User">
        insert into user(id,username,password) values(#{id},#{username},#{password})
        <selectKey keyProperty="id"resultType="Long">
            select last_insert_id() as id
        </selectKey>
    </insert>
    <!-- 修改用户 -->
    <update id="updateUser"parameterType="User">
        update user
        <set>
            <iftest="username != null">username=#{username},</if>
            <iftest="password != null">password=#{password},</if>
        </set>
        where id=#{id}
    </update>
    <!-- 删除用户 -->
    <delete id="deleteUser"parameterType="Long">
        delete from user where id=#{id}
    </delete>
 
</mapper>

5. [图片] QQ图片20150513123831.png

0 0