import org.nlogo.api.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class OpenDatabase extends Primitive
{
	public String getAgentClassString() { return "O"; }

	public Syntax getSyntax() {	
        return Syntax.reporterSyntax(
            new int[] {Syntax.TYPE_STRING }
		);
    }

	Class.forName("org.sqlite.JDBC");
	
	Connection connection = null;
	
	public Command newInstance( String name ) 
    {				
        return new OpenDatabse() ;
    }

	public void perform( org.nlogo.api.Argument args[] , org.nlogo.api.Context context  )
        throws org.nlogo.api.ExtensionException , org.nlogo.api.LogoException
		{
			try{
				String dbpath = args[ 0 ].getString() ;
				connection = DriverManager.getConnection("jdbc:sqlite:" + dbpath);
			}
			catch( java.net.MalformedURLException ex )
			{
				throw new org.nlogo.api.ExtensionException
					( "Unable to open database: " + ex.getMessage() ) ;
			}
		}
}


/*******************************************/
C:worksqlite>javac -cp ".;sqlite-jdbc-3.6.11.jar;NetLogo.jar" -d classes src/O
penDatabase.java src/SqlSelect.java src/CloseDatabase.java src/SqliteExtension.j
ava
srcOpenDatabase.java:18: <identifier> expected
        Class.forName("org.sqlite.JDBC");
                     ^
srcOpenDatabase.java:18: illegal start of type
        Class.forName("org.sqlite.JDBC");
                      ^
srcSqlSelect.java:18: <identifier> expected
        Class.forName("org.sqlite.JDBC");
                     ^
srcSqlSelect.java:18: illegal start of type
        Class.forName("org.sqlite.JDBC");
                      ^
srcCloseDatabase.java:17: <identifier> expected
        Class.forName("org.sqlite.JDBC");
                     ^
srcCloseDatabase.java:17: illegal start of type
        Class.forName("org.sqlite.JDBC");
                      ^
6 errors

Add a code snippet to your website: www.paste.org