Addressbook/src/org/mxchange/addressbook/database/backend/mysql/MySqlDatabaseBackend.java

   1 /*
   2  * Copyright (C) 2015 Roland Haeder
   3  *
   4  * This program is free software: you can redistribute it and/or modify
   5  * it under the terms of the GNU General Public License as published by
   6  * the Free Software Foundation, either version 3 of the License, or
   7  * (at your option) any later version.
   8  *
   9  * This program is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details.
  13  *
  14  * You should have received a copy of the GNU General Public License
  15  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
  16  */
  17 package org.mxchange.addressbook.database.backend.mysql;
  18
  19 import java.io.IOException;
  20 import java.sql.Connection;
  21 import java.sql.DriverManager;
  22 import java.sql.SQLException;
  23 import java.text.MessageFormat;
  24 import java.util.Iterator;
  25 import org.mxchange.addressbook.contact.Contact;
  26 import org.mxchange.addressbook.database.backend.BaseDatabaseBackend;
  27 import org.mxchange.addressbook.database.backend.DatabaseBackend;
  28 import org.mxchange.addressbook.database.storage.Storeable;
  29 import org.mxchange.addressbook.exceptions.BadTokenException;
  30 import org.mxchange.addressbook.exceptions.UnsupportedDatabaseDriverException;
  31
  32 /**
  33  * A backend class for MySQL connections
  34  *
  35  * @author Roland Haeder
  36  */
  37 public class MySqlDatabaseBackend extends BaseDatabaseBackend implements DatabaseBackend {
  38         /**
  39          * An instance of a datbase connection
  40          */
  41         private Connection connection;
  42
  43         /**
  44          * Constructor with table name
  45          *
  46          * @param tableName Table to access
  47          * @throws org.mxchange.addressbook.exceptions.UnsupportedDatabaseDriverException
  48          */
  49         public MySqlDatabaseBackend (final String tableName) throws UnsupportedDatabaseDriverException {
  50                 // Validate driver
  51                 this.validateDriver("mysql"); //NOI18N
  52
  53                 // Now that the driver is there, set the table name
  54                 this.setTableName(tableName);
  55         }
  56
  57         @Override
  58         public void connectToDatabase () throws SQLException {
  59                 // Trace message
  60                 this.getLogger().trace("CALLED!");
  61
  62                 // Generate connection string
  63                 String connect = String.format("jdbc:mysql://%s/%s", this.getProperty("org.mxchange.addressbook.database.mysql.host"), this.getProperty("org.mxchange.addressbook.database.mysql.dbname"));
  64
  65                 // Debug message
  66                 this.getLogger().debug(MessageFormat.format("Attempting to connect to {0} ...", connect));
  67
  68                 // Now get a connection instance back
  69                 this.connection = DriverManager.getConnection(connect, this.getProperty("org.mxchange.addressbook.database.mysql.login"), this.getProperty("org.mxchange.addressbook.database.mysql.password"));
  70
  71                 // Trace message
  72                 this.getLogger().trace("EXIT!");
  73         }
  74
  75         @Override
  76         public Iterator<Contact> contactIterator () throws BadTokenException {
  77                 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  78         }
  79
  80         @Override
  81         public void doShutdown () {
  82                 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  83         }
  84
  85         @Override
  86         public long length () {
  87                 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  88         }
  89
  90         @Override
  91         public void rewind () {
  92                 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  93         }
  94
  95         @Override
  96         public void store (final Storeable object) throws IOException {
  97                 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  98         }
  99 }