com.hust.zsuper.DealWithPatent.Utils.java Source code

Introduction

Here is the source code for com.hust.zsuper.DealWithPatent.Utils.java

Source

/*
 *  Copyright (c) 2013 James Buncle
 * 
 *  Permission is hereby granted, free of charge, to any person obtaining a copy
 *  of this software and associated documentation files (the "Software"), to deal
 *  in the Software without restriction, including without limitation the rights
 *  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 *  copies of the Software, and to permit persons to whom the Software is
 *  furnished to do so, subject to the following conditions:
 * 
 *  The above copyright notice and this permission notice shall be included in
 *  all copies or substantial portions of the Software.
 * 
 *  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 *  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 *  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 *  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 *  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 *  THE SOFTWARE.
 * 
 */
package com.hust.zsuper.DealWithPatent;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author zsuper
 */
public class Utils {

    public static String cleanUp(String str) {
        return str.replaceAll("'", "\\\\'").replaceAll(" ", "");
    }

    public static Connection getConnection(final String host, final int port, final String schema,
            final String user, final String password) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        return DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + schema, user, password);
    }

    public static ExcelType excelTypeToMySql(Cell cell) {
        final FormulaEvaluator evaluator = cell.getRow().getSheet().getWorkbook().getCreationHelper()
                .createFormulaEvaluator();
        switch (cell.getCellType()) {
        case Cell.CELL_TYPE_BLANK:
        case Cell.CELL_TYPE_STRING:
            return ExcelType.STRING;
        case Cell.CELL_TYPE_BOOLEAN:
            return ExcelType.BOOLEAN;
        case Cell.CELL_TYPE_NUMERIC:
            if (DateUtil.isCellDateFormatted(cell)) {
                return ExcelType.DATE;
            } else {
                return ExcelType.NUMERIC;
            }
        default:
            return null;
        }
    }

    public static Workbook createWorkbook(File file) throws IOException {
        if (file.getName().endsWith(".xls")) {
            return new HSSFWorkbook(new FileInputStream(file));
        } else if (file.getName().endsWith(".xlsx")) {
            return new XSSFWorkbook(file.getAbsolutePath());
        }
        return null;
    }

    public static boolean typesContain(List<Map.Entry<String, ExcelType>> types, String str) {
        for (Map.Entry<String, ExcelType> entry : types) {
            if (entry != null && entry.getKey().equals(str)) {
                return true;
            }
        }

        return false;
    }

    public static void executeStatements(final Connection conn, final List<String> statements) throws SQLException {
        for (final String statement : statements) {
            conn.createStatement().execute(statement);
        }
    }

    public static void executeStatements(final Connection conn, final String... statements) throws SQLException {
        for (final String statement : statements) {
            conn.createStatement().execute(statement);
        }
    }
}