SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit different in this version, connectivity is a snap.

To overcome the problems of the above raw SQL approach, you can use JDBC’s (Java Database Connectivity) PreparedStatement interface. PreparedStatement for cross-server portability ...

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Here's a quick JDBC with HSQLDB tutorial to get you up and running with Java database connectivity and the popular HyperSQL database.

How to connect Java to a PostgreSQL database The steps required to connect a Java application to a PostgreSQL database follow the same pattern as other databases such as MySQL, SQLite and Microsoft's ...