package com.demo.example.entity;

import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "user_name")
public class MyUser implements Serializable {
    private static final long serialVersionUID = 1L;
    /*
        |-user_name 表中的主键分别为
        |----|- id int
        |----|- age int
        |----|- username string
        |----|- gender string
     */
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    private int age;
    private String username;
    private String gender;

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

    // age
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }

    // username
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }

    // gender
    public String getGender() {
        return gender;
    }
    public void setGender(String gender) {
        this.gender = gender;
    }
}

package com.demo.example.repository;

import java.util.List;
import com.demo.example.entity.MyUser;
import org.springframework.data.jpa.repository.JpaRepository;


public interface UserRepository extends JpaRepository<MyUser, Integer> {
    public MyUser findByUsername(String username);
    public List<MyUser>findByUsernameLike(String username);
}

package com.demo.example.service;

import java.util.List;
import com.demo.example.entity.MyUser;

public interface UserService {
    public void saveAll();
    public List<MyUser>findAll();
    public MyUser findByUsername(String username);
    public List<MyUser>findByUsernameLike(String username);
    public MyUser getOne(int id);
}

package com.demo.example.service;

import java.util.ArrayList;
import java.util.List;
import com.demo.example.entity.MyUser;
import com.demo.example.repository.UserRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserRepository userRepository;

    @Override
    public void saveAll() {
        MyUser myUser1 = new MyUser();
            myUser1.setUsername("kunlunsiqu");
            myUser1.setGender("N");
            myUser1.setAge(20);
        MyUser myUser2 = new MyUser();
            myUser2.setUsername("flydata");
            myUser2.setGender("M");
            myUser2.setAge(21);
        MyUser myUser3 = new MyUser();
            myUser3.setUsername("gscssd");
            myUser3.setGender("N");
            myUser3.setAge(30);
        List<MyUser> users = new ArrayList<MyUser>();
            users.add(myUser1);
            users.add(myUser2);
            users.add(myUser3);
        userRepository.saveAll(users);
    }

    @Override
    public List<MyUser> findAll() {
        return userRepository.findAll();
    }
    @Override
    public MyUser findByUsername(String username) {
        return userRepository.findByUsername(username);
    }
    @Override
    public List<MyUser> findByUsernameLike(String username) {
        return userRepository.findByUsernameLike("%" + username + "%");
    }

    @Override
    public MyUser getOne(int id) {
        return userRepository.getOne(id);
    }
}

package com.demo;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.demo.example.service.UserService;


@Controller
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/save")
    @ResponseBody
    public String save() {
            userService.saveAll();
            System.out.println("UserController");
        return "保存成功";
    }
    @RequestMapping("/findByUsername")
    public String findByUsername(String username, Model model) {
            model.addAttribute("title","根据名称查询");
            model.addAttribute("auser", userService.findByUsername(username));
        return "showAuser";
    }
    @RequestMapping("/getOne")
    public String getOne(int id, Model model) {
            model.addAttribute("title","根据名称id查询");
            model.addAttribute("auser", userService.getOne(id));
        return "showAuser";
    }
    @RequestMapping("findAll")
    public String findAll(Model model) {
            model.addAttribute("title", "查询所有");
            model.addAttribute("allUsers", userService.findAll());
        return "showAll";
    }
    @RequestMapping("/findByUsernameLike")
    public String findByUsernameLike(String username,Model model) {
            model.addAttribute("title","用户名模糊查询");
            model.addAttribute("allUsers", userService.findByUsernameLike(username));
        return "showAll";
    }
}