SQL:
UserRole findByUseridAndRoleid(int userid, int roleid);
impl
public void toBusinessOfC2C(int userId) {
UserRole userRole = userRoleRepository.findByUseridAndRoleid(userId, 1);
if(userRole == null){
userRole = new UserRole()
.setUserid(userId)
.setRoleid(1)
.setStatus((byte)1)
.setCreatedat(new Timestamp(System.currentTimeMillis()))
.setUpdatedat(new Timestamp(System.currentTimeMillis()));
userRoleRepository.save(userRole);
}else {
userRole.setStatus((byte)1);
userRoleRepository.save(userRole);
}
}