微服务+mybaits-plus+layui分页对数据库进行增删改查

新建pom项目,引入依赖

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.10.RELEASE</version>
    </parent>

    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-dependencies</artifactId>
                <version>Edgware.SR2</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

新建子模块SPRINGCLOUD_EUREKASERVER:注册中心
main方法:启动注册中心

@SpringBootApplication
@EnableEurekaServer
public class EurekaServerMain {

    public static void main(String[] args) {
        new SpringApplicationBuilder(EurekaServerMain.class).web(true).run(args);
    }

}

引入依赖

<dependencies>
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-eureka-server</artifactId>
        </dependency>
    </dependencies>
    /**
    	将注册中心打包到Linux系统上所需要的插件
    **/
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

注册中心resources配置文件:application.yml

eureka:
  instance:
    preferIpAddress: true #将来注册到注册中心的微服务包括注册中心都是使用IP地址
    hostname: localhost
  client:
    registerWithEureka: false #是否注册到注册中心 注册中心自己不用注册
    fetchRegistry: false #是否抓取注册中心的注册信息
    serviceUrl:
      defaultZone: http://localhost:8761/eureka/ #微服务和客户端用来注册和发现的地址
server:
  port: 8761

新建子模块SPRINGCLOUD_USERSERVICE:服务端
实体类

package cn.ps.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;

public class User{
	
	@TableId(type=IdType.AUTO)
    private int id;
	@TableField("username")
    private String userName;
	
	@TableField("usersex")
    private String userSex;
	
	@TableField("userage")
    private String userAge;
	
	@TableField("userphone")
    private String userPhone;
	
	@TableField("usermoney")
    private String userMoney;
	
	@TableField("useremail")
    private String userEmail;
    
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getUserSex() {
		return userSex;
	}
	public void setUserSex(String userSex) {
		this.userSex = userSex;
	}
	public String getUserAge() {
		return userAge;
	}
	public void setUserAge(String userAge) {
		this.userAge = userAge;
	}
	public String getUserPhone() {
		return userPhone;
	}
	public void setUserPhone(String userPhone) {
		this.userPhone = userPhone;
	}
	public String getUserMoney() {
		return userMoney;
	}
	public void setUserMoney(String userMoney) {
		this.userMoney = userMoney;
	}
	public String getUserEmail() {
		return userEmail;
	}
	public void setUserEmail(String userEmail) {
		this.userEmail = userEmail;
	} 
}
public class Result {
    private int code;
    private String msg;
    private int count;
    private List data;

    public int getCode() {
        return code;
    }

    public void setCode(int code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public int getCount() {
        return count;
    }

    public void setCount(int count) {
        this.count = count;
    }

    public List getData() {
        return data;
    }

    public void setData(List data) {
        this.data = data;
    }

接口映射类

@Mapper
public interface UserMapper extends BaseMapper<User>{

}

service层

@RestController
public class UserServiceImpl{
	@Autowired
	private UserMapper userMapper;
	@GetMapping("/users")
	public Result queryUser(String userName,String userMoney,String curPage, String numPage) {
		//第一次访问没有当前页
		if(StringUtils.isEmpty(curPage)) {
			curPage="1";
		}
		if(StringUtils.isEmpty(numPage)) {
			numPage="10";
		}
		QueryWrapper<User> qw=new QueryWrapper<User>();
		if(StringUtils.isNotEmpty(userName)) {
			qw.like("username", userName);
		}
		if(StringUtils.isNotEmpty(userMoney)) {
			qw.eq("usermoney", userMoney);
		}
		
		//转换成int类型
		int cur=Integer.parseInt(curPage);
		int num=Integer.parseInt(numPage);
		IPage<User> pageData=userMapper.selectPage(new Page<User>(cur,num), qw);
		Result result=new Result();
		result.setCode(0);
		result.setCount((int)pageData.getTotal());
		result.setData(pageData.getRecords());
		return result;
	}
	@PostMapping("/user")
	public void addUser(@RequestBody User user) {
		userMapper.insert(user);
	}
	@Delete
  • 1
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值