How to store extracted xml values in a database?

[palanikumark]

Hi friends,
I created this program using JSTL which extract details from xml... Now i want to store that extracted values in a database.. How can i store that extracted values in a database..? Here is my code...

[gogoc]

you first need to create a db and depending upon the db load the driver and then do the proceedings...

[palanikumark]

I created database and i cant able to store my values.... So that only i'm asking.... Here i cant able to show my codings....

[Eranga]

You mean, you don't know how to store values in a DB or your code doesn't work?

[palanikumark]

Ya i dont know how to store my extracted values in a database... My program extracting details from XML file and displaying that extracted details... Now i want to knw how to store that values in a database using JSTL?

[Eranga]

So do a simple DB example first. Then try to implement it in your application.

On the Google you can found lots of such examples. Find one of it and try it. I don't have a sample.

[palanikumark]

Is my code is correct for inserting database... This code does not work and insert data into database...
<?xml version="1.0" encoding="ISO-8859-1"?>
<students>
<student id="1">
<name>
<first>Joe</first>
<last>Y</last>
<middle>T</middle>
</name>
<grade>
<points>99</points>
<letter>A</letter>
</grade>
</student>
<student id="2">
<name>
<first>James</first>
<last>Todd</last>
<middle>K</middle>
</name>
<grade>
<points>92</points>
<letter>B</letter>
</grade>
</student>
<student id="3">
<name>
<first>Kate</first>
<last>Wang</last>
<middle>A</middle>
</name>
<grade>
<points>72</points>
<letter>C</letter>
</grade>
</student>

</students>

JSTL coding

<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:db1" var="db1" />


<c:import var="students" url="students.xml" />

<x:parse var="doc" xml="${students}" />

<x:set var="a" select="$doc/students/student/name/first" />

<x:set var="b"
select="$doc/students/student/name/last" />

<x:set var="c"
select="$doc/students/student/name/middle" />
<sql:update var="query1" dataSource="${db1}" sql="insert into studentDetails values('${a}','${b}')">
</sql:update>
<c:out value="record added"/>
<c:forEach var="row" items="${query1.rowsByIndex}" >
<tr>
<td> <c:out value="${row.first}" /></td>
<td> <c:out value="${row.last}" /></td>
<td> <c:out value="${row.middle}" /></td>
</tr>
</c:forEach>