Java tutorial
/* * Copyright (c) 2002-2014, Mairie de Paris * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions * are met: * * 1. Redistributions of source code must retain the above copyright notice * and the following disclaimer. * * 2. Redistributions in binary form must reproduce the above copyright notice * and the following disclaimer in the documentation and/or other materials * provided with the distribution. * * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE * POSSIBILITY OF SUCH DAMAGE. * * License 1.0 */ package fr.paris.lutece.plugins.updater.util.sql; import fr.paris.lutece.portal.service.plugin.Plugin; import fr.paris.lutece.portal.service.util.AppLogService; import fr.paris.lutece.util.sql.Transaction; import org.apache.commons.io.FileUtils; import java.io.File; import java.io.IOException; import java.sql.SQLException; import java.util.StringTokenizer; /** * SQL utils */ public final class SqlUtils { /** * Private constructor */ private SqlUtils() { } /** * Executes a SQL script file * @param strFilename The filename * @param plugin The plugin * @throws IOException If an IO exception occurs * @throws SQLException If an SQL exception occurs */ public static void executeSqlFileScript(String strFilename, Plugin plugin) throws IOException, SQLException { try { File file = new File(strFilename); String strScript = FileUtils.readFileToString(file); executeSqlScript(strScript, plugin); } catch (IOException ex) { AppLogService.error("updater - execute SQL script error : " + ex.getMessage(), ex); throw ex; } } /** * Executes an SQL script * @param strScript An SQL script * @param plugin The plugin * @throws SQLException If an SQL exception occurs */ public static void executeSqlScript(String strScript, Plugin plugin) throws SQLException { String strCleanScript = strScript.substring(0, strScript.lastIndexOf(";")); StringTokenizer st = new StringTokenizer(strCleanScript, ";"); Transaction transaction = new Transaction(); try { while (st.hasMoreTokens()) { String strSQL = st.nextToken(); transaction.prepareStatement(strSQL); transaction.executeStatement(); } transaction.commit(); } catch (SQLException ex) { transaction.rollback(ex); AppLogService.error("Execute SQL script error : " + ex.getMessage() + " - transaction rolled back.", ex); throw ex; } } }