import java.sql.*;


public class DBConnection {

    Connection dbConnection;


private void loadDriver(){//TRY LOADING SUN DRIVER
      try {//LOAD SUN DRIVER
          Class driver = org.apache.derby.jdbc.ClientDriver.class;
          System.out.println("Class=" + driver.getSimpleName());
        Class.forName ("org.apache.derby.jdbc.ClientDriver");
      }//END try
      //DRIVER NOT FOUND, REPORT ERROR
      catch (ClassNotFoundException err){
        System.out.println("Could not load driver ");
        System.exit(1);
      }//END catch
    }//END loadDriver()

public void connectDatabase (final String dbName) {
    try{
        //CONNECT TO DATABASE

        loadDriver();

//Connection dbConnection;

dbConnection =
 DriverManager.getConnection("jdbc:derby://localhost:1527/" + dbName, "alumni", "alumni");

//DriverManager.getConnection"jdbc:derby://localhost:1527/" + dbName, "username", "password");
    }// END try
    catch (SQLException error)
    {
       System.err.println("Error connecting to database: "
                                        +error.toString());
    }//ENDCATCH
    }

public void closeConnection(){
        try{
            if (null != dbConnection && !dbConnection.isClosed())
            {
                dbConnection.close();
            }
        }
        catch (SQLException sqle)
        {
            System.out.println("Error closing connection: " + sqle.toString());
        }

    }

public void insertRecord(final String position1, final String position2, final String position3, final String position4, final String position5, final String position6, final String position7, final String position8, final String position9, final String position10, final String position11, final String position12, final String position13) {
final String insertStmt = "INSERT INTO ALUMNI.CONTACTS position1, position2, position3, position4, position5, position6, position7, position8, position9, position10, position11, position12, position13) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,)";
try {
    PreparedStatement pstmt = dbConnection.prepareStatement(insertStmt);
    pstmt.setString(1, position1);
    pstmt.setString(2, position2);
    pstmt.setString(3, position3);
    pstmt.setString(4, position4);
    pstmt.setString(5, position5);
    pstmt.setString(6, position6);
    pstmt.setString(7, position7);
    pstmt.setString(8, position8);
    pstmt.setString(9, position9);
    pstmt.setString(10, position10);
    pstmt.setString(11, position11);
    pstmt.setString(12, position12);
    pstmt.setString(13, position13);
    pstmt.executeUpdate();
} catch (SQLException sqle){
    System.out.println("EXCEPTION WHEN INSERTING ALUMNI RECORD; " + sqle.toString());
}
}
}