Make it easy to update/insert database table row based on xml data structure

[niuxuetao]

Suppose there is a table called "OldCars" with columns: "plateNumber","brand", "year", "price" and "mileage". You can directly insert into it:

<sqlDataSource 
        url="jdbc:mysql://localhost/test" 
        username="root" password="xxx"/>
<!-- correlation refers to a column name, if the value in the column is found from any row of the table, the row will be first deleted and inserted with new data -->
<sqlInsert table="OldCars" correlation="plateNumber">
  <params>
    <plateNumber>DEBL117887</plateNumber>
    <brand>BMW</brand>
    <year>2010</year>
    <price>8888</price>
    <mileage>10000</milage>
  </params>
</sqlInsert>

[niuxuetao]

done in r1.8