C servlet linked with the SQLite library


SELECT COUNT(*) FROM toons (HTML Format):

COUNT(*)
6


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):

ratename
4Tom
2Jerry
6Bugs Bunny
4Elmer Fudd
5Road Runner
9Coyote


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)