2 * Copyright (C) 2015 Roland Haeder
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.
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.
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/>.
17 package org.mxchange.addressbook.database.backend.mysql;
19 import java.io.IOException;
20 import java.sql.Connection;
21 import java.sql.DriverManager;
22 import java.sql.SQLException;
23 import java.util.Iterator;
24 import org.mxchange.addressbook.contact.Contact;
25 import org.mxchange.addressbook.database.backend.BaseDatabaseBackend;
26 import org.mxchange.addressbook.database.backend.DatabaseBackend;
27 import org.mxchange.addressbook.database.storage.Storeable;
28 import org.mxchange.addressbook.exceptions.BadTokenException;
29 import org.mxchange.addressbook.exceptions.UnsupportedDatabaseDriverException;
32 * A backend class for MySQL connections
34 * @author Roland Haeder
36 public class MySqlDatabaseBackend extends BaseDatabaseBackend implements DatabaseBackend {
38 * An instance of a datbase connection
40 private Connection connection;
43 * Constructor with table name
45 * @param tableName Table to access
46 * @throws org.mxchange.addressbook.exceptions.UnsupportedDatabaseDriverException
48 public MySqlDatabaseBackend (final String tableName) throws UnsupportedDatabaseDriverException {
50 this.validateDriver("mysql"); //NOI18N
52 // Now that the driver is there ...
56 public void connectToDatabase () throws SQLException {
57 // Generate connection string
58 String connect = "jdbc:mysql://" + this.getProperty("org.mxchange.database.mysql.host") + "/" + this.getTableName();
60 // Now get a connection instance back
61 this.connection = DriverManager.getConnection(connect, this.getProperty("org.mxchange.database.mysql.login"), this.getProperty("org.mxchange.database.mysql.password"));
65 public Iterator<Contact> contactIterator () throws BadTokenException {
66 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
70 public void doShutdown () {
71 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
75 public long length () {
76 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
80 public void rewind () {
81 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
85 public void store (final Storeable object) throws IOException {
86 throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.