This week on JavaWorld.com
For the week of July 2nd
 , July 2007

This week on JavaWorld.com
For the week of June 25th
 , June 2007

Named Parameters for PreparedStatement
PreparedStatement can be cumbersome to use because its parameters are accessed by index. A relatively simple wrapper can be written that lets you set them by name.
Adam Crume, April 2007

The Op Framework: A better Java database framework
The Op Framework is a lightweight, easy-to-configure JDBC access framework that provides rich tracking and tracing functionality. It decouples your code from your database allowing you to capture and load named sets of data from the file system, enabling data-driven test cases.
Paul Feuer, January 2007

Try on Derby for size
Jeff Hanson illustrates how to get started using the Apache Derby database. In this tutorial, he covers installation, use as both an embedded database engine and as a network server, creation and deletion of a database, and more.
Jeff Hanson, September 2006

A Java database framework: Maintaining control of the development environment
This article, written from a database administrator's perspective, discusses the importance of protecting the database. Author Todd Loomis suggests adding a Java database framework that forms a solid, well-tested layer between developers and the database. Using such a database can greatly reduce risk and provide additional tools for tracking and reporting problems.
Todd A. Loomis, September 2006

Design and performance improvements with JDBC 4.0
Java Database Connectivity (JDBC) 4.0 is ready for release by mid 2006 as a part of Java Standard Edition 6.0. How can you leverage the new specification to improve the design and performance of database access and interactions in Java applications? This article discusses the new features of JDBC 4.0, illustrates its solutions to some existing problems, and presents its improvements in design and performance through examples.
Shashank Tiwari, May 2006

J2EE design decisions
In this article, an excerpt from POJOs in Action (Manning Publications, January 2006), Chris Richardson presents five questions developers must ask themselves when designing enterprise applications.
Chris Richardson, January 2006

The power of table-oriented programming
Since the introduction of object-oriented programming languages and three-tier architectures, enterprise application designers have tried to hide the relational database structure deep in the application stack. But this increases the software's complexity and forces developers to spend time making extra and, in most cases, unnecessary layers that do little, except delegate to the layer below. This article introduces Butler, a table-oriented Java component library. Butler has an object model on top of Java Database Connectivity (JDBC), which can be used instead of hand-written SQL statements. Butler also has numerous data-aware Swing components, which releases the burden of writing low-level GUI logics in enterprise client applications.
Fredrik Bertilsson, October 2004

Design a simple service-oriented J2EE application framework
Often, a J2EE Web application framework—Struts, for example—doesn't address the Web-tier object references between Action/servlet and other layers, such as a plain old Java object (POJO) business manager, Enterprise JavaBeans (EJB), Web services, and a data access object (DAO), or between a DAO and JDBC (Java Database Connectivity) stored procedures. Thus, Java developers end up with messy code in the Web tier Action/servlet. This article describes in detail the steps for developing a custom framework that addresses those issues.
Fangjian Wu, October 2004

JDBC scripting, Part 2
JudoScript is a rich functional scripting language, and an easy and powerful general programming and Java scripting language. In Part 1 of this series, I detailed JudoScript's JDBC (Java Database Connectivity) scripting support. JudoScript's power comes from its synergy of functional features such as JDBC scripting, and the strength of programming and Java scripting. It is ideal for modern data processing and other practical uses. JudoScript is designed for all IT professionals and computer programmers, not just Java developers. In Part 2, I concisely introduce JudoScript's programming and Java scripting features, which are all used in a real-world J2EE case study that involves SQL, XML, Enterprise JavaBeans, email, and Web services abstracted as a Java API. The resultant program is short, obvious, and rich in functionality. In the end, I use various criteria to compare JudoScript to other languages.
James Jianbo Huang, July 2004

JDBC scripting, Part 1
JudoScript is an easy and powerful Java scripting language and has 4GL-like domain-specific functional support, allowing users to intuitively specify what they want to do and program algorithmically when necessary. Its multidomain functional support puts JudoScript in a new category of functional scripting languages. Like any 4GL (fourth-generation language), JudoScript emphasizes specifying intentions and providing solutions automatically, while other programming languages (3GLs) emphasize describing solutions (algorithms) that realize the intentions. JudoScript employs a JavaScript-like syntax and programming model and provides more computing power with rich datastructures and syntactic sugar. It is also fully potent in scripting Java, so that all the Java platform resources are readily available. The synergy of all these features renders great power, productivity, and elegance for practical computing needs. Data processing is one of JudoScript's most important applications. Today's enterprise applications deal with rich data formats such as relational databases, XML, SGML (Standard Generalized Markup Language), abstract data types like EJBs (Enterprise JavaBeans), Web services, as well as spreadsheets and flat files. JudoScript is ideal for multiformat, multisource data processing. This two-part series focuses on JudoScript's JDBC (Java Database Connectivity) scripting support, introduces JudoScript the language, and demonstrates its data processing power with a J2EE case study. Part 1 details JudoScript's JDBC scripting support.
James Jianbo Huang, June 2004

Simple classes for JDBC
Just about every J2EE application accesses data from a relational database. For this reason, Java Database Connectivity (JDBC) is probably one of the more popular APIs available for the Java platform. JDBC is conceptually simple and easy to use, but in production applications, numerous details can make even the most trivial create/read/update/delete (CRUD) application a chore. Although many frameworks, tools, and APIs can simplify development, they are often too complex. As an alternative, in this article, author Madhu Siddalingaiah presents a small set of classes that is easy to use, maintain, and extend.
Madhu Siddalingaiah, June 2004

Java Tip 143: Utilize the Database Schema Browser
The Database Schema Browser utility eases the task of database lookup by providing users with a consolidated list of tables and their definitions with one simple hit to the servlet. What's more, you can use the browser's print options to print out a handy database reference. This tip highlights how you can use Java Database Connectivity (JDBC) APIs to create a simple database utility. It's a first step towards building more complex utilities like code generators and SQL browsers.
Saurabh Singh, October 2003

Overcome J2SE 1.3-1.4 incompatibilities
Implementing one of Java's many APIs can be hard work. You must often implement numerous interdependent interfaces. Demand for new features drives the creation of updated Java APIs, and vendors must constantly upgrade their implementations to keep up. While complexity and constant change are understandable and even expected, API version incompatibilities that force you to maintain separate codebases for newer versions can exponentially increase your frustration level. This article demonstrates techniques for overcoming interface version incompatibilities, charting a course for one codebase to compile for multiple API versions.
Sam Mefford, September 2003

All

Free Download - 5 Minute Product Review. When slow equals Off: Manage the complexity of Web applications - Symphoniq

Free Download - 5 Minute Product Review. Realize the benefits of real user monitoring in less than an hour. - Symphoniq

We're hiring Senior Software Consultants! Come work for the fastest-growing Agile consultancy in the mid-Atlantic region! - Stelligent

About Us | Advertise | Contact Us | Terms of Service/Privacy

Copyright, 2006-2008 Network World, Inc. All rights reserved.