[opencms-dev] creating HTML form and submit data to database

[Joe Desbonnet]

I've added this Howto  to my OpenCms Wiki. If anyone has anything to
add/edit please do so (even if it is just links to better tutorials):

http://cms.galway.net:8080/OpenCmsWiki/Wiki.jsp?page=HowtoDbPool

Thanks,

Joe.

On 4/4/06, Joe Desbonnet <jdesbonnet at gmail.com> wrote:
> You can create your own database pool:
>
> 1. Edit opencms.properties and add the following block (and replace
> "mydbpool", "mydbname","mydbuser","mydbpassword" as appropriate). This
> assumes you are using MySQL database.
>
> db.pool.mydbpool.jdbcDriver=org.gjt.mm.mysql.Driver
> db.pool.mydbpool.jdbcUrl=jdbc:mysql://my.db.server.com:3306/mydbname
> db.pool.mydbpool.jdbcUrl.params=
> db.pool.mydbpool.user=mydbuser
> db.pool.mydbpool.password=mydbpassword
> db.pool.mydbpool.poolUrl=opencms:mydbpool
> db.pool.mydbpool.maxActive=25
> db.pool.mydbpool.maxWait=2000
> db.pool.mydbpool.maxIdle=10
> db.pool.mydbpool.testQuery=
> db.pool.mydbpool.whenExhaustedAction=block
> db.pool.mydbpool.testOnBorrow=false
>
> 2. In the same file (opencms.properties) locate key "db.pools" and add your
> pool name (it's a comma separated list)
> eg
> db.pools=default,mydbpool
>
> 3. Restart Opencms/Tomcat. You should now be able to access
> connections from your pool.
>
> Eg using JSP code like this:
>
> <%
> java.sql.Connection connection =
> OpenCms.getSqlManager().getConnection("mydbpool");
> String sql = "SELECT name FROM jhl_department WHERE id=" + deptId;
> ResultSet rs = connection.createStatement().executeQuery(sql);
> ... etc ... etc
>
> rs.close();
> connection.close();
> %>
>
>
> Joe.
>
> On 4/4/06, Zotter Christian <christian.zotter at oepag.at> wrote:
> >
> > Hello to all,
> >
> > I want to include a page with a simple HTML form and submit the data to the
> > a self designed table of the database.
> > Does OpenCms provide classes for accessing the database? Is there a tutorial
> > or documentation existing how to do this?
> > I did not find a useful documentation how to do this best till now.
> >
> > Thanks, Christian (OpenCms beginner)
> >
> >
> >
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please visit
> > http://lists.opencms.org/mailman/listinfo/opencms-dev
> >
> >
>