Play framework and scala Convert List<T> for Json String

Question

I`m trying to convert List to Json String, here is my code

  def getProductAsJson(txt:String):String={
                var products=new ListBuffer[Product]()


                 val conn = DB.getConnection()
                 try {
                    val stmt = conn.createStatement
                    val q="SELECT * from m_products where pro_name like '"+txt+"%' "
                    println(q);
                    val rs = stmt.executeQuery(q)
                     while (rs.next()) {
                      products+=Product(Some(rs.getInt("idproduct")),rs.getString("pro_name"),rs.getBigDecimal("pro_retprice"),
                      rs.getString("pro_description"),rs.getString("pro_brand"),rs.getString("pro_type"),rs.getString("pro_sup"),rs.getString("pro_supref"),rs.getBigDecimal("pro_supprice"),rs.getBigDecimal("pro_markup"),Some(rs.getString("pro_imgpath")),rs.getInt("pro_active"));
                    }
                } finally {
                    conn.close()
                }

                println(Json.toJson(products.toList).toString)
                return Json.toJson(products.toList).toString

           }

but i got this error

No Json serializer found for type List[models.Product]. Try to implement an implicit Writes or Format for this type.

If you use Product class only fo creating string, you may construct Json in while loop manualy like creating Product. — andrey.ladniy
– andrey.ladniy, Commented Feb 12, 2016 at 16:11

danielnixon · Accepted Answer · 2016-02-12 05:04:24Z

3

Have you implemented a Writes for your models.Product? If not, add something like this:

import play.api.libs.json._

implicit val productWrites = Json.writes[Product]

Then make sure that implicit productWrites is in scope where you call Json.toJson.

See https://www.playframework.com/documentation/2.4.x/ScalaJsonCombinators#Writes and https://www.playframework.com/documentation/2.4.x/ScalaJsonInception#writes

answered Feb 12, 2016 at 5:04

danielnixon

4,2781 gold badge29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Play framework and scala Convert List<T> for Json String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related