随手写的,没设置数据对应关系,没设置访问权限,不影响使用,加上很好。
文件目录 正文 注入依赖- 后端_MainControllerorg.springframework.boot spring-boot-starter-web org.projectlombok lombok true org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-web org.projectlombok lombok true org.springframework.boot spring-boot-starter-test test org.mybatis.spring.boot mybatis-spring-boot-starter 2.2.0 mysql mysql-connector-java org.springframework.boot spring-boot-starter-test org.springframework.boot spring-boot-starter-thymeleaf
import com.example.entry.Student;
import com.example.service.MessageService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
@Controller
public class MainController {
// 注入数据
@Resource
MessageService MessageService;
// 这里是显示所有信息
@RequestMapping(value = "allMessage")
public String getBooksList(@RequestParam(value = "name",required = false)String name,Model model) {
model.addAttribute("books",name==null?MessageService.list("%"):MessageService.list("%"+name+"%"));
return "allMessage";
}
// 这里是添加过后的逻辑
@RequestMapping(value = "addED",method = RequestMethod.POST)
public String addBook(@RequestParam("name")String name, @RequestParam("no")String no, @RequestParam("sex")String sex, @RequestParam("clas")String clas, @RequestParam("tel")String tel, @RequestParam("adde")String adde, @RequestParam("coll")String coll){
MessageService.add(name,no,sex,clas,tel,adde,coll);
return "redirect:/allMessage";
}
// 这里是添加之前的逻辑
@RequestMapping("https://blog.csdn.net/adding")
public String index4() {
return "addMessage";
}
// 这里是删除逻辑,删除完了直接重定向
@RequestMapping(value = "delBook",method = RequestMethod.GET)
public String addBook(@RequestParam("id") int id){
MessageService.Del(id);
return "redirect:allMessage";
}
// 账户登录逻辑
@RequestMapping("/b")
public String test1(@RequestParam("username") String username, @RequestParam("password") String password, Model model){
return MessageService.findUser(username,password)==null? "/index": "redirect:/allMessage";
}
// 修改前
@RequestMapping("/update")
public String update(@RequestParam("id") int id,Model model){
model.addAttribute("book",MessageService.findByID(id));
return "updateMessage";
}
// 修改后重定向
@RequestMapping("/update2")
public String updateBook2(@ModelAttribute(value = "demo") Student demo, Model model){
MessageService.update(demo.getName(),demo.getNo(),demo.getSex(),demo.getClas(),demo.getTel(),demo.getAdde(),demo.getColl(),demo.getId());
return "redirect:allMessage";
}
}
- 后端_MainMapper
import com.example.entry.Student;
import com.example.entry.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
//@Mapper
public interface MainMapper {
@Select("select * from users where username=#{username}&&password=#{password}")
User findUser(@Param("username")String username,@Param("password")String password);
@Select("select *from message where name like #{name}")
List bookList(@Param("name") String name);
@Select("select * from message where id=#{id}")
Student findByID(@Param("id") int id);
@Delete("delete from message where id=#{id}")
void Del(@Param("id") int id);
@Insert("insert into message values (null, #{name} , #{no} , #{sex} , #{clas}, #{tel}, #{adde}, #{coll})")
void add(@Param("name") String name, @Param("no") String no, @Param("sex") String sex, @Param("clas") String clas, @Param("tel") String tel, @Param("adde") String adde, @Param("coll") String coll);
@Update("update message set name=#{name} , no=#{no} , sex=#{sex}, clas=#{clas}, tel=#{tel}, adde=#{adde}, coll=#{coll} where id=#{id}")
void update(@Param("name") String name, @Param("no") String no, @Param("sex") String sex, @Param("clas") String clas, @Param("tel") String tel, @Param("adde") String adde, @Param("coll") String coll,@Param("id")int id);
}
- 后端_MessageService
import com.example.entry.Student;
import com.example.entry.User;
import com.example.mapper.MainMapper;
import javax.annotation.Resource;
import java.util.List;
//@Service
public class MessageService {
// 数据源
@Resource
MainMapper mapper;
// 回显数据
public List list(String name) {
return mapper.bookList(name);
}
// 登录
public User findUser(String username, String password){
return mapper.findUser(username,password);
}
// 删除
public void Del(int id) {
mapper.Del(id);
}
// 添加
public void add(String name, String no, String sex,String clas,String tel,String adde,String coll) {
mapper.add(name, no, sex,clas,tel,adde,coll);
}
// 修改
public Student findByID(int id) {
return mapper.findByID(id);
}
// 更新
public void update(String name, String no, String sex, String clas, String tel, String adde, String coll,int id) {
mapper.update(name, no, sex,clas,tel,adde,coll,id);
}
}
- 实体类_User
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
int id;
String username;
String password;
String role;
}
- 实体类_Student
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
int id;
String name;
String no;
String sex;
String clas;
String tel;
String adde;
String coll;
}
- 前端_首页
新增通讯录
新增通讯录
- 前端_添加数据
新增通讯录
新增通讯录
- 前端_显示所有数据
通讯录列表
- 前端_更新
修改信息
修改信息
- SQL_Users
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`role` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'test', '$2a$10$9t6WBfMUYkjRDzoISpo6C.VYsJZzGrEk9dyx3QyGUzhDDSqBrNStC', 'user');
INSERT INTO `users` VALUES ('2', 'and', 'and', 'user');
- SQL_Message
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`clas` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`adde` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`coll` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `name_2` (`name`,`id`),
KEY `name_3` (`name`,`id`,`clas`),
KEY `id` (`id`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES ('3', '魏', '123', '男1', 'Java', '5421', null, 'huaxue');
INSERT INTO `message` VALUES ('4', '申', '1928', '女', 'java', '我去打球', null, 'awdaw');



