import java.sql.*;

public class DatabaseTest1
{
	public static void main(String[] a) throws Exception
	{
		Class.forName("jdbc.SimpleText.SimpleTextDriver");
		Connection connection = DriverManager.getConnection("jdbc:SimpleText");
		Statement statement = connection.createStatement();
		try
		{
			statement.executeUpdate("DROP TABLE table1");
		}
		catch (SQLException e)
		{
			System.out.println("SQL Fehler: "+e);
			System.exit(0);	
		}
		statement.executeUpdate("CREATE TABLE table1(id NUMBER, fname VARCHAR, lname VARCHAR, street VARCHAR, zip VARCHAR, city VARCHAR)");
		statement.executeUpdate("INSERT INTO table1 VALUES(1, 'Thorsten', 'Reimers', 'Sonnenstr.', '85356', 'Freising')");
		statement.executeUpdate("INSERT INTO table1 VALUES(2, 'Albert', 'Einstein', 'Sunny road', 'ZZZZZ', 'Princeton')");
		statement.executeUpdate("INSERT INTO table1 VALUES(3, 'Stirling', 'Moss', 'Waldweg', '7777', 'Stuttgart')");
		statement.close();
		connection.close();
	}
}