Java(TM) Boutique - Accessing a Database with the JSTL 1.1 SQL Tag Library

Listing 1: catalog.jsp

<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<sql:setDataSource  driver="com.mysql.jdbc.Driver"  
url="jdbc:mysql://localhost:3306/test"  user="root"/>


<sql:transaction>
<sql:update   sql="CREATE TABLE Catalog(CatalogId VARCHAR(25) 
PRIMARY KEY, Journal VARCHAR(25), Publisher VARCHAR(25),
 Edition VARCHAR(25), Title Varchar(45), Author Varchar(25))">
</sql:update>

<sql:update  sql="INSERT INTO Catalog VALUES('catalog1', 'ONJava', 
'OReilly', 'Oct 2003', 'BCEL Maven and CSS with Swing', 'Daniel Steinberg')">
</sql:update>

<sql:update   sql="INSERT INTO Catalog VALUES('catalog2', 'ONJava', 
'OReilly', 'July 2004', 'Hibernate: A Developers Notebook', 'James Elliott')">
</sql:update>

<sql:update   sql="INSERT INTO Catalog VALUES('catalog3', 'ONJava', 
'OReilly','Sept 2005','What Is a Portlet', 'Sunil Patil')">
</sql:update>
</sql:transaction>

<%out.println("Database Table Created");%>

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.