import java.sql.*;
import java.util.*;
public class DataforbindelseOracle extends Dataforbindelse {
	private Connection forb;
	private Statement stmt;

	public DataforbindelseOracle() throws Exception {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection forb = DriverManager.getConnection(
			"jdbc:oracle:thin:@ora.javabog.dk:1521:student","stuk1001","hemli'");
		stmt = forb.createStatement();
	}

	public void sletAlleData() throws SQLException {
		stmt.execute("truncate table kunder");
	}

	public void indsæt(Kunde k) throws SQLException {
		stmt.executeUpdate(
			"INSERT INTO kunder VALUES('" + k.navn + "', " + k.kredit + ")");
	}

	public List hentAlle() throws SQLException {
		List alle = new ArrayList();
		ResultSet rs = stmt.executeQuery("SELECT navn, kredit FROM kunder");
		while (rs.next())
		{
			Kunde k = new Kunde( rs.getString("navn"), rs.getDouble("kredit"));
			alle.add(k);
		}
		return alle;
	}
}