Table of Contents

Chapter 1 - DB Visual ARCHITECT SQL

Introduction

Launching DB Visual ARCHITECT SQL

Using the Editor

Creating a new Editor

Editing on the Editor

Configuring Database Connection

Generating SQL Statement and Java Code for Database Manipulation

Generating SQL Statement

Generating SQL Statement upon Selection

Generating Java Code

Generating Java Code upon Selection

Modifying the Name of Database Connection Identifier

Generating Persistence Code for Database Manipulation

Generating Persistence Code for Inserting Record

Generating Persistence Code for Retrieving a Record

Generating Persistence Code for Saving a Record

Generating Persistence Code for Updating a Record

Generating Persistence Code for Deleting Record

Executing SQL Statements and Code

Executing SQL Statements

Showing Execution History

Executing Java Code

Executing Persistence Code

Exporting SQL Statements and Code