server:
 port: 8080

spring:
 datasource:
 name:
 url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=UTC
 username: root
 password: root

mybatis:
 mapper-locations: classpath:mapper/*.xml

package com.ljsh.test.model;

public class Person {
 /*
 {id} 自增主鍵
 {name} 人員姓名
 {mobile} 人員電話
  */
 private int id;
 private String name;
 private String mobile;
 
 // 右鍵 Generate -> Setter and Getter -> Shift全選 -> ok 生成如下代碼

 public int getId() {
  return id;
 }

 public void setId(int id) {
  this.id = id;
 }

 public String getName() {
  return name;
 }

 public void setName(String name) {
  this.name = name;
 }

 public String getMobile() {
  return mobile;
 }

 public void setMobile(String mobile) {
  this.mobile = mobile;
 }
 
 // 右鍵 Generate -> toString() -> 全選 -> ok 生成如下代碼

 @Override
 public String toString() {
  return "Person{" +
    "id=" + id +
    ", name='" + name + '\'' +
    ", mobile='" + mobile + '\'' +
    '}';
 }
}

package com.ljsh.test.dao;

import com.ljsh.test.model.Person;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

@Mapper
public interface PersonDao {
  /*
  查所有
  return List
   */
  List getAll();

  /*
  根據(jù)ID查詢
  {id} 要查詢?nèi)藛T的 id
   */
  Person getPersonByID(int id);
  
  /*
  刪除
  {id} 要刪除人員的 id
   */
  void delete(int id);

  /*
  更新
  {p} 要更新的Person實例
   */
  void update(Person p);

  /*
  增加
  {p} 要新增的Person實例
   */
  void newp(Person p);
}

<?xml version="1.0" encoding="UTF-8" ?>



  
  
  person

  
  
  
    SELECT
    *
    FROM
    
  


  
  
    SELECT
    *
    FROM
    
    WHERE
    id = #{id}
  

  
  
    INSERT INTO
    
    (name,phone)
    VALUES
    (#{name},#{phone})
  

  
  
    UPDATE
    
    SET
    
    name = #{name},phone = #{phone},status = #{status}
    WHERE
    id = #{id}
  

  
  
    DELETE FROM
    
    WHERE
    id = #{id}
  

package com.ljsh.test.service;
import com.ljsh.test.dao.PersonDao;
import com.ljsh.test.model.Person;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class PersonService {
  @Autowired
  PersonDao personDao;

  /*
    Service層介于controller和dao之間作為服務層進行一些邏輯處理，
    這里邏輯太簡單所以知識單純調(diào)用dao所以不做注釋
   */
  public List getAll(){
    return personDao.getAll();
  }

  public Person getPersonByID(int id){
    return personDao.getPersonByID(id);
  }

  public void delete(int id){
    personDao.delete(id);
  }

  public void update(Person p){
    personDao.update(p);
  }

  public void newp(Person p){
    personDao.newp(p);
  }
}

package com.ljsh.test.controller;

import com.ljsh.test.model.Person;
import com.ljsh.test.service.PersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;

@Controller
public class PersonController {

  @Autowired
  PersonService personService;

  // 設置訪問路由值為路徑
  @RequestMapping("/")
  public ModelAndView index(){
    // 顧名思義 實體和數(shù)據(jù) 同時返回頁面模板和數(shù)據(jù)
    ModelAndView mav = new ModelAndView("index");
    List list = personService.getAll();
    mav.addObject("list",list);
    return mav;
  }
}

    

      
人員信息
      

        
Name
        
Phone
      
      
      
      

        
還沒有任何人員信息哦
        
你是不是想獨吞獎品