SpringBoot应用无法从数据库取数及控制台无显示问题求助

问题描述 #

我在浏览器输入用户信息后，既无法在控制台查看输入内容，也无法从数据库获取对应数据。即使在另一个项目中使用H2控制台尝试相同操作，同样失败。怀疑问题可能与IDE或Java版本有关，视图文件的键值对实现看似正确，相关代码片段如下：

Repository 类 #

public interface Citizenplanrepo extends JpaRepository<CitizenPlan, Integer> {
    // 查询下拉框展示数据
    @Query("select distinct(planName) from CitizenPlan")
    public List<String> getPlanNames();
    
    @Query("select distinct(planStatus) from CitizenPlan")
    public List<String> getPlanStatus();
}

Service 实现类 #

@Service
public class CitizenPlanServiceImpl implements CitizenPlanService {

    @Autowired
    private Citizenplanrepo repo;
    
    @Override
    public List<String> getPlanNames() {
        return repo.getPlanNames();
    }

    @Override
    public List<String> getPlanStatus() {
        return repo.getPlanStatus();
    }

    @Override
    public List<CitizenPlan> Searchcitizen(SearchCriteria sc) {
        return repo.findAll();
    }

    @Override
    public void generateExcel(HttpServletResponse response) {

    }

    @Override
    public void generatePdf(HttpServletResponse response) {

    }
}

Controller 类 #

@Controller
public class CitizenController {
    
    @Autowired
    private CitizenPlanService service; 
    
    @GetMapping("/")
    public String indexModel(Model model) {
        List<String> planNames = service.getPlanNames();
        List<String> planStatus= service.getPlanStatus();
        
        model.addAttribute("planNames",planNames);
        model.addAttribute("planStatus",planStatus);
        model.addAttribute("search",new SearchCriteria());
        return "index";
    }
    
    @PostMapping("/filter-data")
    public String handleSearchbtn(@ModelAttribute("search") SearchCriteria criteria, Model model) {
        System.out.println(criteria);       
        List<CitizenPlan> citizensInfo = service.Searchcitizen(criteria);
        model.addAttribute("Citizen",citizensInfo);
        
        List<String> planNames = service.getPlanNames();
        List<String> planStatus= service.getPlanStatus();
        
        model.addAttribute("planNames",planNames);
        model.addAttribute("planStatus",planStatus);
        
        return "index";
    }
}

控制台输出 #

com.vishwas.binding.SearchCriteria@1547dbee
Hibernate: select distinct cp1_0.plan_name from citizen_plan cp1_0
Hibernate: select distinct cp1_0.plan_status from citizen_plan cp1_0

内容的提问来源于stack exchange，提问作者Vishwas51