SpringMVC整合

数据库结构

导入依赖

    4.0.0

    org.example
    ssmbuild
    1.0-SNAPSHOT

     
        
        
            junit
            junit
            4.12
        
        
        
            mysql
            mysql-connector-java
            5.1.47
        
        
        
            com.mchange
            c3p0
            0.9.5.2
        

        
        
            javax.servlet
            servlet-api
            2.5
        
        
            javax.servlet.jsp
            jsp-api
            2.2
        
        
            javax.servlet
            jstl
            1.2
        

        
        
            org.mybatis
            mybatis
            3.5.2
        
        
            org.mybatis
            mybatis-spring
            2.0.2
        

        
        
            org.springframework
            spring-webmvc
            5.1.9.RELEASE
        
        
            org.springframework
            spring-jdbc
            5.1.9.RELEASE
        

         
             com.fasterxml.jackson.core
             jackson-core
             2.12.4
         
         
             com.fasterxml.jackson.core
             jackson-databind
             2.12.4
         
         
             com.fasterxml.jackson.core
             jackson-annotations
             2.12.4
         
          

    
        
            
                src/main/java
                
                    ***.xml
                
                false
            
            
                src/main/resources
                
                    ***.xml
                
                false
            
        
    

Mevan资源过滤问题

   
       
           src/main/java
           
               ***.xml
           
           false
       
       
           src/main/resources
           
               ***.xml
           
           false
       
   

链接数据库Datebase

创建 dao controller pojo service 包

resources 创建mybatis-config.xml applicationContext.xml database.propeties

mybatis-config.xml

applicationContet.xml

配置数据库连接 database.propeties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root

在mybatis-config里面配置数据源

创建实体类 定义跟数据库一样 pojo/User

创建接口 dao/UserMapper 里面实现增删改查

package com.zhang.dao;

import com.zhang.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserMapper {
    //登录
    int loginUser(@Param("username") String username,@Param("password") String password);
    //增加一本书
    int addUser(User user);
    //删除一本书
    int deleteUser(@Param("id") int id);
    //修改一本书
     int updateUser(User user);
    //根据id查询一本书
    User queryUserById(@Param("id")int id);
    //查询所有书
    List queryAllUser();
}

创建UserMapper.xml

    
    
        select * from User where username=#{username} and password=#{password}
    


    insert into User (username,password,usertype) values
    (#{username},#{password},#{usertype});



    delete from User where id=#{id}



    update USer set username=#{username},password=#{password},usertype=#{usertype}
    where id=#{id} ;


    
        select * from User where id=#{id}
    

    
        select * from User ;
    

创建接口UserService  service/UserService

public interface UserService {
    //查询
    int loginUser(String username, String password);
    //增加一本书
    int addUser(User user);
    //删除一本书
    int deleteUser(int id);
    //修改一本书
    int updateUser(User user);
    //根据id查询一本书
    User queryUserById(int id);
    //查询所有书
    List queryAllUser();
}

创建 UserServiceImpl

public class UserServiceImpl implements UserService{
    private UserMapper userMapper;
    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }
//登录
    public int loginUser(String username, String password) {
        return userMapper.loginUser(username,password);
    }

    //增加一本书
    public int addUser(User user) {
        return userMapper.addUser(user);
    }

    //删除一本书
    public int deleteUser(int id) {
        return userMapper.deleteUser(id);
    }

    //修改一本书
    public int updateUser(User user) {
        return userMapper.updateUser(user);
    }

    //根据id查询一本书
    public User queryUserById(int id) {
        return userMapper.queryUserById(id);
    }

    //查询所有书
    public List queryAllUser() {
        return userMapper.queryAllUser();
    }

}

开始整合spring

创建spring-dao.xml 弹出警告直接添加就好

创建 spring-service.xml

    
    
        
            
                
            
            
                
                    
                        
                    
                
            
        
    


