package com.lebel.sampleapp;

//import android.content.Context;
//import com.ianywhere.ultralitejni12.*;
//import java.sql.Connection;
//import static com.ianywhere.ultralitejni12.DatabaseManager.*;

import android.content.Context;

import com.ianywhere.ultralitejni12.ConfigFileAndroid;
import com.ianywhere.ultralitejni12.Connection;
import com.ianywhere.ultralitejni12.DatabaseManager;
import com.ianywhere.ultralitejni12.ULjException;

import static com.ianywhere.ultralitejni12.DatabaseManager.connect;
import static com.ianywhere.ultralitejni12.DatabaseManager.createConfigurationFileAndroid;

/**
 * Created by Lebel on 11/11/13.
 */

public class Database{
    private static Database _instance = null;
    private static Connection _dbconn;
    private static final int defaultPort = 2639;
    private static final String defaultUsername = "dba";
    private static final String defaultPassword = "sql";
    private static final String db = "lebeldb.udb";
    private static final String LOG_EXCEPTION = "Database Connection Error";
    Context _context;
    private Database(Context context) throws ULjException {

        _context = context;
        if( _dbconn == null ){
            ConfigFileAndroid config;
            config = createConfigurationFileAndroid(db, _context);
            config.setConnectionString("haa");
            config.setUserName(defaultUsername);
            config.setPassword(defaultPassword);
            config.setPageSize(8192);
            try{
                _dbconn = connect(config);
            }
            catch(Exception e) {
                _dbconn = DatabaseManager.createDatabase(config);
            }
    }

    }
    protected static Database getInstance(Context context) throws ULjException {
        if(_instance == null){
            _instance = new Database(context);
        }
        return _instance;
    }
}

package com.lebel.sampleapp;

import android.app.Activity;
import android.content.Context;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListView;

import com.ianywhere.ultralitejni12.*;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by Lebel on 11/11/13.
 */
public class actStaffList extends Activity {
    private List<String> StaffList;
    //private static Context context;
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.lyt_viewstaff);
        //context = this.getApplicationContext();
        try {
            setupViews();
        } catch (ULjException e) {
            e.printStackTrace();
        }
    }

    private void setupViews() throws ULjException {
        try {
            Connection _dbconn = (Connection) Database.getInstance(this.getApplicationContext());
            String qry = "SELECT TOP 10  Test FROM Test";
            PreparedStatement ps = _dbconn.prepareStatement(qry);
            ResultSet rs = ps.executeQuery();
            StaffList = new ArrayList<String>();
            while (rs.next()) {
                //StaffList.add(rs.getInt(1));
                //StaffList.add(rs.getInt(1));
                //StaffList.add(rs.getString(rs.getOrdinal("StaffID")));
                StaffList.add(rs.getString(0));
            }
            rs.close();
            ps.close();
            // Populate listview here
            ListView lv = (ListView) findViewById(R.id.lvStaffList);
            lv.setAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, StaffList));
//        } catch (ULjException e) {
//            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}