springboot mybatis xml版

1.添加相关maven文件

org.mybatis.spring.bootmybatis-spring-boot-starter2.0.0mysqlmysql-connector-javaorg.springframework.bootspring-boot-starter-testtestorg.springframework.bootspring-boot-starter-web

2.pom 中build  这个resources 需要加一下 不然idea 启动项目的时候不会将mapp.xml文件打进去 

org.springframework.bootspring-boot-maven-plugin${basedir}/src/main/java**/*.properties**/*.xmlfalse${basedir}/src/main/resources**/*.properties**/*.xmlfalse

3.application.properties添加相关配置

#mysql
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/jiyu?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&serverTimezone=UTC
#这个serverTimezone=UTC 解决时区问题
spring.datasource.username = root
spring.datasource.password = 123456
#mybatis
mybatis.config-location=classpath:conf/mybatis-config.xml
mybatis.mapper-locations=classpath*:cn/mufeng/dal/*.mapper.xml#指定了mybatis基础配置文件和实体类映射文件的地址
#下面的是mybatis-config.xml 配置

4.在启动类中添加对mapper包扫描@MapperScan

@SpringBootApplication
@MapperScan("cn.mufeng.dal")
public class SpringBootMybatisXmlApplication {public static void main(String[] args) {SpringApplication.run(SpringBootMybatisXmlApplication.class, args);}}

5.建一个实体类

public class VideoEntity implements Serializable {private static final long serialVersionUID = 1L;private String id;private String videoName;private String videoUrl;public VideoEntity() {super();}public VideoEntity(String videoName, String videoUrl) {super();this.videoUrl = videoUrl;this.videoName = videoName;}public String getId() {return id;}public void setId(String id) {this.id = id;}public String getVideoName() {return videoName;}public void setVideoName(String videoName) {this.videoName = videoName;}public String getVideoUrl() {return videoUrl;}public void setVideoUrl(String videoUrl) {this.videoUrl = videoUrl;}@Overridepublic String toString() {// TODO Auto-generated method stubreturn "videoName " + this.videoName + ", videoUrl " + this.videoUrl ;}}

6.建一个mapper 接口 （dal层）

public interface VideoMapper {List getAll();VideoEntity getOne(Long id);void insert(VideoEntity video);void update(VideoEntity video);void delete(Long id);}

7.建一个xml（添加VideoMapper 的映射文件） 注意 这个引用  

id, videoName, videoUrlSELECTFROM videoSELECTFROM videoWHERE id = #{id}select uuid()insert into video(id, videoName, videoUrl)values(#{id},#{videoName},#{videoUrl})UPDATEvideoSETuserName = #{videoName},passWord = #{videoUrl}WHEREid = #{id}DELETE FROMvideo WHERE id = #{id}

8.新加一个Controller

@RestController
public class VideoController {@Autowiredprivate VideoMapper videoMapper;@RequestMapping("/getVideos")public List getVideos() {List videos = videoMapper.getAll();return videos;}@RequestMapping("/getVideo/{id}")public VideoEntity getVideo(@PathVariable("id") Long id) {VideoEntity video = videoMapper.getOne(id);return video;}@RequestMapping("/add")public void save(VideoEntity video) {videoMapper.insert(video);}@RequestMapping(value = "update")public void update(VideoEntity video) {videoMapper.update(video);}@RequestMapping(value = "/delete/{id}")public void delete(@PathVariable("id") Long id) {videoMapper.delete(id);}}

9.我的sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video`  (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `videoName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `videoUrl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of video
-- ----------------------------
INSERT INTO `video` VALUES ('1', '测试url', 'https://cloud.video.taobao.com/play/u/2577498496/p/1/e/6/t/1/50016620184.mp4');

SET FOREIGN_KEY_CHECKS = 1;
10.启动项目访问url

http://localhost:8080/getVideos

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！