// JDBC Example, CreateTable Class
// Source code file CreateTable.java
// Create and populate kids table with
// columns name, gender, age.
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
public class CreateTable {
    public static void main(String[] args) {
        // Define local variables.
        Connection c = null;
        Statement s = null;
        String sql1 = null, sql2 = null;

        try {
            // Define Connection and Statement objects.
            Class.forName("org.sqlite.JDBC");
            c = DriverManager.getConnection(
                "jdbc:sqlite:kids1.db");
            s = c.createStatement();

            // Create kids table.
            sql1 = "create table if not exists " +
                       "kids(name varchar(10), " +
                       "gender varchar(1), " +
                       "age integer);";
            System.out.println("sql1: " + sql1);
            s.executeUpdate(sql1);

            // Populate kids table.
            sql2 = "insert into kids (name, gender, age) " +
                   "values('Alice', 'F', 11);\n" +
                   "insert into kids (name, gender, age) " +
                   "values('Bob', 'M', 10);";
            System.out.println("sql2:" + sql2);
            s.executeUpdate(sql2);

            // Close connection.
            c.close( );
        }
        catch(SQLException e) {
            System.out.println("SQLException.");
            System.err.println( e.getClass( ).getName( ) +
                    ": " + e.getMessage( ) );
        }
        catch (ClassNotFoundException e ) {
            System.err.println( e.getClass( ).getName( ) +
                    ": " + e.getMessage( ));
        }
    }
}