首页 > 代码库 > SpringMVC+myBatis简单示例分享

SpringMVC+myBatis简单示例分享

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
package com.wg.test;
 
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;
import com.wg.bean.User;
import com.wg.service.UserService;
 
@Controller
public class UserController {
 
    @Autowired
    private UserService userService;
 
    @RequestMapping(value = http://www.mamicode.com/"regist", method = RequestMethod.POST)
    public ModelAndView 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());
        return new ModelAndView("succ");
    }
 
    /***
     * 用户登陆
     * <p>
     * 注解配置,只允许POST提交到该方法
     *
     * @param username
     * @param password
     * @return
     */
    @RequestMapping(value = http://www.mamicode.com/"login", method = RequestMethod.POST)
    public ModelAndView login(String username, String password) {
        // 验证传递过来的参数是否正确,否则返回到登陆页面。
        if (this.checkParams(new String[] { username, password })) {
            // 指定要返回的页面为succ.jsp
            ModelAndView mav = new ModelAndView("succ");
            // 将参数返回给页面
            mav.addObject("username", username);
            mav.addObject("password", password);
            System.out
                    .println("username=" + username + " password=" + password);
            return mav;
        }
        return new ModelAndView("home");
    }
 
    /***
     * 验证参数是否为空
     *
     * @param params
     * @return
     */
    private boolean checkParams(String[] params) {
        for (String param : params) {
            if (param == "" || param == null || param.isEmpty()) {
                return false;
            }
        }
        return true;
    }
}

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=http://www.mamicode.com/"org.springframework.web.servlet.view.JstlView" />
        <property name="prefix" value=http://www.mamicode.com/"/page/" />
        <property name="suffix" value=http://www.mamicode.com/".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>
            <if test="username != null and password != null">
                username =#{username} and password =#{password}
            </if>
            <if test="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>
            <if test="username != null">username=#{username},</if>
            <if test="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    

技术分享
 

源码来源:http://minglisoft.cn/technology

朋友需要请加QQ:2042849237

 

SpringMVC+myBatis简单示例分享