The examples used in this chapter assume a SQL table called sales_emps with these columns:

The table definition is:

create table sales_emps
	(name varchar(50), id char(5),
	state char(20), sales decimal (6,2),
	jobcode integer null)

he example class is SQLJExamples, and the methods are:

See “SQLJExamples class” for the text of each method.