How can i execute the sql query with parameter?

Question

val resultList: List[List[String]] =
  sql"""
       select * from exchange_transaction
     """
    .map(
      rs =>
        List(
          rs.string("transaction_id")
        )
    )
    .list()
    .apply()

execute the above code,it is ok but this sql "select * from exchange_transaction" is not fixed. I want this sql like a parameter ,like the follow(shorthand code.....)

def findMemberList(segmentExecuteSql: String
    val resultList: List[List[String]] =
      sql"""
           ＄segmentExecuteSql
         """
        .map(
          rs =>
            List(
              rs.string("transaction_id")
            )
        )
        .list()
        .apply()

but it's error after the execution the message is

[error] s.StatementExecutor$$anon$1 - SQL execution failed (Reason: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''select * from  exchange_transaction'' at line 1
Query is : 
           'select * from  exchange_transaction'
         ):

   'select * from  exchange_transaction'

what should i do ,how to fix the exception?

please click ->http://blog.csdn.net/djqtdj/article/details/53505561 — DJQTDJ, Dec 07 '16 at 06:35

adamwy · Accepted Answer · 2016-12-07T09:06:59.890

0

You can try turning resultList into a function:

import scalikejdbc.SQL

def resultList(sqlQuery: String): List[List[String]] =
  SQL(sqlQuery)
    .map(
      rs =>
        List(
          rs.string("transaction_id")
        )
    )
    .list()
    .apply()

edited Dec 07 '16 at 09:06

answered Dec 06 '16 at 13:18

adamwy

1,239
1
7
12

DBIO[_] not found – DJQTDJ Dec 07 '16 at 01:14
is there any else method？ – DJQTDJ Dec 07 '16 at 05:57
What database library are you using? I assumed that it's from Slick. Also this question doesn't have anything to do with play framework so please update the tags. – adamwy Dec 07 '16 at 08:42
mysql------------------------------ – DJQTDJ Dec 07 '16 at 08:52
That is database which you are using and it's irrelevant for your question. The library that you use might be Slick, Anorm, scalikejdbc etc. – adamwy Dec 07 '16 at 08:55
but I can't update ... I am not a leader and can not make a decision – DJQTDJ Dec 07 '16 at 10:21
please click ->blog.csdn.net/djqtdj/article/details/53505561 – DJQTDJ Dec 07 '16 at 10:26
Maybe just try replacing `sql"""＄segmentExecuteSql"""` with `SQL(segmentExecuteSql)`. – adamwy Dec 07 '16 at 10:39
................ You Don;t Know What I want,Please replace the ＄ to dollar symbol – DJQTDJ Dec 07 '16 at 10:44
so...I want execute a query with parameter.but It parsing( analysis) in a wrong way – DJQTDJ Dec 07 '16 at 10:47
try to execute it – DJQTDJ Dec 07 '16 at 10:49
I don't have access to your database, so I don't think it will work. Do you mean that you want to embed SQL statements inside sql-interpolated strings? – adamwy Dec 07 '16 at 10:58
You can do it with `SQL` like this: `SQL(s"$segmentExecuteSql")`. I'm not sure if scalikejdbc allows embedding SQL statements in interpolated strings. – adamwy Dec 07 '16 at 11:05
do u have skype ? can u guide me ? – DJQTDJ Dec 07 '16 at 11:10
I'm sorry, but I'm not really a scalikejdbc expert. I suggest you ask on scalikejdbc gitter channel: https://gitter.im/scalikejdbc/scalikejdbc – adamwy Dec 07 '16 at 11:14
Just explain your problem and someone will eventually help you. – adamwy Dec 07 '16 at 11:29

score 0 · Answer 2 · answered Dec 08 '16 at 04:17

0

val resultList: List[List[String]] =
  SQL(segmentExecuteSql)
    .map(
      rs =>
        List(
          rs.string("transaction_id")
        )
    )
    .list()
    .apply()

answered Dec 08 '16 at 04:17

DJQTDJ

71
1
9

4

While this code snippet may solve the question, [including an explanation](http://meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. – DimaSan Dec 08 '16 at 09:59
thank you for your comment, my account has been ban.do you know how to get out of a question ban? – DJQTDJ Aug 06 '21 at 04:55
https://meta.stackoverflow.com/questions/255583/what-can-i-do-when-getting-we-are-no-longer-accepting-questions-answers-from-th – DimaSan Aug 06 '21 at 14:57

How can i execute the sql query with parameter?

2 Answers2