C servlet linked with the SQLite library
SELECT COUNT(*) FROM toons (HTML Format):
SELECT rate, name FROM toons (Custom Format):
4, Tom
2, Jerry
6, Bugs Bunny
4, Elmer Fudd
5, Road Runner
9, Coyote
SELECT rate, name FROM toons (TEXT format):
rate name
4 Tom
2 Jerry
6 Bugs Bunny
4 Elmer Fudd
5 Road Runner
9 Coyote
SELECT rate, name FROM toons (HTML format):
rate | name |
---|
4 | Tom |
2 | Jerry |
6 | Bugs Bunny |
4 | Elmer Fudd |
5 | Road Runner |
9 | Coyote |
SELECT rate, name FROM toons (JSON format):
[
{ "rate": "4", "name": "Tom" },
{ "rate": "2", "name": "Jerry" },
{ "rate": "6", "name": "Bugs Bunny" },
{ "rate": "4", "name": "Elmer Fudd" },
{ "rate": "5", "name": "Road Runner" },
{ "rate": "9", "name": "Coyote" }
]
SELECT rate, name FROM toons (XML format):
<Object><Array>
<Object>
<Property><Key>rate</Key> <String>4</String>/Property>
<Property><Key>name</Key> <String>Tom</String>/Property>
</Object>
<Object>
<Property><Key>rate</Key> <String>2</String>/Property>
<Property><Key>name</Key> <String>Jerry</String>/Property>
</Object>
<Object>
<Property><Key>rate</Key> <String>6</String>/Property>
<Property><Key>name</Key> <String>Bugs Bunny</String>/Property>
</Object>
<Object>
<Property><Key>rate</Key> <String>4</String>/Property>
<Property><Key>name</Key> <String>Elmer Fudd</String>/Property>
</Object>
<Object>
<Property><Key>rate</Key> <String>5</String>/Property>
<Property><Key>name</Key> <String>Road Runner</String>/Property>
</Object>
<Object>
<Property><Key>rate</Key> <String>9</String>/Property>
<Property><Key>name</Key> <String>Coyote</String>/Property>
</Object>
</Array></Object>
SELECT rate, name FROM toons WHERE name LIKE 'T%' (PARSING RECORD):
buffer: 'rate,name,
4,Tom,
'
Fields(rate: 4, name: Tom,)
SELECT rate, name FROM toons WHERE rate > 4 (PARSING TABLE):
buffer: '6, Bugs Bunny'
Fields(rate: 6, name: Bugs Bunny)
buffer: '5, Road Runner'
Fields(rate: 5, name: Road Runner)
buffer: '9, Coyote'
Fields(rate: 9, name: Coyote)