com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/test root root insert into route (name, length) values (:name, :length) select id, name, length from route; { "routes": { "route": [ { "id": "$id", "name": "$name", "length": "$length(type:integer)" } ] }}