So far we have looked at all the ways that we can use to display variables in Railo Server. But one of the main attractions of using Railo Server is the really easy way you can access databases.
Railo Server makes it really easy to define and query data stored in any Relational Database Management System (RDBMS) virtually. In this section, we shall go through the setup of a data source to a database, running queries against that database, securing our queries against SQL Injection attacks and even running stored procedures.
One of the main functions that are used in nearly every web application is to show and/or capture data from its users. Railo Server makes this incredibly simple with minimal code so that we can see how these things work together; of course, we need to have a database to connect to.
Railo Server can connect to nearly every single database out there. Out of the box (or rather out of the ZIP) Railo Server can connect to DB2, Firebird, HSSQl (Hipersonic...