目录
一、直接写8001端口程序里,不用改的部分
pom.xml、application.yml、程序入口、实体entity
二、开始书写添加的方法
2.1 先写数据库代码
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.8//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.clouddemo.dao.TabUsersDao">
<select id="findall" resultType="TabUsers">
select * from tab_user
</select>
<insert id="save" parameterType="TabUsers">
insert into tab_users values(#{id},#{loginname},#{password},#{username})
</insert>
</mapper>
2.2 再写dao
package com.clouddemo.dao;
import com.clouddemo.entities.TabUsers;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper//与mapper里的xml建立联系
public interface TabUsersDao {
public List<TabUsers> findall();
public boolean save(TabUsers u);
}
2.3 再写service和serviceImpl
package com.clouddemo.service;
import com.clouddemo.entities.TabUsers;
import java.util.List;
public interface TabUsersService {
public List<TabUsers> findall();
public boolean save(TabUsers u);
}
package com.clouddemo.service.Impl;
import com.clouddemo.dao.TabUsersDao;
import com.clouddemo.entities.TabUsers;
import com.clouddemo.service.TabUsersService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service
public class TabUsersServiceImpl implements TabUsersService {
@Resource
private TabUsersDao dao;
@Override
public List<TabUsers> findall() {
return dao.findall();
}
@Override
public boolean save(TabUsers u) {
return dao.save(u);
}
}
2.4 最后写controller
package com.clouddemo.controller;
import com.clouddemo.entities.TabUsers;
import com.clouddemo.service.TabUsersService;
import lombok.extern.slf4j.Slf4j;
import net.minidev.json.JSONArray;
import net.minidev.json.JSONObject;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@RestController
@Slf4j//日志
public class TabUsersController {
@Resource
private TabUsersService service;
//@PostMapping-对数据库操作
@GetMapping(value = "/tab_users_findall")//get对数据库不操作仅查询
public String tab_users_findall() {
JSONArray json = new JSONArray();
List<TabUsers> list = service.findall();
for (TabUsers t : list) {
JSONObject jo = new JSONObject();
String id = t.getId();
String loginname = t.getLoginname();
String password = t.getPassword();
String username = t.getUsername();
jo.put("id", id);
jo.put("loginname", loginname);
jo.put("password", password);
jo.put("username", username);
json.add(jo);
}
return json.toJSONString();
//return json+"";
}
@PostMapping(value = "/tab_users_save")
public String save(@RequestBody TabUsers t){
String id="4";
t.setId(id);
JSONObject jo=new JSONObject();
boolean i=service.save(t);
if(i){
jo.put("code","200");
jo.put("msg","success");
}else{
jo.put("code","500");
jo.put("msg","error");
}
return jo.toJSONString();
}
}
三、在80端口中添加跳转
config和实体和程序入口都不用动,仅需修改controller
package com.clouddemo.controller;
import com.clouddemo.entities.TabUsers;
import com.clouddemo.service.TabUsersService;
import com.clouddemo.util.CreateUUID;
import lombok.extern.slf4j.Slf4j;
import net.minidev.json.JSONArray;
import net.minidev.json.JSONObject;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@RestController
@Slf4j//日志
public class TabUsersController {
@Resource
private TabUsersService service;
//@PostMapping-对数据库操作
@GetMapping(value = "/tab_users_findall")//get对数据库不操作仅查询
public String tab_users_findall() {
JSONArray json = new JSONArray();
List<TabUsers> list = service.findall();
for (TabUsers t : list) {
JSONObject jo = new JSONObject();
String id = t.getId();
String loginname = t.getLoginname();
String password = t.getPassword();
String username = t.getUsername();
jo.put("id", id);
jo.put("loginname", loginname);
jo.put("password", password);
jo.put("username", username);
json.add(jo);
}
return json.toJSONString();
//return json+"";
}
@PostMapping(value = "/tab_users_save")
public String save(@RequestBody TabUsers u){
String id= CreateUUID.getuuid();
u.setId(id);
JSONObject jo=new JSONObject();
boolean i=service.save(u);
if(i){
jo.put("code","200");
jo.put("msg","success");
}else{
jo.put("code","500");
jo.put("msg","error");
}
return jo.toJSONString();
}
}
其中CreateUUID是自己建的方法,放在util里
package com.clouddemo.util;
import java.util.UUID;
//创建随机ID
public class CreateUUID {
public static String getuuid() {
return UUID.randomUUID().toString().replaceAll("-", "");
}
}
四、运行
http://localhost/users/tab_users_save