.xml
  
             com.fasterxml.jackson.core
             jackson-core
             2.12.4
         
         
             com.fasterxml.jackson.core
             jackson-databind
             2.12.4
         
         
             com.fasterxml.jackson.core
             jackson-annotations
             2.12.4
         

添加 WEB模块 创建 lib导包

web.xml 配置

    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:applicayionContext.xml
        
        
        1
    
    
        springmvc
        /
    


    
        encodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    
    
        encodingFilter
        /*
    

    
        15
    

创建spring-mvc.xml

创建类UserController

package com.zhang.controller;

import com.zhang.pojo.User;
import com.zhang.service.UserService;
import org.apache.ibatis.annotations.Param;
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.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpSession;
import java.util.List;

@Controller
@RequestMapping("/user")
public class UserController {
    //controller调用service层
    @Autowired
    //这是service.xml的name
    @Qualifier("UserServiceImpl")
    private UserService userService;

    public void setUserService(UserService userService) {
        this.userService = userService;
    }
    //查询
    @RequestMapping("/allUser")
    public String allUser(Model model){
        List users = userService.queryAllUser();
        model.addAttribute("users",users);
        return "listUser";
    }
    //跳转
    @RequestMapping("/toAddUser")
    public String toAddUser(){
        return "addUser";
    }
    //增加
    @RequestMapping("/addUser")
    public String addUser(User user){
        userService.addUser(user);
        System.out.println("user+++++"+user);
        return "redirect:/user/allUser";
    }
    //修改跳转
    @RequestMapping("/toUpdateUser")
    public String toUpdateUser(Model model,int id){
        User users = userService.queryUserById(id);
        model.addAttribute("user",users);
        return "updateUser";
    }
    //修改
    @RequestMapping("/updateUser")
    public String updateUser(Model model,User user){
        userService.updateUser(user);
        User users = userService.queryUserById(user.getId());
        model.addAttribute("users",users);
        System.out.println("user+++++"+user);
        return "redirect:/user/allUser";
    }
    //删除
    @RequestMapping("deleteUser/{id}")
    public String deleteUser(@PathVariable("id") int id){
        userService.deleteUser(id);
        return "redirect:/user/allUser";
    }
    //登录
    @RequestMapping("/loginUser")
    public String loginUser(HttpSession session, String username, String password){
        int sc=-1;
        sc = userService.loginUser(username, password);
        System.out.println(username);
        session.setAttribute("userLoginInfo",username);
        if (sc!=-1){
            return "redirect:/user/allUser";
        }
        return "redirect:/";
//        String msg = "";
//        if (username != null) {
//            if ("admin".equals(username)) {
//                msg = "ok";
//            } else {
//                msg = "用户名有误";
//            }
//        }
//
//        if (password != null) {
//            if ("123456".equals(password)) {
//                msg = "ok";
//            } else {
//                msg = "密码有误";
//            }
//        }
//        return msg;
    }

    @RequestMapping("/goOut")
    public String goOut(HttpSession sessionl) {
        sessionl.removeAttribute("userLoginInfo");
        return "redirect:/";
    }
}

登陆页面 idnex.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

  
    
  

  
  

    账户:


    密码:


    
    
  
  

l列表页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    
    
    





    
        
            
                
                    书籍列表 —— 显示所有书籍
                
            
        
    

    
        
            新增
        
        注销
    

    
        
            
                    

                

                

                    
用户编号
                    
用户名字
                    
用户密码
                    
用户权限
                    
操作
                
                

                

                

                        
${user.getId()}
                        
${user.getUsername()}
                        
${user.getPassword()}
                        
${user.getUsertype()}
                        

                            更改 |
                            删除
                        
                    
                
                
            
        
    

新增页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>



    
    
    
    




    
        
            
                
                    新增用户
                
            
        
    
    

        用户名称：



        用户密码：



        用户权限：



        
    

更新页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>



    
    
    
    




    
        
            
                
                    修改用户
                
            
        
    
    

        
        用户名称：



        用户密码：



        用户权限：