封面与文无关,是本人在大学做公交线路查询系统课设所画的路线图,废话不多说,进入正文
在使用like语句时,直接在spl语句中输入 ‘%:[变量名]’ 会报错,如下图
let searchGood = async function searchGood (goodname) {
let conn
try {
conn = await oracledb.getConnection(config)
const result = await conn.execute(
"select gid,image,title,price from goods where title like '%:name%' ",
[goodname]
)
// console.log(1)
// console.log(result.rows[0])
return result
} catch (err) {
console.log(2)
console.log('Ouch!', err)
} finally {
if (conn) { // conn assignment worked, need to close
await conn.close()
}
}
}
百思不得其解,一遍遍控制变量看哪些字符冲突了,查了很多资料都没有解决办法,本人使用的技术栈实在是太冷门了可能,哈哈哈哈哈
最后发现是%和:这两个字符冲突了,遂修改原始变量将%字符嵌入其中,如下图,就没问题了基本
let searchGood = async function searchGood (goodname) {
let conn
let a='%'+goodname+'%'
try {
conn = await oracledb.getConnection(config)
const result = await conn.execute(
"select gid,image,title,price from goods where title like :name ",
[a]
)
// console.log(1)
// console.log(result.rows[0])
return result
} catch (err) {
console.log(2)
console.log('Ouch!', err)
} finally {
if (conn) { // conn assignment worked, need to close
await conn.close()
}
}
}
新人博主,会将开发中遇到的问题记录下来,如有帮助烦劳各位大佬三连支持,谢谢浏览~