@@ -0,0 +1,688 @@
+package connection;%0A%0Aimport java.sql.Connection;%0Aimport java.sql.DriverManager;%0Aimport java.sql.ResultSet;%0Aimport java.sql.SQLException;%0Aimport java.sql.Statement;%0A%0Apublic class DatabaseConnection %7B%0A%09public Connection createConnection() throws Exception%7B%0A%09%09Class.forName(%22sun.jdbc.odbc.JdbcOdbcDriver%22);%0A%09%09Connection con = DriverManager.getConnection(%22jdbc:odbc:invoice%22);%0A%09%09return con;%0A%09%7D%0A%09public void closeConnection(Connection con) throws SQLException%7B%0A%09%09con.close();%0A%09%7D%0A%09public ResultSet selectStatement(Connection con,String sqlStatement) throws SQLException%7B%0A%09%09Statement statement = con.createStatement();%0A%09%09ResultSet rs = statement.executeQuery(sqlStatement);%0A%09%09return rs;%09%09%0A%09%7D%09%0A%7D%0A

Create DatabaseConnection.java