java吧 关注:1,254,064贴子:12,743,281
  • 10回复贴,共1

大佬们,救我毕业设计遇到个bug

只看楼主收藏回复

毕业设计师在b站找了个教务管理系统的项目,具体的问题是所属专业这里不显示数据,我刷新了之后显示暂无数据,我能力有限实在不知道是哪里导致的bug,好像是只要涉及到这段类似功能的代码就不显示数据代码和报错如下:<select id="selectAll" resultType="com.example.entity.Classes">
select classes.*,teacher.name as teacherName,speciality.name as specialityName
from classes
left join teacher on classes.teacher_id = teacher.id
left join speciality on classes.speciality_id = speciality.id
<where>
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5c513901]
<== Row: 1, 计算机科学与技术, 计算机科学与技术, null, 100, null
<== Total: 2
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5a9a8067]
JDBC Connection [HikariProxyConnection@1980578057 wrapping com.mysql.cj.jdbc.ConnectionImpl@1efb3ff4] will not be managed by Spring
==> Preparing: SELECT count(0) FROM classes LEFT JOIN teacher ON classes.teacher_id = teacher.id LEFT JOIN speciality ON classes.speciality_id = speciality.id
==> Parameters:
<== Columns: count(0)
<== Row: 1
<== Total: 1
==> Preparing: select classes.*,teacher.name as teacherName,speciality.name as specialityName from classes left join teacher on classes.teacher_id = teacher.id left join speciality on classes.speciality_id = speciality.id order by id desc LIMIT ?
==> Parameters: 10(Integer)
<== Columns: id, name, content, teacher_id, speciality_id, teacherName, specialityName
<== Row: 2, 计算机科学技术1班, 计算机科学技术1班, 10, 1, 查宇, 计算机科学与技术
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@672e53b5]


IP属地:安徽1楼2024-12-01 21:05回复
    查一下这段有没有定义的类,数据库查询没出问题,大概率是从数据库转换到类的字段对应的值的时候出了问题。
    看下是否符合小驼峰。
    我觉得可能是故意埋了坑吧,其它字段毕竟是正常的。
    愿意发代码的话,发下,我去看看


    IP属地:浙江2楼2024-12-01 21:42
    收起回复
      看看这个字段是不是在查询class.*这表里面,在这表里面给个别名,就行了


      IP属地:湖北来自iPhone客户端3楼2024-12-01 22:14
      收起回复
        为什么你们毕设这么快就开搞了


        IP属地:广东来自Android客户端4楼2024-12-02 01:11
        收起回复
          有现成的,无bug


          IP属地:江苏来自Android客户端5楼2024-12-02 11:09
          回复
            学debug或者打印一下日志


            IP属地:广西6楼2024-12-03 16:23
            回复