sql 语句报错 res := common.DB.Raw("SELECT * FROM(SELECT * FROM flaws WHERE facility_id = ? AND label LIKE '%?%' "+ "UNION SELECT * FROM issues WHERE facility_id = ? AND label = ? "+ "UNION SELECT * FROM records WHERE facility_id = ? AND label = ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? AND label = ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ? AND label = ?)"+ "AS combined_tables LIMIT ? OFFSET ?", code, label, code, label, code, label, code, label, code, label, pageSize, offset).Find(&req)

时间: 2024-01-17 13:05:51 浏览: 24
这个 SQL 语句中有一些问题。首先，在查询中使用 `%?%` 这种方式是不正确的，正确的应该是使用 `?` 并在参数中加上 `%`。其次，在 SQL 语句中应该使用占位符 `?` 来代替参数，而不是直接写在字符串中。你可以尝试修改这个 SQL 语句如下： ``` res := common.DB.Raw("SELECT * FROM(SELECT * FROM flaws WHERE facility_id = ? AND label LIKE ? "+ "UNION SELECT * FROM issues WHERE facility_id = ? AND label = ? "+ "UNION SELECT * FROM records WHERE facility_id = ? AND label = ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? AND label = ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ? AND label = ?) "+ "AS combined_tables LIMIT ? OFFSET ?", code, "%"+label+"%", code, label, code, label, code, label, code, label, pageSize, offset).Find(&req) ``` 这样修改后，就可以正确地使用参数了。

相关推荐

pdf

信息安全_数据安全_Case Files from 20 Years of Business Logic Flaws.pdf

信息安全_数据安全_Case Files from 20 Years of Business Logic Flaws 漏洞分析 安全审计 安全体系 信息保护 威胁检测
nasl

kerio_webmail_multiple_flaws.nasl

kerio_webmail_multiple_flaws
nasl

icecast_xsl_parser_flaws.nasl

icecast_xsl_parser_flaws

改进代码res := common.DB.Raw("SELECT * FROM(SELECT * FROM flaws WHERE facility_id = ? AND label LIKE ? "+ "UNION SELECT * FROM issues WHERE facility_id = ? AND label LIKE ? "+ "UNION SELECT * FROM records WHERE facility_id = ? AND label LIKE ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? AND label LIKE ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ? AND label LIKE ?)"+ "AS combined_tables LIMIT ? OFFSET ?", code, "%"+strconv.Itoa(label)+"%", code, strconv.Itoa(label)+"%", code, strconv.Itoa(label)+"%", code, strconv.Itoa(label)+"%", code, strconv.Itoa(label)+"%", pageSize, offset).Find(&req)

