Using the Statement class

[chanshaw]

Hey I'm trying to execute a simple statement but im getting a java.sql.Statement is abstract; cannot be instantiated. I just want to execute a simple select statement

 
import java.sql.Statement;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
 
/**
 * @date February 9, 2009
 * @author Colin Hanshaw
 */
 
public class ProcessChecker 
{
    String parsedString;
    int counter = 0;
    ArrayList parsedStrings = new ArrayList();
    private static String dbURL = "jdbc:derby://localhost:1527/MyDesk;user=administrator;password=password";
    private static String tableName = "BLOCKEDLIST";
    private static Connection conn = null;
    boolean running = true;
    boolean yesno;
 
 
    public static void main(String[] args) throws Exception
    {
        ProcessChecker checker = new ProcessChecker();
    }
 
    public ProcessChecker()
    {
        createConnection();
        while(running)
        {
            listRunningProcesses();
            getBlockedList();
            //compareLists();
        }
    }
 
    public void getBlockedList()
    {
       Statement stmt = new Statement();
    }
 
    private static void createConnection()
    {
        try
        {
            Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
            conn = DriverManager.getConnection(dbURL);
        }
        catch (Exception except)
        {
            except.printStackTrace();
        }
    }
 
    public void listRunningProcesses()
    {
        try
        {
            Runtime runtime = Runtime.getRuntime();
            String cmds[] = {"cmd", "/c", "tasklist"};
            Process proc = runtime.exec(cmds);
            InputStream inputstream = proc.getInputStream();
            InputStreamReader inputstreamreader = new InputStreamReader(inputstream);
            BufferedReader bufferedreader = new BufferedReader(inputstreamreader);
            String line;
            while ((line = bufferedreader.readLine()) != null)
            {
               parsedString = parseString(line);
               parsedStrings.add(new String(parsedString));
               counter++;
            }
            removeElements();
        }
        catch(Exception ex)
        {
            System.out.println("Tasklist might not exist");
        }
    }
 
    public String parseString(String incString)
    {
        String myParsedString = incString;
        String delims = "[ ]+";
        String[] tokens = incString.split(delims);
        myParsedString = tokens[0];
        return myParsedString;
    }
 
    public void removeElements()
    {
        parsedStrings.remove(0);
        parsedStrings.remove(0);
        parsedStrings.remove(0);
    }
}
 

[JosAH]

Read the API documentation: all of the entities in the JDBC framework are interfaces; a Statement (just as a Connection) is an interface and you can't 'new' interfaces. Check the Connection interface; it can create objects that implement the Statement interface for you.

kind regards,

Jos