Springmvc+Spring+Mybatis+Maven简单的增删改查

Spring介绍:

spring 使用基本的 JavaBean 来完成以前只可能由 EJB 完成的事情。然而， Spring的用途不仅限于服务器端的开发。从简单性、可测试性和松耦合的角度而言，任何Java 应用都可以从 Spring 中受益。简单来说， Spring 是一个轻量级的控制反转（IoC ）和面向切面（ AOP ）的容器框架。

SpringMVC介绍

Spring MVC 属于 SpringFrameWork 的后续产品，已经融合在Spring Web Flow 里面。 Spring MVC 分离了控制器、模型对象、分派器以及处理程序对象的角色，这种分离让它们更容易进行定制。

MyBatis介绍

MyBatis 本是 apache 的一个开源项目 iBatis , 2010 年这个项目由apache software foundation 迁移到了 google code ，并且改名为 MyBatis 。MyBatis 是一个基于 Java 的持久层框架。 iBATIS 提供的持久层框架包括SQL Maps 和 Data Access Objects （ DAO ） MyBatis 消除了几乎所有的 JDBC 代码和参数的手工设置以及结果集的检索。 MyBatis 使用简单的首先不是maven架构整合的 SSM 框架

创建数据库、表db_zsl t_user user_t【最下面有sql语句】

1.项目整体结构

2.添加相关jar 包

3.项目整体结构出来了

4.创建model【User】

[java] view plain copy

package com.lyt.model;
/**
* 用户
* @author
*
*/
public class User {
private int id;
private String userName;
private String age;
@Override
public String toString() {
return "User [id=" + id + ", age=" + age + ", userName=" + userName
+ "]";
}
public User(){
super();
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public User(int id, String age, String userName) {
super();
this.id = id;
this.age = age;
this.userName = userName;
}
}

5.创建DAO接口【在mybatis中 mapper就相当于dao】

[java] view plain copy

package com.lyt.mapper;
import java.util.List;
import com.lyt.model.User;
/**
* 做为 DAO的接口
* @author
*/
public interface UserMapper {
void save(User user);
boolean update(User user);
boolean delete(int id);
User findById(int id);
List<User> findAll();
}
5.创建DAO接口【在mybatis中 mapper就相当于dao】

[java] view plain copy
1. package com.lyt.mapper;
3. import java.util.List;
5. import com.lyt.model.User;
6. /**
7. * 做为 DAO的接口
8. * @author */
9. public interface UserMapper {
10. void save(User user);
11. boolean update(User user);
12. boolean delete(int id);
13. User findById(int id);
14. List<User> findAll();
15. }
6.实现dao接口【mybatis中就是UserMapper.[python] view plain copy
1. <?"1.0" encoding="UTF-8"?>
2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
3. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
4. 
8. <mapper namespace="com.lyt.mapper.UserMapper">
10. <insert id="save" parameterType="User">
11. insert into t_user(user_name,user_age) values(#{userName},#{age})
12. </insert>
14. <update id="update" parameterType="User">
15. update t_user set user_name=#{userName},user_age=#{age} where user_id=#{id}
16. </update>
18. <delete id="delete" parameterType="int">
19. delete from t_user where user_id=#{id}
20. </delete>
22. 
23. <select id="findById" parameterType="int" resultType="User">
24. select user_id id,user_name userName,user_age age from t_user where user_id=#{id}
25. </select>
27. <select id="findAll" resultType="User">
28. select user_id id,user_name userName,user_age age from t_user
29. </select>
31. </mapper>
这里对这个1、namespace必须与对应的接口全类名一致。
2、id必须与对应接口的某个对应的方法名一致即必须要和UserMapper.java接口中的方法同名。

---------------------------------------------------
7.mybatis与Spring整合【spring-common.
对于Mybatis和Spring的整合是这篇博文的重点，需要配置的内容在下面有详细的解释。

[python] view plain copy
1. <?"1.0" encoding="UTF-8"?>
2. <beans "http://www.springframework.org/schema/beans"
3. "http://www.w3.org/2001/"http://www.springframework.org/schema/p"
4. "http://www.springframework.org/schema/context" "http://www.springframework.org/schema/tx"
5. xsi:schemaLocation="
6. http://www.springframework.org/schema/beans
7. http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
8. http://www.springframework.org/schema/context
9. http://www.springframework.org/schema/context/spring-context-4.0.xsd
10. http://www.springframework.org/schema/tx
11. http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
13. 
14. 
15. <bean id="dataSource"
16. class="org.springframework.jdbc.datasource.DriverManagerDataSource">
17. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
18. <property name="url" value="jdbc:mysql://localhost:3306/db_zsl" />
19. <property name="username" value="root" />
20. <property name="password" value="root" />
21. </bean>
23. 
28. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
29. <property name="dataSource" ref="dataSource"></property>
30. <property name="configLocation" value="classpath:mybatis-config.
31. </bean>
33. 
38. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
39. <property name="basePackage" value="com.lyt.mapper"></property>
40. <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
41. </bean>
43. 
46. <bean id="txManager"
47. class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
48. <property name="dataSource" ref="dataSource"></property>
49. </bean>
51. 
54. <tx:annotation-driven transaction-manager="txManager" />
56. </beans>
57. 8.mybatis配置文件【mybatis-config.
  
  [python] view plain copy
  1. <?"1.0" encoding="UTF-8"?>
  2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  3. "http://mybatis.org/dtd/mybatis-3-config.dtd">
  4. <configuration>
  6. 
  7. <typeAliases>
  8. <typeAlias alias="User" type="com.lyt.model.User" />
  9. </typeAliases>
  10. 
  11. 
  14. <mappers>
  15. <mapper resource="com/lyt/mapper/userMapper.
  16. </mappers>
  18. </configuration>
  19. 配置log4j.properties
    
    [python] view plain copy
    1. ### set log levels ###
    2. log4j.rootLogger = info , Console , D
    3. #Console
    4. log4j.appender.Console=org.apache.log4j.ConsoleAppender
    5. log4j.appender.Console.layout=org.apache.log4j.PatternLayout
    6. log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
    7. log4j.logger.java.sql.ResultSet=INFO
    8. log4j.logger.org.apache=INFO
    9. log4j.logger.java.sql.Connection=INFO
    10. log4j.logger.java.sql.Statement=INFO
    11. log4j.logger.java.sql.PreparedStatement=INFO
    12. #output2file
    13. log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
    14. log4j.appender.D.File = D\:/logs/log.log
    15. log4j.appender.D.Append = true
    16. log4j.appender.D.Threshold = INFO \#\# \u00E8\u00BE\u0093\u00E5\u0087\u00BAinfo\u00E7\u00BA\u00A7\u00E5\u0088\u00AB\u00E4\u00BB\u00A5\u00E4\u00B8\u008A\u00E7\u009A\u0084\u00E6\u0097\u00A5\u00E5\u00BF\u0097
    17. log4j.appender.D.layout = org.apache.log4j.PatternLayout
    18. log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} [ %t\:%r ] - [ %p ] %m%n
    10.整合Springmvc
    配置【spring-mvc.
    
