Spring MVC 框架整合 MyBatis 框架实例

- 日理万妓 2022-06-17 20:39 197阅读 0赞

代码：

1.配置文件

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" 
    	xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
    	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"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	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.2.xsd
    			            http://www.springframework.org/schema/context
    			            http://www.springframework.org/schema/context/spring-context-4.2.xsd
    			            http://www.springframework.org/schema/mvc
    			            http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
    			            http://www.springframework.org/schema/tx
    			            http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
    			            http://mybatis.org/schema/mybatis-spring 
    			            http://mybatis.org/schema/mybatis-spring.xsd ">
    			      
    	   
        <mybatis:scan base-package="com.mapper"/>   
           
    	 
        <context:component-scan base-package="com"/>
        
    	
    	<context:property-override location="classpath:db.properties"/>
    
    	
    	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"/>
    	
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"
    	    p:dataSource-ref="dataSource"/>
    	
    	
    	<bean id="transactionManager" 
    	class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
    		 p:dataSource-ref="dataSource"/>
    	
    	
    	<tx:annotation-driven transaction-manager="transactionManager"/>
    	
    </beans>

SpringMVC-config.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"
        xsi:schemaLocation="
            http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
            http://www.springframework.org/schema/mvc
            http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd     
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-4.2.xsd">
            
        
        <context:component-scan base-package="com.controller"/>
        
        <mvc:annotation-driven/>
         
        <mvc:default-servlet-handler/>
        
         <bean id="viewResolver"
              class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
            
            <property name="prefix">
                <value>/WEB-INF/content/</value>
            </property>
            
            <property name="suffix">
                <value>.jsp</value>
            </property>
        </bean>
        
    </beans>

db.properties

dataSource.driverClass=com.mysql.jdbc.Driver
    dataSource.jdbcUrl=jdbc:mysql://localhost:3306/mybatis
    dataSource.user=root
    dataSource.password=123456
    dataSource.maxPoolSize=200
    dataSource.maxIdleTime = 1000
    dataSource.minPoolSize=6
    dataSource.initialPoolSize=5

2.前端页面

