@TableField("SJGSDWDM") private String sjgsdwdm; 这是dao层代码

这段代码看起来没有问题，确保表中的SJGSDWDM字段与实体类中的sjgsdwdm属性名称、类型和注解都一致，同时在调用查询方法时传入的sjgsdwdm参数值也与数据库中的数据匹配，就应该能够正常查询到对应的数据了。

如果还是无法解决问题，请提供一下完整的实体类、mapper接口和mapper.xml文件以及传入查询方法的参数值，我可以帮你更好地进行分析。

相关问题

springboot将redis哈希同步到MySQL中，service层和controller层，dao层怎么写

首先需要在pom.xml中添加相应的依赖：

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

然后需要在application.properties中配置Redis和MySQL的连接信息：

# Redis
spring.redis.host=xxxx
spring.redis.port=xxxx

# MySQL
spring.datasource.url=xxxx
spring.datasource.username=xxxx
spring.datasource.password=xxxx

接下来就可以写相关的代码了。

1. dao层：定义一个JPA的实体类和相应的Repository接口，如下：

@Entity
@Table(name = "hash_data")
public class HashData {
    @Id
    private String key;
    private String field;
    private String value;
    // getter, setter
}

public interface HashDataRepository extends JpaRepository<HashData, String> {
}

2. service层：定义一个同步Redis到MySQL的方法：

@Service
public class RedisSyncService {
    @Autowired
    private HashDataRepository hashDataRepository;

    @Autowired
    private StringRedisTemplate stringRedisTemplate;

    public void sync() {
        HashOperations<String, String, String> hashOperations = stringRedisTemplate.opsForHash();
        Set<String> keys = stringRedisTemplate.keys("*");

        for (String key : keys) {
            Map<String, String> entries = hashOperations.entries(key);

            for (Map.Entry<String, String> entry : entries.entrySet()) {
                HashData hashData = new HashData();
                hashData.setKey(key);
                hashData.setField(entry.getKey());
                hashData.setValue(entry.getValue());
                hashDataRepository.save(hashData);
            }
        }
    }
}

3. controller层：定义一个接口，可以调用Redis同步到MySQL的service方法：

@RestController
public class RedisSyncController {
    @Autowired
    private RedisSyncService redisSyncService;

    @GetMapping("/sync")
    public String sync() {
        redisSyncService.sync();
        return "Sync Success";
    }
}

至此，Redis哈希同步到MySQL的代码就完成了。需要注意的是，如果Redis中数据量很大，在同步时可能会出现性能问题。可以考虑使用分页查询等方式来优化同步性能。

我使用 MySQL 创建了一个用户表TbUser，并且使用@GetMapping("/alterListUsers") public String alterListUsers(@RequestParam(defaultValue = "1") int pageNum, Model model) { Page<TbUser> page = tbUserService.findUsers(pageNum); List<TbUser> userList = page.getContent(); model.addAttribute("userList", userList); model.addAttribute("currentPage", pageNum); model.addAttribute("totalPages", page.getTotalPages()); return "management/user-alter"; }完成了用户分页查询功能，查询的结果返回了user-alter.html，请使用springboot+hibernate+thymeleaf帮助我完成编辑用户的功能，点击编辑按钮后，弹窗一个表单可以修改用户所有信息，点击确定后将信息保存到数据库，包含DAO、Controller、Entity、Service、impl的详细代码

好的，以下是实现编辑用户的代码：

**TbUser.java(Entity):**

@Entity
@Table(name = "tb_user")
public class TbUser {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(nullable = false, unique = true)
    private String username;

    private String password;

    @Column(nullable = false)
    private String email;

    // getters and setters
    // equals and hashCode
}

**TbUserRepository.java(DAO):**

@Repository
public interface TbUserRepository extends JpaRepository<TbUser, Long> {

}

**TbUserService.java(Service):**

@Service
public class TbUserService {

    @Autowired
    private TbUserRepository tbUserRepository;