    [python] view plain copy
    1. <?"1.0" encoding="UTF-8"?>
    2. <beans "http://www.springframework.org/schema/beans"
    3. "http://www.w3.org/2001/"http://www.springframework.org/schema/context"
    4. "http://www.springframework.org/schema/mvc"
    5. xsi:schemaLocation="http://www.springframework.org/schema/beans
    6. http://www.springframework.org/schema/beans/spring-beans.xsd
    7. http://www.springframework.org/schema/context
    8. http://www.springframework.org/schema/context/spring-context-4.0.xsd
    9. http://www.springframework.org/schema/mvc
    10. http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
    12. 
    13. <context:component-scan base-package="com.lyt.controller" />
    14. <context:component-scan base-package="com.lyt.service" />
    16. 
    17. <mvc:annotation-driven />
    19. 
    22. <mvc:resources mapping="/img/**" location="/img/" />
    23. <mvc:resources mapping="/js/**" location="/js/" />
    24. <mvc:resources mapping="/css/**" location="/css/" />
    25. <mvc:resources mapping="/html/**" location="/html/" />
    29. 
    30. <bean id="viewResolver"
    31. class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    32. 
    33. <property name="prefix" value="/WEB-INF/jsp/" />
    34. <property name="suffix" value=".jsp" />
    35. </bean>
    36. </beans>
    37. 11.配置web.
      
