springboot+mycat数据库中间件+mysql(一主一备)主从复制

2023年12月27日发(作者：防诈骗黑板报)

spring:

datasource:

url: jdbc:mysql://192.168.43.155:8066/mydb

urname: mycat

password: mycat

driverClassName: controller

package ller;import ;import red;import ller;import ap;import tMapping;import ndView;import ;import Service;@Controllerpublic class TicketController { @Autowired private TicketService ticketService; @RequestMapping("/") public ModelAndView getTicketList() { List ticketList = ketList(); ModelAndView mav = new ModelAndView(); wName("index"); ect("ticketList", ticketList); return mav; }; @RequestMapping("/") public ModelAndView getFtl(ModelAndView mav) { ect("name", "ss"); wName("index"); return mav; }; @RequestMapping("/index") public String getFtlt(ModelMap map) { ribute("name", "你妈"); return "index"; };}

rvice

package e;import ;import red;import e;import Mapper;import ;import ils;@Servicepublic class TicketService { @Autowired private TicketMapper ticketMapper; public List getTicketList() { List ticketList = ketList(); for (Ticket ticket : ticketList) { String beginTimeStr = Time(inTime()); String endTimeStr = Time(Time()); inTimeStr(beginTimeStr); TimeStr(endTimeStr); } return ticketList; }}

mapper

package ;import ;import ;import ;public interface TicketMapper {

@Select("lect * from ticket;") List getTicketList();}ticket

package ;import ;/** *

* @ClassName: Ticket

} public void tPrice(Integer price) { = price; } public Date getBeginTime() { return beginTime; } public void tBeginTime(Date beginTime) { ime = beginTime; } public Date getEndTime() { return endTime; } public void tEndTime(Date endTime) { e = endTime; } public String getBeginTimeStr() { return beginTimeStr; } public void tBeginTimeStr(String beginTimeStr) { imeStr = beginTimeStr; } public String getEndTimeStr() { return endTimeStr; } public void tEndTimeStr(String endTimeStr) { eStr = endTimeStr; }

}(模板引擎)