栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

SSM整合

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

SSM整合

SSM整合 1.在数据库中创建表,并导入数据

sql语句

CREATE DATABASE wyy_music;

USE wyy_music;

DROp TABLE IF EXISTS `tb_music`;
CREATE TABLE `tb_music` (
  `music_id` int(11) NOT NULL AUTO_INCREMENT, -- 歌曲ID
  `music_name` VARCHAr(255) NOT NULL, -- 歌曲名称
  `music_album_name` VARCHAr(255) NOT NULL, -- 专辑名称
  `music_album_picUrl` VARCHAr(255) NOT NULL, -- 专辑图片路径
  `music_mp3Url` VARCHAr(255) NOT NULL, -- 歌曲播放路径
  `music_artist_name` VARCHAr(255) NOT NULL, -- 歌手名称
  `sheet_id` int(11) DEFAULT NULL, -- 对应的歌单ID
  PRIMARY KEY (`music_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO tb_music VALUES ('1', '光年之外', '光年之外', '//y.qq.com/music/photo_new/T002R300x300M000001mTkmb4GJlh4_1.jpg?max_age=2592000', 'http://dl.stream.qqmusic.qq.com/C4000029Lt3K2XVP75.m4a?guid=9466964098&vkey=C4E6AB1F9F5A140F233BF1BD4E9E1C96DD52547C82F8BF8101037E1A9F212DC861099D1F615117A7821AD26EC1DEC598F0D94A77D6E35683&uin=729953102&fromtag=66', 'G.E.M.邓紫棋','1');
INSERT INTO tb_music VALUES ('2', '夜空中最亮的星', '世界', '//y.qq.com/music/photo_new/T001R300x300M000001Yxpxc0OaUUX.jpg?max_age=2592000', 'http://dl.stream.qqmusic.qq.com/C400002EHg2B2FPi71.m4a?guid=5359545528&vkey=38B7183C0E0D20D7AC35460A6C5446CB7A926254BD1E35898CB096D6381FB4B15B001C00EE34308E0549718E29601433C9FE4DD85960F7C2&uin=729953102&fromtag=66', '逃跑计划','1');
INSERT INTO tb_music VALUES ('3', '只要平凡', '只要平凡', '//y.qq.com/music/photo_new/T002R300x300M000000K7srf1rZtOX_1.jpg?max_age=2592000', 'http://dl.stream.qqmusic.qq.com/C400004BwbUM0vWzAt.m4a?guid=4198275520&vkey=F846EA79763CE8C226A77FF6EE3077B9D7A71A5A333A8ED1233EA5DB13AEC831E3E83D42172C8231E32EE9EF09E7AE0A746D16B3925CC317&uin=729953102&fromtag=66', '张杰/张碧晨','2');

DROp TABLE IF EXISTS `tb_sheet`;
CREATE TABLE `tb_sheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sheet_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO tb_sheet VALUES ('1', '热歌榜');
INSERT INTO tb_sheet VALUES ('2', '新歌榜');
INSERT INTO tb_sheet VALUES ('3', '原创榜');
2.创建web工程,导入依赖


    
    
        org.springframework
        spring-webmvc
        5.3.20
    

    
        org.springframework
        spring-jdbc
        5.3.20
    

    
        org.aspectj
        aspectjweaver
        1.9.9.1
    

    
        org.springframework
        spring-tx
        5.3.20
    

    
    
        org.mybatis
        mybatis
        3.5.9
    

    
        org.mybatis
        mybatis-spring
        2.0.7
    

    
        mysql
        mysql-connector-java
        8.0.29
    

    
        com.alibaba
        druid
        1.2.9
    

    
        org.projectlombok
        lombok
        1.18.24
    

    
    
        javax.servlet
        javax.servlet-api
        4.0.1
    

    
    
        com.fasterxml.jackson.core
        jackson-databind
        2.13.3
    

    
    
        com.github.pagehelper
        pagehelper
        5.3.0
    

    
    
        log4j
        log4j
        1.2.17
    


3.配置相关properties文件 3.1关联数据库db.properties
db.username = root
db.password = 123456
db.url = jdbc:mysql:///wyy_music?serverTimezone=Asia/Shanghai&characterEncoding=UTF8
db.driverClassName = com.mysql.cj.jdbc.Driver
3.2日志log4j.properties
# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
4.配置web.xml

  Archetype Created Web Application

  
  
    contextConfigLocation
    classpath:applicationContext.xml
  

  
  
    org.springframework.web.context.ContextLoaderListener
  

  
  
    dispatcherServlet
    org.springframework.web.servlet.DispatcherServlet
    
    
    
      contextConfigLocation
      classpath:springmvc.xml
    
    
  

  
    dispatcherServlet
    /
  


5.编写 applicationContext.xml

 


    
    

    
    
        
        
        
        
        
    

    
    

    
    
        
        
        
        
        
        
        package com.couture.mapper;

import com.couture.pojo.Music;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MusicMapper {

    
    public List findAll();
    
}
10.编写Mapper.xml文件

MusicMapper.xml配置文件( 注意:存放位置和applicationContext.xml中设置的对应上 )






    
        
        
        
        
        
        
        
    
    
    
    
        select music_id,
               music_name,
               music_album_name,
               music_album_picUrl,
               music_mp3Url,
               music_artist_name,
               sheet_id
        from tb_music
    

    
    
    

11.编写 Service

MusicService接口

package com.couture.service;

import com.couture.pojo.Music;

import java.util.List;

public interface MusicService {

    
    public List findAll();
}
12.编写ServiceImpl

MusicServiceImpl实现类

package com.couture.service.impl;

import com.couturecouture.mapper.MusicMapper;
import com.couture.pojo.Music;
import com.couture.service.MusicService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class MusicServiceImpl implements MusicService {

    @Autowired
    private MusicMapper musicMapper;

    
    @Override
    public List findAll() {
        return musicMapper.findAll();
    }
}
13.编写Controller

MusicController

package com.couture.controller;

import com.couture.pojo.Music;
import com.couture.service.MusicService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("music")
public class MusicController {
    
    @Autowired
    private MusicService musicService;

    
    @RequestMapping("findAll")
    public List findAll(){
        return musicService.findAll();
    }
}
14.测试

访问:localhost:8080/music/findAll 进行测试

添加分页操作 1.导入依赖(之前已经导入过了)

    com.github.pagehelper
    pagehelper
    5.1.11

2.配置分页插件(两种方式) 2.1 第一种:在 applicationContext.xml 中添加配置
        
        
            
            
            
            
            

            

            
            
            
                
                    
                        
                            
                            
                                helperDialect=mysql
                                reasonable=true
                                supportMethodsArguments=true
                            
                        
                    
                
            

        
2.2 第二种:在 mybatis-config.xml 中添加配置





    
        
        
        
    



3.在 controller 中添加方法
@RequestMapping("findByPage")
public PageInfo findByPage(
    @RequestParam(value = "pageNum",required = false,defaultValue = "1") Integer pageNum,
    @RequestParam(value = "pageSize",required = false,defaultValue = "2") Integer pageSize){

        PageHelper.startPage(pageNum,pageSize);
        List musicList = musicService.findAll();

        PageInfo musicPageInfo = new PageInfo<>(musicList);

        return musicPageInfo;
    }
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/978435.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号