Jeg har fundet en anden database con, som jeg har brugt tidligere, hvilken synes du er bedst..
class DBCon
{
private Connection con;
private String path=\"jdbc:
postgresql://192.168.1.60:5432/support\"; private String user = \"eyeq\";
private String password =\"\";
private String driver_til_db = \"org.postgresql.Driver\";
public DBCon()
{
}
public boolean connect()
{
try
{
Class.forName(driver_til_db);
con = DriverManager.getConnection(path,user,password);
con.setAutoCommit(true);
// out.println(\"Er tilsluttet Databasen.\");
return true;
}
catch(ClassNotFoundException e)
{
// out.println(\"FEJL\");
// out.println(\"Kunne ikke finde driveren til databasen. \" + e.getMessage());
return false;
}
catch(SQLException e)
{
//out.println(\"FEJL\");
//out.println(\"SQLException \" + e.getMessage());
return false;
}
catch (Throwable e)
{
//out.println(\"FEJL\");
//out.println(\"Throwable e = \" + e.getMessage());
return false;
}
}
public void luk()
{
try
{
con.close();
//out.println(\"Forbindelsen til databasen er lukket.\");
}
catch(Throwable t)
{
//out.println(\"FEJL i at lukke databasen\");
//out.println(t.getMessage());
}
}
public ResultSet opslag(String SQL)
{
ResultSet resultat;
try
{
Statement St = con.createStatement();
resultat = St.executeQuery(SQL);
}
catch(Throwable t)
{
resultat = null;
}
return resultat;
}
}
eller
class SQLCon
{
private Connection con;
private String path, user, password;
public SQLCon(String pa,String us, String pw)
{
path=pa;
user=us;
password=pw;
}
public boolean connect()
{
try
{
Class.forName(\"org.postgresql.Driver\");
con=DriverManager.getConnection(path, user, password);
con.setAutoCommit(true);
return true;
}
catch(ClassNotFoundException e)
{
return false;
}
catch(SQLException e)
{
return false;
}
catch(Throwable e)
{
return false;
}
}
public boolean execute(String sql)
{
try
{
Statement stm;
stm = con.createStatement();
stm.executeUpdate(sql);
stm.close();
return true;
}
catch(SQLException e)
{
return false;
}
catch(Throwable e)
{
return false;
}
}
public void query(String sql, Vector column, Vector row)
{
try
{
Statement stm;
ResultSet current;
ResultSetMetaData meta;
stm = con.createStatement();
current = stm.executeQuery(sql);
meta = current.getMetaData();
for (int i = 1; i<= meta.getColumnCount(); i++)
column.addElement (meta.getColumnName(i));
if(!current.next())
{
row = null;
}
else
{
do
{
row.addElement(getNextRow(current, meta));
}
while(current.next());
}
stm.close();
}
catch(SQLException e)
{
}
catch (Throwable e)
{
}
}
private Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)
throws SQLException
{
Vector r = new Vector();
for (int i =1; i <= rsmd.getColumnCount(); i++)
switch (rsmd.getColumnType(i))
{
case Types.DATE:
case Types.VARCHAR:
case Types.CHAR:
r.addElement(rs.getString(i)); break;
case Types.SMALLINT:
case Types.BIGINT:
case Types.REAL:
r.addElement(new Long(rs.getLong(i))); break;
case Types.FLOAT:
case Types.DECIMAL:
case Types.NUMERIC:
r.addElement(new Double(rs.getDouble(i))); break;
default:
r.addElement(rs.getString(i)); break;
}
return r;
}
}
Jeg fik det til at virke med DBCon. Der få jeg nemlig er RecordSet tilbage..
/korup
Ny bruger
Nybegynder
Opret
Preview
