import java.sql.*;
public class TestDatabaseforbindelseODBC
{
	public static void main(String[] arg) throws Exception
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("jdbc:odbc:datakilde1");
		Statement stmt = con.createStatement();

		stmt.executeUpdate("CREATE TABLE kunder (navn varchar(32), kredit float)" );
		stmt.executeUpdate("INSERT INTO kunder VALUES('Jacob', -1799)");
		stmt.executeUpdate("INSERT INTO kunder (navn,kredit) VALUES('Brian', 0)");
	}
}