/**
* DBFront - DBFrontEnd
*
* @author rogo
*/
import java.util.*;
public class DBFront
{
static String url = "jdbc:odbc:rogo2";
static DBBean bean = new DBBean();
String query;
public DBFront()
{
}
public boolean query()
{
return query(query, url);
}
public boolean query(String query)
{
return query(query, url);
}
public boolean query(String query, String url)
{
this.query = query;
DBFront.url = url;
try
{
if (query != "")
{
bean.setURL(url);
bean.getConnection();
bean.makeQuery(query, 0);
} else
throw new Exception("Empty Query");
} catch (Exception e)
{
return false;
}
return true;
}
public Vector[] getQueryData()
{
Vector[] vecs = null;
try
{
vecs = bean.getQueryData(query, 0);
} catch (Exception e)
{
System.out.println("Error getting queryData " + e);
}
return vecs;
}
public Vector getNextRow()
{
Vector vec = null;
try
{
vec = bean.getNextRow();
} catch (Exception e)
{
System.out.println("Error getting next row " + e);
}
return vec;
}
public Vector getColumnNames()
{
return bean.getColumnNames();
}
public void setURL(String url)
{
DBFront.url = url;
}
public void setQuery(String query)
{
this.query = query;
}
public void setUrlAndQuery(String url, String query)
{
DBFront.url = url;
this.query = query;
}
public void setUserAndPasswd(String user, String passwd)
{
bean.setUserAndPasswd(user, passwd);
}
public void setUser(String user)
{
bean.setUser(user);
}
public void setPasswd(String passwd)
{
bean.setPasswd(passwd);
}
public void setConnection(String url)
{
try
{
bean.setConnection(url);
} catch (Exception e)
{
System.out.println(e);
}
}
public void setConnection(String url,String user,String passwd)
{
try
{
bean.setConnection(url,user,passwd);
} catch (Exception e)
{
System.out.println(e);
}
}
}
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>