Method exeSql

src/main/java/MySQLHelper.java:87–118

(String sql)

    public boolean exeSql(String sql)
    {
        try {
            if(!conn.isValid(1000))
            {
                if(!init())
                {
                    return false;
                }
            }
            conn.setAutoCommit(true);
            PreparedStatement pst = conn.prepareStatement(sql);// 准备执行语句
            pst.execute();
            pst.close();
            return true;
        } catch (SQLException e)
        {
            StringWriter sw = new StringWriter();
            PrintWriter pw = new PrintWriter(sw);
            e.printStackTrace(pw);
            logger.error(e.toString());
            if(sql.length()>256)
            {
                logger.error(sql.substring(0, 256)+"...");
            }
            else
            {
                logger.error(sql);
            }
        }
        return false;
    }

    public boolean importSql(String filePath)
    {