package TestScript;
//javac -classpath external.jar com.mycompay/myClass.java
//javac -classpath /Desktop/OSbotetc thisClass.java
//jar cf myJar.jar myClass.class

import org.osbot.rs07.api.ui.Skill;
import org.osbot.rs07.api.Skills;
import org.osbot.rs07.script.Script;
import org.osbot.rs07.script.ScriptManifest;


import org.sqlite.JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;



public class TestScript extends Script {

    public void onStart() {
        log("Starting to Collect");

        this.getSkillLevel();
    }

    public void onExit() {

    }

    public final int onLoop() throws InterruptedException {
        return 0;
    }

    public void getSkillLevel() {
        log(System.getProperty("user.dir"));
        String connString = "jdbc:sqlite:/home/john/Desktop/RSDB/rsdb.sqlite";
        try {
            Connection conn = null;
            Class.forName("org.sqlite.JDBC");
            conn = DriverManager.getConnection(connString);
            log("connection made");
            PreparedStatement stmt = conn.prepareStatement("insert into playertable VALUES (\"testuser\", \"[email protected]\", \"testpass\", \"1111\"");
            log(stmt.execute());
        } catch (Exception e) {
            log(e);
        }
    }
}