import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.Statement;



public class DBFInsert {



    static final String JDBC_DRIVER = "com.hxtt.sql.dbf.DBFDriver";

    static final String INSERT = "insert into so.dbo.ASSIGNED (cassigned_key, cdesc, lactive) values (?, ?, ?)";

    static final Object[] VALUES = new Object[]{"test", "test", 1};



    public static void main(String[] args) throws Exception {

        boolean needInitDatabaseFlag=false;

        if (args.length == 0) {

            args=new String[]{"jdbc:dbf:/d:/test/dbf/issue4?versionNumber=DB2K"};//DB2K to support cassigned_key in free table

            needInitDatabaseFlag=true;

        }

        

        if (args.length != 1) {

            System.err.println("Usage: DBFInsert url");

            System.exit(-1);

        }



        String url = args[0];



        Class.forName(JDBC_DRIVER);



        Connection connection = DriverManager.getConnection(url, "", "");

        

        if(needInitDatabaseFlag){

            Statement s=connection.createStatement();

            s.executeUpdate("create catalog if not exists so;");

            s.executeUpdate("create table if not exists so.ASSIGNED (cassigned_key varchar(12),cdesc varchar(12),lactive int);");

            s.executeUpdate("create index if not exists demotest of ASSIGNED.cdx on so.ASSIGNED  ( cassigned_key for not deleted());");

        }



        System.out.println("Executing sql '" + INSERT + "'");



// This is needed to trigger the NullPointerException

        connection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);



        try (PreparedStatement ps = connection.prepareStatement(INSERT)) {

            ps.setString(1, (String) VALUES[0]);

            ps.setString(2, (String) VALUES[1]);

            ps.setInt(3, ((Number) VALUES[2]).intValue());



            ps.executeUpdate();

        }



        connection.close();



        System.out.println("Done");

    }

}