    public Page<TbUser> findUsers(int pageNum) {
        return tbUserRepository.findAll(PageRequest.of(pageNum - 1, 10));
    }

    public TbUser findById(Long id) {
        return tbUserRepository.findById(id).orElse(null);
    }

    public TbUser save(TbUser tbUser) {
        return tbUserRepository.save(tbUser);
    }
}

**TbUserServiceImpl.java(Service实现类):**

@Service
public class TbUserServiceImpl implements TbUserService {

    @Autowired
    private TbUserRepository tbUserRepository;

    @Override
    public Page<TbUser> findUsers(int pageNum) {
        return tbUserRepository.findAll(PageRequest.of(pageNum - 1, 10));
    }

    @Override
    public TbUser findById(Long id) {
        return tbUserRepository.findById(id).orElse(null);
    }

    @Override
    public TbUser save(TbUser tbUser) {
        return tbUserRepository.save(tbUser);
    }
}

**UserController.java(Controller):**

@Controller
@RequestMapping("/management")
public class UserController {

    @Autowired
    private TbUserService tbUserService;

    @GetMapping("/alterListUsers")
    public String alterListUsers(@RequestParam(defaultValue = "1") int pageNum, Model model) {
        Page<TbUser> page = tbUserService.findUsers(pageNum);
        List<TbUser> userList = page.getContent();
        model.addAttribute("userList", userList);
        model.addAttribute("currentPage", pageNum);
        model.addAttribute("totalPages", page.getTotalPages());
        return "management/user-alter";
    }

    @GetMapping("/editUser/{id}")
    public String editUser(@PathVariable Long id, Model model) {
        TbUser tbUser = tbUserService.findById(id);
        if (tbUser != null) {
            model.addAttribute("tbUser", tbUser);
            return "management/user-edit";
        } else {
            return "redirect:/management/alterListUsers";
        }
    }

    @PostMapping("/saveUser")
    public String saveUser(TbUser tbUser) {
        tbUserService.save(tbUser);
        return "redirect:/management/alterListUsers";
    }
}

**user-alter.html(用户列表页面):**

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>用户列表</title>
</head>
<body>
    <table>
        <thead>
        <tr>
            <th>ID</th>
            <th>用户名</th>
            <th>邮箱</th>
            <th>操作</th>
        </tr>
        </thead>
        <tbody>
        <tr th:each="tbUser : ${userList}">
            <td th:text="${tbUser.id}"></td>
            <td th:text="${tbUser.username}"></td>
            <td th:text="${tbUser.email}"></td>
            <td>
                <a th:href="@{/management/editUser/__${tbUser.id}__}">编辑</a>
            </td>
        </tr>
        </tbody>
    </table>
    <div>
        <ul>
            <li th:if="${currentPage != 1}">
                <a th:href="@{/management/alterListUsers(pageNum=1)}">首页</a>
            </li>
            <li th:if="${currentPage > 1}">
                <a th:href="@{/management/alterListUsers(pageNum=${currentPage - 1})}">上一页</a>
            </li>
            <li th:if="${currentPage < totalPages}">
                <a th:href="@{/management/alterListUsers(pageNum=${currentPage + 1})}">下一页</a>
            </li>
            <li th:if="${currentPage != totalPages}">
                <a th:href="@{/management/alterListUsers(pageNum=${totalPages})}">尾页</a>
            </li>
        </ul>
    </div>
</body>
</html>

**user-edit.html(用户编辑页面):**

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>编辑用户信息</title>
</head>
<body>
    <form th:action="@{/management/saveUser}" method="post">
        <input type="hidden" th:field="*{id}"/>
        <div>
            <label>用户名：</label>
            <input type="text" th:field="*{username}"/>
        </div>
        <div>
            <label>密码：</label>
            <input type="password" th:field="*{password}"/>
        </div>
        <div>
            <label>邮箱：</label>
            <input type="email" th:field="*{email}"/>
        </div>
        <div>
            <button type="submit">保存</button>
        </div>
    </form>
</body>
</html>

以上就是实现编辑用户功能的详细代码。