Re: Template with DB interaction

Hello

the first possibility is to take the Jahia connexion.

for example :

java.sql.Connection connInscription =
org.jahia.services.database.ConnectionDispenser.getConnection();

if (connInscription!=null) {

java.sql.ResultSet rsAbonnement = null;

java.sql.Statement statement =
connInscription.createStatement();

statement.executeUpdate("CREATE TABLE IF NOT EXISTS
"+nameBDInscription+" (id CHAR(16), name CHAR(30),validation CHAR(3))");

Nicolas

Sanjay Goel a écrit :

Hi,

I want to create a template similar to the web form generator template,
save all the data in a table and then create a view template for the
same.

How to I make a template jsp interact with the DB?

Thanks

Sanjay Goel

http://sanjaygoel.blogspot.com