12306网站建设团队,建设网站要做的工作,和男朋友都是第一次做网站,window2008r2网站建设在这里之前我想童鞋们都学习过了springmvc。mybatis-plus。Springboot等一些框架
那么下面我们就整合这些框架
我们通过写crud这些接口
写接口的第一步就是引入pom文件 在pom文件里引入一下几种依赖
引入父级工程 thymeleaf导入模版工具类 SpringMVCjar包文件 热部署工具 l…在这里之前我想童鞋们都学习过了springmvc。mybatis-plus。Springboot等一些框架
那么下面我们就整合这些框架
我们通过写crud这些接口
写接口的第一步就是引入pom文件 在pom文件里引入一下几种依赖
引入父级工程 thymeleaf导入模版工具类 SpringMVCjar包文件 热部署工具 lombok插件 测试包 引入jdbc包 引入数据库驱动 spring整合mybatis-plus 负责项目打包部署
?xml version1.0 encodingUTF-8?
project xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersion!--引入父级工程--parentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion2.4.5/versionrelativePath//parentartifactIdjiekou/artifactIdversion1.0-SNAPSHOT/versionpropertiesmaven.compiler.source16/maven.compiler.sourcemaven.compiler.target16/maven.compiler.target/propertiesdependencies!--thymeleaf导入模版工具类--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-thymeleaf/artifactId/dependency!--SpringMVCjar包文件--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!--热部署工具--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-devtools/artifactIdscoperuntime/scopeoptionaltrue/optional/dependency!--lombok插件--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependency!--测试包--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency!--引入jdbc包--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-jdbc/artifactId/dependency!--引入数据库驱动 --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdscoperuntime/scope/dependency!--spring整合mybatis-plus --dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.4.2/version/dependency/dependencies!--负责项目打包部署--buildpluginsplugingroupIdorg.springframework.boot/groupIdartifactIdspring-boot-maven-plugin/artifactIdconfigurationexcludesexcludegroupIdorg.projectlombok/groupIdartifactIdlombok/artifactId/exclude/excludes/configuration/pluginplugingroupIdorg.apache.maven.plugins/groupIdartifactIdmaven-compiler-plugin/artifactIdconfigurationsource16/sourcetarget16/target/configuration/plugin/plugins/build/projectpom文件引入依赖之后那么下一步就需要配置数据库 的连接以及我们配置的端口
server:port: 8090spring:datasource:url: jdbc:mysql://127.0.0.1:3306/jt?serverTimezoneGMT%2B8useUnicodetruecharacterEncodingutf8autoReconnecttrueallowMultiQueriestrueusername: rootpassword: wyproot123#整合SpringMVCthymeleaf:#设置页面前缀prefix: classpath:/templates/#设置页面后缀suffix: .html#是否使用缓存cache: falsemybatis-plus:type-aliases-package: com.jt.pojo#type-aliases-package: com.jtmapper-locations: classpath:/mappers/*.xml#开启驼峰映射configuration:map-underscore-to-camel-case: true#添加MP日志 打印执行的sql
logging:level:com.jt.mapper: debug
mapper文件
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.jt/mapper
首先我们要写一个实体类pojo注意这里的属性一定要和数据库的表列相对应
package com.jt.pojo;import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.experimental.Accessors;import java.io.Serializable;Data
Accessors(chain true)
TableName(user) //保证数据安全性和有效性必须序列化
public class User implements Serializable {TableId(type IdType.AUTO) //主键自增private Integer id;private String name;private Integer num;}
下一步我们就要写dao层结构
我们因为使用的是mybatis-plus所以我们在这里写的代码比较少这也就是框架的好处
package com.jt.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jt.pojo.User;/*** author :王闫彭* date : 2023/5/28*/
public interface UseMapper extends BaseMapperUser {
}
service层结构
首先写service接口
package com.jt.service;import com.jt.pojo.User;import java.util.List;public interface UserService {ListUser findAll();void insertUser(User user);void updateUser(User user);void deleteUserById(Integer id);
}
service的实现类
package com.jt.service;import com.jt.mapper.UserMapper;
import com.jt.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;Service
public class UserServiceImpl implements UserService{Autowiredprivate UserMapper userMapper;//mp的查询Overridepublic ListUser findAll() {return userMapper.selectList(null);}//MP的方式实现入库Overridepublic void insertUser(User user) {userMapper.insert(user);}//mp的更新Overridepublic void updateUser(User user) {userMapper.updateById(user);}//mp的删除Overridepublic void deleteUserById(Integer id) {userMapper.deleteById(id);}
}
controller层结构
package com.jt.controller;import com.jt.pojo.User;
import com.jt.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;import java.util.List;Controller
public class UserController {Autowiredprivate UserService userService;GetMapping(/findUser)ResponseBodypublic ListUser findAjaxUser(){return userService.findAll();}RequestMapping(/useraa/{id}/{name}/{num})ResponseBodypublic String insertUseraa(User user){userService.insertUser(user);return 添加成功;}RequestMapping(/userbb/{id}/{name})ResponseBodypublic String updateUseraa(User user){userService.updateUser(user);return 更新成功;}RequestMapping(/usercc/{id})ResponseBodypublic String deleteUsercc(PathVariable Integer id){userService.deleteUserById(id);//重新发起请求..return 删除成功;}}启动类
package com.jt;import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.ComponentScan;SpringBootApplication
MapperScan(com.jt.mapper)public class SpringBootRun {public static void main(String[] args) {SpringApplication.run(SpringBootRun.class,args);}
}
