Listing 18.13 EmployeeCreation.java 

package coreservlets;

import java.sql.*;

/** Make a simple "employees" table using DatabaseUtilities. */

public class EmployeeCreation {

  public static Connection createEmployees(String driver,

                                           String url,

                                           String username,

                                           String password,

                                           boolean close) {

    String format =

      "(id int, firstname varchar(32), lastname varchar(32), " +

      "language varchar(16), salary float)";

    String[] employees =

      {"(1, 'Wye', 'Tukay', 'COBOL', 42500)",

       "(2, 'Britt', 'Tell',   'C++',   62000)",

       "(3, 'Max',  'Manager', 'none',  15500)",

       "(4, 'Polly', 'Morphic', 'Smalltalk', 51500)",

Second edition of this book: www.coreservlets.com; Sequel: www.moreservlets.com.

Servlet and JSP training courses by book's author: courses.coreservlets.com.