Bespin is a Mozilla Labs web application that is extensible web-based framework for code editing that aims to increase developer productivity, enable compelling user experiences, and promote the use of open standards via your browser.

They have a working experimental prototype, that demonstrates some of the concepts of Bespin and the possibilities that it opens up. It supports basic editing features, such as syntax highlighting, large file sizes, undo/redo, previewing files in the browser, importing/exporting projects, etc.

There are different ways to connect to a database via Java. It can be difficult to choose which way is the best. I have been playing allot with the Java Database Connectivity (JDBC) API which is the industry standard for database-independent connectivity between the Java programming language and a wide range of SQL databases and other tabular data sources.

I’m going to establish a connection with a database, send SQL statements and process the results.

(more…)