001/* 002 * Syncany, www.syncany.org 003 * Copyright (C) 2011-2016 Philipp C. Heckel <philipp.heckel@gmail.com> 004 * 005 * This program is free software: you can redistribute it and/or modify 006 * it under the terms of the GNU General Public License as published by 007 * the Free Software Foundation, either version 3 of the License, or 008 * (at your option) any later version. 009 * 010 * This program is distributed in the hope that it will be useful, 011 * but WITHOUT ANY WARRANTY; without even the implied warranty of 012 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 013 * GNU General Public License for more details. 014 * 015 * You should have received a copy of the GNU General Public License 016 * along with this program. If not, see <http://www.gnu.org/licenses/>. 017 */ 018package org.syncany.database.dao; 019 020import java.io.IOException; 021import java.sql.Connection; 022import java.sql.PreparedStatement; 023import java.sql.SQLException; 024 025import org.syncany.database.DatabaseConnectionFactory; 026import org.syncany.util.SqlRunner; 027 028/** 029 * Small helper class to implement common tasks for the inheriting 030 * SQL data access objects. 031 * 032 * @author Philipp C. Heckel (philipp.heckel@gmail.com) 033 */ 034public abstract class AbstractSqlDao { 035 protected Connection connection; 036 037 public AbstractSqlDao(Connection connection) { 038 this.connection = connection; 039 } 040 041 public Connection getConnection() { 042 return connection; 043 } 044 045 protected PreparedStatement getStatement(String resourceId) throws SQLException { 046 return getStatement(connection, resourceId); 047 } 048 049 protected PreparedStatement getStatement(Connection overrideConnection, String resourceId) throws SQLException { 050 return overrideConnection.prepareStatement(DatabaseConnectionFactory.getStatement(resourceId)); 051 } 052 053 protected void runScript(String resourceId) throws SQLException, IOException { 054 SqlRunner.runScript(connection, DatabaseConnectionFactory.getStatementInputStream(resourceId)); 055 } 056}