loginForm.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>登录页面</title>
    </head>
    <body>
    <h3>登录页面</h3>
    <form action="login" method="post">
    	<font color="red">${requestScope.message }</font>
         <table>
             <tr>
             	<td><label>登录名: </label></td>
                 <td><input type="text" id="loginname" name="loginname" ></td>
             </tr>
             <tr>
             	<td><label>密码: </label></td>
                 <td><input type="password" id="password" name="password" ></td>
             </tr>
             <tr>
                 <td><input type="submit" value="登录"></td>
             </tr>
         </table>
    </form>
    </body>
    </html>

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>首页</title>
    <style type="text/css">
    	table{border-collapse:collapse;border-spacing:0;border-left:1px solid #888;border-top:1px solid #888;background:#efefef;}
    	th,td{border-right:1px solid #888;border-bottom:1px solid #888;padding:5px 15px;}
    	th{font-weight:bold;background:#ccc;}
    </style>
    </head>
    <body>
    欢迎[${sessionScope.user.username }]访问
    <br>
    <table border="1">
    	<tr>
    		<th>封面</th><th>书名</th><th>作者</th><th>价格</th>
    	</tr>
    	<c:forEach items="${requestScope.book_list }" var="book">
    		<tr>
    			<td><img src="images/${book.image }" height="60"></td>
    			<td>${book.name }</td>
    			<td>${book.author }</td>
    			<td>${book.price }</td>
    		</tr>
    	</c:forEach>
    </table>
    </body>
    </html>

3.后端逻辑

Book.java

package com.bean;
    
    import java.io.Serializable;
    import java.util.Date;
    
    public class Book implements Serializable {
    	private Integer id;				// id	
    	private String name;			// 书名
    	private String author;			// 作者
    	private String publication;		// 出版社
    	private Date publicationdate;	// 出版日期
    	private Double price;			// 价格
    	private String image;			// 封面图片
    	private String remark;			// 详细描述
    	public Book() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    	public Integer getId() {
    		return id;
    	}
    	public void setId(Integer id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getAuthor() {
    		return author;
    	}
    	public void setAuthor(String author) {
    		this.author = author;
    	}
    	public String getPublication() {
    		return publication;
    	}
    	public void setPublication(String publication) {
    		this.publication = publication;
    	}
    	public Date getPublicationdate() {
    		return publicationdate;
    	}
    	public void setPublicationdate(Date publicationdate) {
    		this.publicationdate = publicationdate;
    	}
    	public Double getPrice() {
    		return price;
    	}
    	public void setPrice(Double price) {
    		this.price = price;
    	}
    	public String getImage() {
    		return image;
    	}
    	public void setImage(String image) {
    		this.image = image;
    	}
    	public String getRemark() {
    		return remark;
    	}
    	public void setRemark(String remark) {
    		this.remark = remark;
    	}
    	@Override
    	public String toString() {
    		// TODO Auto-generated method stub
    		return "Book [id=" + id + ", name=" + name + ", author=" + author + ", publication=" + publication + ", publicationdate="
    				+ publicationdate + ", price=" + price + ", image=" + image
    				+ ", remark=" + remark + "]";
    	}
    	
    	
    }

User.java

package com.bean;
    
    import java.io.Serializable;
    
    public class User implements Serializable {
    	private Integer id;			// id
    	private String loginname;	// 登录名
    	private String password;	// 密码
    	private String username;	// 用户名
    	private String phone;		// 电话
    	private String address;		// 地址
    	public User() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    	public Integer getId() {
    		return id;
    	}
    	public void setId(Integer id) {
    		this.id = id;
    	}
    	public String getLoginname() {
    		return loginname;
    	}
    	public void setLoginname(String loginname) {
    		this.loginname = loginname;
    	}
    	public String getPassword() {
    		return password;
    	}
    	public void setPassword(String password) {
    		this.password = password;
    	}
    	public String getUsername() {
    		return username;
    	}
    	public void setUsername(String username) {
    		this.username = username;
    	}
    	public String getPhone() {
    		return phone;
    	}
    	public void setPhone(String phone) {
    		this.phone = phone;
    	}
    	public String getAddress() {
    		return address;
    	}
    	public void setAddress(String address) {
    		this.address = address;
    	}
    	@Override
    	public String toString() {
    		// TODO Auto-generated method stub
    		return "User [id=" + id + ", loginname=" + loginname + ", password=" + password + ", username=" + username + ", phone=" + phone
    		+ ", address=" + address + "]";
    	}
    	
    }

BookMapper.java

package com.mapper;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Select;
    
    import com.bean.Book;
    
    public interface BookMapper {
        /*
         *查询所有图书 
         */
    	@Select("select * from tb_book")
    	List<Book> findAll();
    }

UserMapper.java

package com.mapper;
    
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    
    import com.bean.User;
    
    public interface UserMapper {
         /*
          * 根据登录名和密码查询用户
          */
    	@Select("select * from tb_user where loginname = #{loginname} and password = #{password}")
    	User findWithLoginnameAndPassword(@Param("loginname") String loginname,@Param("password") String password);
    }

UserService.java(接口)

package com.service;
    
    import com.bean.User;
    
    public interface UserService {
         /*
          * 判断用户登录
          */
    	User login(String loginname,String password);
    }

BookService.java

package com.service;
    
    import java.util.List;
    
    import com.bean.Book;
    
    public interface BookService {
          /*
           * 查询所有图书
           */
    	List<Book> getAll();
    }

UserServiceImpl.java

package com.service.impl;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import com.bean.User;
    import com.mapper.UserMapper;
    import com.service.UserService;
    /*
     * User服务层接口实现类
     * @Service("userService")用于将当前类注释为一个Spring的bean，名为userService
     * 
     */
    
    @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)
    @Service("userService")
    public class UserServiceImpl implements UserService {
        /*
         * 自动注入UserMapper
         */
    	@Autowired
    	private UserMapper userMapper;
    	
    	/*
    	 * UserService接口login方法实现
    	 */
    	@Transactional(readOnly=true)
    	
    	public User login(String loginname, String password) {
    		// TODO Auto-generated method stub
    		return userMapper.findWithLoginnameAndPassword(loginname, password);
    	}
    
    }

BookServiceImpl.java

package com.service.impl;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import com.bean.Book;
    import com.mapper.BookMapper;
    import com.service.BookService;
    /*
     * Book服务层接口实现类
     * @Service("bookService")用于将当前类注释为一个Spring的bean，名为bookService
     */
    @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)
    @Service("bookService")
    public class BookServiceImpl implements BookService {
        @Autowired
        private BookMapper bookMapper;
    
    	//BookService接口getAll方法实现
    	public List<Book> getAll() {
    		// TODO Auto-generated method stub
    		return bookMapper.findAll();
    	}
    
    }

BookController.java

package com.controller;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import com.bean.Book;
    import com.service.BookService;
    
    /*
     * 处理图书请求控制器
     */
    
    @Controller
    public class BookController {
         /*
          * 自动注入BookService
          */
    	@Autowired
    	@Qualifier("bookService")
    	private BookService bookService;
    	
    	/*
    	 * 处理main请求
    	 */
    	@RequestMapping(value="/main")
    	public String main(Model model){
    		//获取所有图书请求
    		List<Book> book_list = bookService.getAll();
    		//将图书集合添加到model当中
    		model.addAttribute("book_list", book_list);
    		//转到main页面
    		return "main";
    	}
    }

FormController.java

package com.controller;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    /*
     * 动态页面跳转控制器
     */
    
    @Controller
    public class FormController {
          @RequestMapping(value="/{formName}")
          public String loginForm(@PathVariable String formName){
        	// 动态跳转页面
      		return formName;
          }
    }

UserController.java

package com.controller;
    
    import javax.servlet.http.HttpSession;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.portlet.bind.annotation.RenderMapping;
    import org.springframework.web.servlet.ModelAndView;
    import org.springframework.web.servlet.view.RedirectView;
    
    import com.bean.User;
    import com.service.UserService;
    
    /*
     * 处理用户请求控制器
     */
    
    @Controller
    public class UserController {
           /*
            * 自动注入UserService
            */
    	@Autowired
    	@Qualifier("userService")
    	private UserService userService;
    	
    	/*
    	 * 处理login请求
    	 */
    	@RequestMapping(value="/login")
    	public ModelAndView login(String loginname,String password,ModelAndView mv,HttpSession session){
    		//根据登录名和密码查找用户，判断用户登录
    		User user = userService.login(loginname, password);
    		if(user!=null){
    			// 登录成功，将user对象设置到HttpSession作用范围域
    			session.setAttribute("user", user);
    			//转发到main请求
    			mv.setView(new RedirectView("/fkbookapp/main"));
    		}
    		else{
    			// 登录失败，设置失败提示信息，并跳转到登录页面
    			mv.addObject("message", "登录名或密码错误，请重新输入!");
    			mv.setViewName("loginForm");
    		}
    		return mv;
    	}
    	
    }

4.截图

![Center][]

![Center 1][]

[Center]: /images/20220618/4ef858481d1e4a44bb467fee9f906d07.png
[Center 1]: /images/20220618/555f032eed4940daab338790c095976c.png