res1 := common.DB.Raw("SELECT * FROM flaws WHERE facility_id = ? AND label LIKE ?", code, "%"+strconv.Itoa(label)+"%") res2 := common.DB.Raw("SELECT * FROM issues WHERE facility_id = ? AND label LIKE ...

改进代码var req []*Total res := db.Scopes(models.Paginate(page, pageSize)).Raw("SELECT * FROM flaws WHERE facility_id = ? "+ "UNION SELECT * FROM issues WHERE facility_id = ? "+ "UNION SELECT * FROM records WHERE facility_id = ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ?", code, code, code, code, code).Find(&req)

stmt, err := db.DB().Prepare("SELECT * FROM flaws WHERE facility_id = ? " + "UNION SELECT * FROM issues WHERE facility_id = ? " + "UNION SELECT * FROM records WHERE facility_id = ? " + "UNION ...

改进代码var req []*Total res := db.Scopes(models.Paginate(page, pageSize)).Raw("SELECT * FROM flaws WHERE facility_id = ? "+ "UNION SELECT * FROM issues WHERE facility_id = ? "+ "UNION SELECT * FROM records WHERE facility_id = ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ?", code, code, code, code, code).Find(&req)

err := db.Where("facility_id = ?", code). Select("id, created_at, updated_at, field1, field2, NULL as field3, NULL as field4, NULL as field5"). Table("flaws"). Union(db.Where("facility_id = ?", ...

改进代码 var req Total rows, err := common.DB.Raw("SELECT * FROM flaws WHERE facility_id = ? "+ "UNION SELECT * FROM issues WHERE facility_id = ? "+ "UNION SELECT * FROM records WHERE facility_id = ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ?", code, code, code, code, code).Rows() if err != nil { resp.Code = 400 resp.Msg = "记录不存在" ctx.JSON(400, resp) return } for rows.Next() { common.DB.ScanRows(rows, &req) } resp.Data = req ctx.JSON(200, resp)

if err := common.DB. Table("flaws"). Joins("INNER JOIN issues ON flaws.facility_id = issues.facility_id"). Joins("INNER JOIN records ON issues.facility_id = records.facility_id"). Joins("INNER ...

改进代码func TracingList(ctx *gin.Context) { resp := models.Response{ Code: 0, Msg: "success", } t, _ := strconv.Atoi(ctx.Query("t")) label, _ := strconv.Atoi(ctx.Query("label")) page, _ := strconv.Atoi(ctx.DefaultQuery("page", "1")) pageSize, _ := strconv.Atoi(ctx.DefaultQuery("pageSize", "10")) code := ctx.Query("code") //设施类型 if len(code) == 0 { resp.Code = 400 resp.Msg = "请输入code值" ctx.JSON(400, resp) return } type Total struct { gorm.Model Type int16 Source int16 Explanation string Label int16 FacilityID string } db := common.DB.Session(&gorm.Session{}) if t < 0 || t > 5 { var req interface{} switch t { case 0: req = []*Total{} case 1: req = []*models.Flaw{} case 2: req = []*models.Issue{} case 3: req = []*models.Record{} case 4: req = []*models.Quality{} case 5: req = []*models.Inspection{} } //查询并分页 if t < 1 || t > 5 { res := db.Scopes(models.Paginate(page, pageSize)).Where("facility_id=?", code).Find(&req) if res.RowsAffected == 0 { resp.Code = 400 resp.Msg = "记录不存在" ctx.JSON(400, resp) return } } else { res := db.Scopes(models.Paginate(page, pageSize)).Raw("SELECT * FROM flaws WHERE facility_id = ? "+ "UNION SELECT * FROM issues WHERE facility_id = ? "+ "UNION SELECT * FROM records WHERE facility_id = ? "+ "UNION SELECT * FROM qualities WHERE facility_id = ? "+ "UNION SELECT * FROM inspections WHERE facility_id = ?", "code", "code", "code", "code", "code").Find(&req) if res.RowsAffected == 0 { resp.Code = 400 resp.Msg = "记录不存在" ctx.JSON(400, resp) return } } resp.Data = req ctx.JSON(200, resp) } else if label < 1 || label > 4 { var req []*Total res := db.Scopes(models.Paginate(page, pageSize)).Raw("SELECT * FROM flaws WHERE label = ? "+ "UNION SELECT * FROM issues WHERE label = ? "+ "UNION SELECT * FROM records WHERE label = ? "+ "UNION SELECT * FROM qualities WHERE label = ? "+ "UNION SELECT * FROM inspections WHERE label = ?", "label", "label", "label", "label", "label").Find(&req) if res.RowsAffected == 0 { resp.Code = 400 resp.Msg = "记录不存在" ctx.JSON(400, resp) return } resp.Data = req ctx.JSON(200, resp) } else { ctx.JSON(400, models.Response{ Code: 400, Msg: "参数有误", }) return } }

res := db.Scopes(models.Paginate(page, pageSize)).Where("facility_id=?", code) if t >= 1 && t <= 5 { res = res.Table("flaws").Where("facility_id=?", code). Or("facility_id=?", code). Or("facility...

改进代码if startT == "" || endT == "" { sqlstr = "" } else { var buf bytes.Buffer fmt.Fprintf(&buf, "AND created_at BETWEEN %s AND %s", startT, endT) sqlstr = buf.String() } res := common.DB.Raw("SELECT * FROM(SELECT id,created_at,type,source,explanation,label,location,facility_id,pm_id FROM flaws WHERE facility_id = ? "+sqlstr, "UNION SELECT id,created_at,type,source,explanation,label,location,facility_id,pm_id FROM issues WHERE facility_id = ? "+sqlstr, "UNION SELECT id,created_at,type,source,explanation,label,location,facility_id,pm_id FROM records WHERE facility_id = ? "+sqlstr, "UNION SELECT id,created_at,type,source,explanation,label,location,facility_id,pm_id FROM qualities WHERE facility_id = ? "+sqlstr, "UNION SELECT id,created_at,type,source,explanation,label,location,facility_id,pm_id FROM inspections WHERE facility_id = ?)"+sqlstr, "AS combined_tables LIMIT ? OFFSET ?", code, code, code, code, code, pageSize, offset).Find(&req)

sql := SELECT * FROM table1 JOIN table2 ON table2.id = table1.table2_id WHERE table1.id = ? 5. 使用结构体来存储查询参数，提高代码的可读性和可维护性。例如： type QueryParams struct { ...

Stack Overflow Q & A threads是什么意思？

: "What is the difference between python 2 and python 3?" Python 3 is designed to fix some of the flaws in Python 2 and to improve its overall performance. Some of the main differences between the ...

写一篇关于python漏洞扫描器理论知识的英语文献，字数要有10000字

These tools are designed to automatically scan software code and identify potential security flaws that can be exploited by attackers. The Python language is widely used in web application ...

帮我写一篇“何为文化自信的底气”英语演讲

As much as we love our own culture, we must also acknowledge its flaws and work towards improving them. So, how do we develop cultural confidence? We start by promoting cultural exchange and ...

根据下面的话写70字的感悟：观察产品是提高成品率的前提 我经常长时间待在现场，拿着自己的放大镜全神贯注地查看产品。如果放大镜的倍数还不够用，我就用显微镜观察，有时一看就是一小时。在这样的过程中，我渐渐对产品产生了感情，一旦发现瑕疵，就会不禁在脑中重现实际生产流程，并推测“这孩子（产品）是在哪个环节受伤（出现残缺）的呢？” 如果是高规格的产品，有时良品率只有 10%，甚至 5%。其最具代表性的便是名为 IC (Integrated Circuit，即集成电路）的半导体。IC 是一种微型电子器件，在一块边长仅有两三毫米的方形硅基板上，搭载着数十万个晶体管、二极管等元件。它是制造手机等电子产品时不可或缺的部件。如果用显微镜观察 IC，就能看到上面密密麻麻地排列着晶体管，哪怕只混入微量杂质，也会使 IC 沦为废品。 半导体产业始于美国硅谷，后来在日本逐渐繁荣。这是一场微观世界的“产业战争”。胜负的关键是“能在一枚硅晶片上获得多少个良品”。换言之，这是一场关于成品率的竞争。 起初的良品率可以用“惨淡”来形容，一枚硅晶片只能生产出一到两个良品，因此最初的 IC 价格高昂。但随着行业整体工艺水平的提高，成品率也逐渐上升，等到一枚硅晶片能够生产几千乃至几万个合格品时，IC 的单价也就随之大幅下跌。于是，随着半导体价格的下跌，诸如电视机、收音机等使用半导体部件的电器产品，其价格也变得平民化。 要想提高成品率，首先必须从观察产品做起。在观察的过程中，就能听到产品的声音，从而得知产品“哪里疼”“在哪里受的伤”，进而查明生产流程中的问题环节。 我之所以一直使用“产品的声音”这种拟人的表达方式，并非单纯为了让说明显得生动，而是为了强调认真观察产品的重要性。在实际工作中，我们必须达到这样的心境。

In doing so, he has developed an emotional connection to the products and is motivated to find any flaws. The author notes that the semiconductor industry is a microcosmic example of the competition ...
nasl

devoyBB_flaws.nasl

devoyBB_flaws
nasl

mozilla_multiple_flaws.nasl

mozilla_multiple_flaws
nasl

jrun_multiple_flaws.nasl

jrun_multiple_flaws
nasl

idealbb_multiple_flaws.nasl

idealbb_multiple_flaws
nasl

dnsmasq_multiple_flaws.nasl

dnsmasq_multiple_flaws
pdf

104_XSS_Filter_Evasion_And_WAF_Bypassing.pdf

某国外培训机构的xss bypass思路和教程，Over the years, many security researchers have developed guides and cheat sheets to help security professionals in testing Cross-Site Scripting flaws. The most ...

最新推荐

recommend-type

微信小程序-番茄时钟源码

微信小程序番茄时钟的源码，支持进一步的修改。番茄钟，指的是把工作任务分解成半小时左右，集中精力工作25分钟后休息5分钟，如此视作种一个“番茄”，而“番茄工作法”的流程能使下一个30分钟更有动力。
recommend-type

激光雷达专题研究：迈向高阶智能化关键，前瞻布局把握行业脉搏.pdf

电子元件 电子行业 行业分析 数据分析 数据报告 行业报告
recommend-type

安享智慧理财测试项目Mock服务代码

安享智慧理财测试项目Mock服务代码
recommend-type

课程设计 基于SparkMLlib的ALS算法的电影推荐系统源码+详细文档+全部数据齐全.zip

【资源说明】 课程设计 基于SparkMLlib的ALS算法的电影推荐系统源码+详细文档+全部数据齐全.zip课程设计 基于SparkMLlib的ALS算法的电影推荐系统源码+详细文档+全部数据齐全.zip 【备注】 1、该项目是高分毕业设计项目源码，已获导师指导认可通过，答辩评审分达到95分 2、该资源内项目代码都经过测试运行成功，功能ok的情况下才上传的，请放心下载使用！ 3、本项目适合计算机相关专业(如软件工程、计科、人工智能、通信工程、自动化、电子信息等)的在校学生、老师或者企业员工下载使用，也可作为毕业设计、课程设计、作业、项目初期立项演示等，当然也适合小白学习进阶。 4、如果基础还行，可以在此代码基础上进行修改，以实现其他功能，也可直接用于毕设、课设、作业等。 欢迎下载，沟通交流，互相学习，共同进步！
recommend-type

华中科技大学电信专业 课程资料 作业 代码 实验报告-雷达与信息对抗-内含源码和说明书.zip

华中科技大学电信专业 课程资料 作业 代码 实验报告-雷达与信息对抗-内含源码和说明书.zip
recommend-type

zigbee-cluster-library-specification

最新的zigbee-cluster-library-specification说明文档。
recommend-type

管理建模和仿真的文件

管理Boualem Benatallah引用此版本：布阿利姆·贝纳塔拉。管理建模和仿真。约瑟夫-傅立叶大学-格勒诺布尔第一大学，1996年。法语。NNT：电话：00345357HAL ID：电话：00345357https://theses.hal.science/tel-003453572008年12月9日提交HAL是一个多学科的开放存取档案馆，用于存放和传播科学研究论文，无论它们是否被公开。论文可以来自法国或国外的教学和研究机构，也可以来自公共或私人研究中心。L’archive ouverte pluridisciplinaire
recommend-type

实现实时数据湖架构：Kafka与Hive集成

![实现实时数据湖架构：Kafka与Hive集成](https://img-blog.csdnimg.cn/img_convert/10eb2e6972b3b6086286fc64c0b3ee41.jpeg) # 1. 实时数据湖架构概述** 实时数据湖是一种现代数据管理架构，它允许企业以低延迟的方式收集、存储和处理大量数据。与传统数据仓库不同，实时数据湖不依赖于预先定义的模式，而是采用灵活的架构，可以处理各种数据类型和格式。这种架构为企业提供了以下优势： - **实时洞察：**实时数据湖允许企业访问最新的数据，从而做出更明智的决策。 - **数据民主化：**实时数据湖使各种利益相关者都可
recommend-type

用 Python 画一个可以动的爱心

好的，我可以帮助您使用Python来绘制一个动态的爱心。您可以使用turtle库来实现。以下是实现代码： ```python import turtle import math # 设置画布和画笔 canvas = turtle.Screen() canvas.bgcolor("black") pencil = turtle.Turtle() pencil.speed(0) pencil.color("red", "pink") pencil.pensize(3) # 定义爱心函数 def draw_love(heart_size, x_offset=0, y_offset=0):
recommend-type

JSBSim Reference Manual

JSBSim参考手册，其中包含JSBSim简介，JSBSim配置文件xml的编写语法，编程手册以及一些应用实例等。其中有部分内容还没有写完，估计有生之年很难看到完整版了，但是内容还是很有参考价值的。