怎样可以选择一班的时候学号只显示1还有就是我单选学号的时候不出来数据

微信截图_20210909183508.png

FineReport 用户Csrpm3369394 发布于 2021-9-9 19:45 （编辑于 2021-9-9 19:47）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共1回答

最佳回答

Rose_RubyLv6初级互助
发布于2021-9-9 19:50（编辑于 2021-9-9 19:54）

你的SQL是怎么写的

可参考该SQL的逻辑来套

WHERE 1=1

${if(len(year_month) == 0,"","and ym in ('" + replace(year_month,",","','") + "')")}

${if(len(one_class) == 0,"","and one_class in ('" + replace(one_class,",","','") + "')")}

举报收起评论(3)

用户Csrpm3369394(提问者) SELECT A.STUDENTNO AS \'学号\', A.STUDENT_NAME AS \'姓名\', A.CLASSNO AS \'班级\', A.AGE AS \'年龄\', A.SEX AS \'性别\', A.ADDRESS AS \'家庭地址\', A.PHOTO AS \'照片\', B.ID AS \'序号\', B.STUDENTNO AS \'学号\', B.COURSE AS \'科目\', B.GRADE AS \'成绩\' FROM STUDENTINFO A LEFT JOIN CourseGrage B ON A.STUDENTNO = B.STUDENTNO WHERE A.STUDENTNO = \'${学号}\' and A.CLASSNO= \'${班级}\'

2021-09-09 19:53

Rose_Ruby 回复用户Csrpm3369394(提问者) 按照我的SQL来改下where

2021-09-09 19:55

Rose_Ruby 回复用户Csrpm3369394(提问者) select * from table_name (示例,自己改) WHERE 1=1 ${if(len(studentno) == 0,\"\",\"and A.STUDENTNO in (\'\" + replace(studentno,\",\",\"\',\'\") + \"\')\")} ${if(len(classno) == 0,\"\",\"and A.CLASSNO in (\'\" + replace(classno,\",\",\"\',\'\") + \"\')\")}

2021-09-09 19:56