Scala读取XML文件中的SQL脚本

test.xml

<?xml version="1.0" encoding="utf-8" ?>
<root>
    <JDDJ>
        SELECT
          channel,
          paid_date,
          order_id,
          store_id
        FROM order_line
        where paid_date = '@paid_date'
        and channel = '@channel'
    </JDDJ>
</root>

 

  def main(args: Array[String]): Unit = {

    val xml = XML.load(this.getClass.getResource("/xmlFile/test.xml"))
    //println(xml)

    val sql = (xml \ "JDDJ").text
      .replaceAll("@paid_date", "2021-03-15")
      .replaceAll("@channel", "JDDJ")
    println(sql)

  }

        SELECT
          channel,
          paid_date,
          order_id,
          store_id
        FROM order_line
        where paid_date = '2021-03-15'
        and channel = 'JDDJ'