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 errorsAdd a code snippet to your website: www.paste.org