@Entity
@Table(name="s_user")//对应表
public class User {
@Id
@Column(name="id")
@GeneratedValue(strategy=GenerationType.IDENTITY)//自增长
private Long id;
@Column(name="user_name")//在windows系统下mysql不区分大小写。在Linux系统下,区分大小写
private String user_name;
@Column(name="password")
private String password;
@Column(name="name")
private String name;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getUser_name() {
return user_name;
}
public void setUser_name(String user_name) {
this.user_name = user_name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "User [id=" + id + ", user_name=" + user_name + ", password=" + password + ", name=" + name + "]";
}
}
(2).编写Mapper类
/*
* 使用mybatis实现对数据库的操作接口
*/
@Mapper //要求mybatis的版本3.3以上 声明Mapper接口
public interface IUserMapper {
@Select("select * from s_user where name like '%${value}%'")//$value是传过来name的值 声明这个接口所需要使用的sql,当然,有查询的注解,肯定就有增删改的注解
public List<User> queryUserByName(String name);
}
/*
* 用户业务层实现类
*/
/*
* 用户业务层实现类
*/
@Service("userService")
public class UserServiceImpl implements IUserService {
@Autowired
private IUserMapper userMapper;
public List<User> queryUserByName(String name) {
System.out.println(name);
return userMapper.queryUserByName(name);
}
}
(5).创建Controller
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private IUserService userService;
@RequestMapping("/findAll/{name}")
public List<User> findAllUser(@PathVariable("name")String name){
List<User> users = userService.queryUserByName(name);
return users;
}
}
(6).创建引导类(注意引导类所放的包)
/*
* spring boot引导类
*/
@SpringBootApplication
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}