      [python] view plain copy
      1. <?"1.0" encoding="UTF-8"?>
      2. <web-app version="2.5" "http://java.sun.com/
      3. "http://www.w3.org/2001/
      4. xsi:schemaLocation="http://java.sun.com/
      5. http://java.sun.com/
      7. 
      8. <listener>
      9. <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      10. </listener>
      12. 
      13. <context-param>
      14. <param-name>contextConfigLocation</param-name>
      15. 
      21. <servlet>
      22. <servlet-name>springMVC</servlet-name>
      23. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      24. 
      25. <init-param>
      26. <param-name>contextConfigLocation</param-name>
      27. <param-value>classpath:spring-common.
      28. </init-param>
      29. 
      30. <load-on-startup>1</load-on-startup>
      31. </servlet>
      33. 
      34. <servlet-mapping>
      35. <servlet-name>springMVC</servlet-name>
      36. 
      37. <url-pattern>/</url-pattern>
      38. </servlet-mapping>
      40. 
      41. <listener>
      42. <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
      43. </listener>
      45. 
      46. <filter>
      47. <filter-name>encodingFilter</filter-name>
      48. <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
      49. <init-param>
      50. <param-name>encoding</param-name>
      51. <param-value>UTF-8</param-value>
      52. </init-param>
      53. <init-param>
      54. <param-name>forceEncoding</param-name>
      55. <param-value>true</param-value>
      56. </init-param>
      57. </filter>
      59. <filter-mapping>
      60. <filter-name>encodingFilter</filter-name>
      61. <url-pattern>/*</url-pattern>
      62. </filter-mapping>
      64. <welcome-file-list>
      65. <welcome-file>index.jsp</welcome-file>
      66. </welcome-file-list>
      67. </web-app>
      68. 12.建立service以及service实现【UserService.java】
        
        [python] view plain copy
        
        package com.lyt.service;
        
        import java.util.List;
        
        import com.lyt.model.User;
        
        public interface UserService {
            void save(User user);
            boolean update(User user);
            boolean delete(int id);
            User findById(int id);
            List<User> findAll();
        }
        
        【UserServiceImpl.java】
        
        [python] view plain copy
        
        package com.lyt.service.impl;
        
        import java.util.List;
        
        import javax.annotation.Resource;
        
        import org.springframework.stereotype.Service;
        import org.springframework.transaction.annotation.Transactional;
        
        import com.lyt.mapper.UserMapper;
        import com.lyt.model.User;
        import com.lyt.service.UserService;
        
        @Service
        @Transactional
        // 此处不再进行创建SqlSession和提交事务，都已交由spring去管理了。
        public class UserServiceImpl implements UserService {
        
            @Resource
            private UserMapper mapper;
        
            /**
             * 根据  id  删除数据
             */
            public boolean delete(int id) {
                return mapper.delete(id);
            }
            /**
             * 查询User的全部数据
             */
            public List<User> findAll() {
                List<User> findAllList = mapper.findAll();
                return findAllList;
            }
            /**
             * 根据 id 查询对应数据
             */
            public User findById(int id) {
                User user = mapper.findById(id);
                return user;
            }
            /**
             * 新增数据
             */
            public void save(User user) {
                mapper.save(user);
            }
            /**
             * 根据 id 修改对应数据
             */
            public boolean update(User user) {
                return mapper.update(user);
            }
        
        }
        13.建立Controller【UserController.java】
        
        [python] view plain copy
        
        <span style="font-size:14px;">package com.lyt.controller;
        
        import java.io.IOException;
        import java.io.PrintWriter;
        import java.util.List;
        
        import javax.servlet.http.HttpServletRequest;
        import javax.servlet.http.HttpServletResponse;
        
        import org.springframework.beans.factory.annotation.Autowired;
        import org.springframework.stereotype.Controller;
        import org.springframework.ui.Model;
        import org.springframework.web.bind.annotation.RequestMapping;
        
        import com.lyt.model.User;
        import com.lyt.service.UserService;
        
        @Controller
        @RequestMapping("/user")
        public class UserController {
            @Autowired
            private UserService userService;
            /**
             * 获取所有用户列表
             * @param request
             * @return
             */
            @RequestMapping("/getAllUser")
            public String getAllUser(HttpServletRequest request,Model model){
                List<User> user = userService.findAll();
                model.addAttribute("userList", user);
                request.setAttribute("userList", user);
                return "/allUser";
            }
            /**
             * 跳转到添加用户界面
             * @param request
             * @return
             */
            @RequestMapping("/toAddUser")
            public String toAddUser(){
                return "/addUser";
            }
            /**
             * 添加用户并重定向
             * @param user
             * @param request
             * @return
             */
            @RequestMapping("/addUser")
            public String addUser(User user,Model model){
                userService.save(user);
                return "redirect:/user/getAllUser";
            }
            /**
             *编辑用户
             * @param user
             * @param request
             * @return
             */
            @RequestMapping("/updateUser")
            public String updateUser(User user,HttpServletRequest request,Model model){
                if(userService.update(user)){
                    user = userService.findById(user.getId());
                    request.setAttribute("user", user);
                    model.addAttribute("user", user);
                    return "redirect:/user/getAllUser";
                }else{
                    return "/error";
                }
            }
            /**
             * 根据id查询单个用户
             * @param id
             * @param request
             * @return
             */
            @RequestMapping("/getUser")
            public String getUser(int id,HttpServletRequest request,Model model){
                request.setAttribute("user", userService.findById(id));
                model.addAttribute("user", userService.findById(id));
                return "/editUser";
            }
            /**
             * 删除用户
             * @param id
             * @param request
             * @param response
             */
            @RequestMapping("/delUser")
            public void delUser(int id,HttpServletRequest request,HttpServletResponse response){
                String result = "{\"result\":\"error\"}";
                if(userService.delete(id)){
                    result = "{\"result\":\"success\"}";
                }
                response.setContentType("application/json");
                try {
                    PrintWriter out = response.getWriter();
                    out.write(result);
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        </span>
        
        至此大部分架构以及代码已经搭建完成
        我们来做前台页面--修改index.jsp
        
        [python] view plain copy
        
        <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
        <%
            String path = request.getContextPath();
            String basePath = request.getScheme() + "://"
                    + request.getServerName() + ":" + request.getServerPort()
                    + path + "/";
        %>
        
        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
        <html>
        <head>
        <base href="<%=basePath%>">
        <title>首页</title>
        </head>
        <body>
            <h5>
                <a href="<%=basePath%>user/getAllUser">进入用户管理页</a>
            </h5>
        </body>
        </html>
        
        在 WEB-INF 下新建jsp文件夹【里面新建以下文件】【addUser.jsp】【allUser.jsp】【editUser.jsp】
        
        addUser.jsp内容
        
        [python] view plain copy
        
        <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
        <%
        String path = request.getContextPath();
        String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
        %>
        <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
        <html>
          <head>
            <base href="<%=basePath%>">
        
            <title>添加用户</title>
        
            <script type="text/javascript">
            function addUser(){
                var form = document.forms[0];
                form.action = "<%=basePath%>user/addUser";
                form.method="post";
                form.submit();
            }
        </script>
        
          </head>
        
          <body>
            <h1><%=path%>添加用户<%=basePath%></h1>
            <form action="" name="userForm">
                姓名：<input type="text" name="userName">
                年龄：<input type="text" name="age">
                <input type="button" value="添加" onclick="addUser()">
            </form>
          </body>
        </html>
        
        allUser.jsp
        
        [python] view plain copy
        
        <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
        <%
        String path = request.getContextPath();
        String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
        %>
        <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
        <html>
          <head>
            <base href="<%=basePath%>">
            <script type="text/javascript" src='/images/loading.gif' data-original="js/jquery-1.7.1.js"></script>
            <title>用户列表</title>
        
            <script type="text/javascript">
            function del(id){
                $.get("<%=basePath%>user/delUser?id=" + id,function(data){
                    if("success" == data.result){
                        alert("删除成功");
                        window.location.reload();
                    }else{
                        alert("删除失败");
                    }
                });
            }
        </script>
          </head>
        
          <body>
            <h6><a href="<%=basePath%>user/toAddUser">添加用户</a></h6>
            <table border="1">
                <tbody>
                    <tr>
                        <th>姓名</th>
                        <th>年龄</th>
                        <th>操作</th>
                    </tr>
                    <c:if test="${!empty userList }">
                        <c:forEach items="${userList}" var="user">
                            <tr>
                                <td>${user.userName }</td>
                                <td>${user.age }</td>
                                <td>
                                    <a href="<%=basePath%>user/getUser?id=${user.id}">编辑</a>
                                    <a href="javascript:del('${user.id }')">删除</a>
                                </td>
                            </tr>
                        </c:forEach>
                    </c:if>
                </tbody>
            </table>
          </body>
        </html>
        
        editUser.jsp
        
        [python] view plain copy
        
        <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
        <%
        String path = request.getContextPath();
        String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
        %>
        <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
        <html>
          <head>
            <base href="<%=basePath%>">
        
            <title>编辑用户</title>
        
            <script type="text/javascript">
            function updateUser(){
                var form = document.forms[0];
                form.action = "<%=basePath%>user/updateUser";
                form.method="post";
                form.submit();
            }
        </script>
        
          </head>
        
          <body>
            <h1>添加用户</h1>
            <form action="" name="userForm">
                <input type="hidden" name="id" value="${user.id }"/>
                姓名：<input type="text" name="userName" value="${user.userName }"/>
                年龄：<input type="text" name="age" value="${user.age }"/>
                <input type="button" value="编辑" onclick="updateUser()"/>
            </form>
          </body>
        
        </html>
        
        到此简单的整合SSM 【基本的操作内容已经完成】
        
        让你们看下界面运行，地址：http://localhost:8088/SpringMVC_Spring_mybatis/
        首页：
        点击编辑进去：
        点击添加进去：
        由于我在网络问题图片暂时没有上传上去。【现在我吧图片都正上去了，希望多多支持】
        对应的数据库表
        [python] view plain copy
        
        /*
        Navicat MySQL Data Transfer
        
        Source Server         : localhost
        Source Server Version : 50515
        Source Host           : localhost:3306
        Source Database       : db_zsl
        
        Target Server Type    : MYSQL
        Target Server Version : 50515
        File Encoding         : 65001
        
        Date: 2016-05-16 16:10:51
        */
        
        SET FOREIGN_KEY_CHECKS=0;
        -- ----------------------------
        -- Table structure for `t_user`
        -- ----------------------------
        DROP TABLE IF EXISTS `t_user`;
        CREATE TABLE `t_user` (
          `user_id` int(11) NOT NULL AUTO_INCREMENT,
          `user_name` varchar(20) NOT NULL,
          `user_age` varchar(20) NOT NULL,
          PRIMARY KEY (`user_id`)
        ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
        
        -- ----------------------------
        -- Records of t_user
        -- ----------------------------
        INSERT INTO `t_user` VALUES ('2', '朱佳鹏', '25');
        INSERT INTO `t_user` VALUES ('3', '傻狍子', '150');
        INSERT INTO `t_user` VALUES ('4', 'jiuqiyuliang', '23');
        INSERT INTO `t_user` VALUES ('5', 'jiuqiyuliang', '23');
        INSERT INTO `t_user` VALUES ('6', 'jiuqiyuliang', '23');
        INSERT INTO `t_user` VALUES ('7', 'jiuqiyuliang', '23');
        INSERT INTO `t_user` VALUES ('9', 'liyintao123', '23123');
        
        -- ----------------------------
        -- Table structure for `user_t`
        -- ----------------------------
        DROP TABLE IF EXISTS `user_t`;
        CREATE TABLE `user_t` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `user_name` varchar(40) NOT NULL,
          `password` varchar(255) NOT NULL,
          `age` int(4) NOT NULL,
          PRIMARY KEY (`id`)
        ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
        
        -- ----------------------------
        -- Records of user_t
        -- ----------------------------
        INSERT INTO `user_t` VALUES ('1', '测试', 'sfasgfaf', '24');

原标题：Springmvc+Spring+Mybatis+Maven简单的增删改查

关键词：Spring

Spring

*特别声明：以上内容来自于网络收集，著作权属原作者所有，如有侵权，请联系我们： admin#shaoqun.com （#换成@）。

连续7天0单！亚马逊这个站点卖家集体翻车，原因竟是……：https://www.ikjzd.com/articles/135601
黑五战绩出炉：有卖家狂爆7000单，直冲大类第一！但这还不是最牛的…：https://www.ikjzd.com/articles/135602
亚马逊印度站卖家或连续7天0订单！美国疫情致CA货班全部取消！亚马逊仓库工人再次罢工。。：https://www.ikjzd.com/articles/135603
揭秘！超级大卖内部管理都开发了哪些强大的系统：https://www.ikjzd.com/articles/135604
亚马逊测评为什么利润那么可观，是怎么做的：https://www.ikjzd.com/articles/135607
速卖通物流方案有哪些？史上最全的物流方案介绍：https://www.ikjzd.com/articles/135608
石象湖景区门票-石象湖景区门票优惠政策：https://www.vstour.cn/a/411243.html
北京到嵩山自驾游沿途景点北京距离嵩山有多远：https://www.vstour.cn/a/411244.html