POJO类不变
usermapper增加一个方法:
package com.test.mapper;
import com.test.entity.MyUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;
@Mapper
public interface UserMapper {
public List<MyUser> findAll();
@Select("select * from users limit 10")
public List<MyUser> findShi();
}
服务接口:
package com.test.service;
import com.test.entity.MyUser;
import java.util.List;
public interface UserService
{
List<MyUser> findAll();
List<MyUser> findShi();
}
实现查询接口:
package com.test.service.impl;
import com.test.entity.MyUser;
import com.test.mapper.UserMapper;
import com.test.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserServiceImpl implements UserService
{
@Autowired
UserMapper userMapper;
@Override
public List<MyUser> findAll()
{
return userMapper.findAll();
}
@Override
public List<MyUser> findShi()
{
return userMapper.findShi();
}
}
控制层:
package com.test.controller;
import com.test.entity.MyUser;
import com.test.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class StartMainController
{
@Autowired
private UserService userService;
@GetMapping(value = "/1")
public List<MyUser> home1()
{
// 查询所有网站
List<MyUser> users = userService.findAll();
for (MyUser user : users)
{
System.out.println(user.getId()+" "+user.getName()+" "+user.getName());
}
return users;
}
@GetMapping(value = "/2")
public List<MyUser> home2()
{
// 查询所有网站
List<MyUser> users = userService.findShi();
for (MyUser user : users)
{
System.out.println(user.getId()+" "+user.getName()+" "+user.getName());
System.out.println(" ");
}
return users;
}
}
http://localhost:8080/2