Tutorial: Using Metrowerks CodeWarrior and JDBC with Adaptive Server Anywhere 9.0.1 on Mac OS X

Overview

This tutorial helps you create a sample Swing application with Metrowerks CodeWarrior on Mac OS X that queries the contact table from the Adaptive Server Anywhere sample database (asademo.db). The application provides the ability to move through the contact table with a bi-directional cursor and save changes to Street and Zip data.

This document does not attempt to assist you with coding in Java or with JDBC; there are many resources available to assist you with these topics on the web. Instead, this document helps you build a CodeWarrior Java project by putting together the required components within the IDE.

Requirements

• SQL Anywhere Studio 9.0.1 for Mac OS X, or later
• Mac OS X 10.3, or later
• CodeWarrior 8.0 or later
• ODBC Driver Manager

Download the whitepaper here.

Contents

Overview

Requirements

Setting up the ODBC environment

Creating a new project

Creating the user interface

Adding code to the project

Adding the JDBC library to your project

Building and running the application

Appendix A: Connect/Disconnect code

Appendix B: Next ActionPerformed code

Appendix C: Previous ActionPerformed code

Appendix D: Save ActionPerformed code

Appendix E: Code for displaying data

Appendix F: Full code (including generated code)

 Legal Notice

    Contact Us

Download the whitepaper here.

Related Links