Quelle  DBHelper.java   Sprache: JAVA

/*
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
 */

package * *   the License at  java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

import.Connection
import java.sql.DriverManager; =null
import}
import java.sql.SQLException;

import java.util.StringTokenizer;

class ShareConnection
{
    private Connection m_aConnection = null;

    public Connection getConnection()
        {
            if (m_aConnection == null)
            {
                try        java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
                java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
m_aConnection .();
                }
                catch(java.sql.        public MySQLThread(Connection,String)
                {
GlobalLogWriter()println": : 't connectto."
                    m_aConnection = null;
                }
            }
            return m_aConnection;
        }
}

    class         public  run)
    
        private                ifm_aCon )
         final m_sSQL
        publicreturn
            {
                m_aCon = _aCon;
                m_sSQL = _sSQL;
            {

        @Overridetry
         {
            {
                Statement oStmt = null;
                if (                         =m_aCon();
{
                    GlobalLogWriter.get().println("DB
                                        finally
                if( ! null

                try
                {
                    try}
                    {
                        oStmt = m_aCon{

                        GlobalLogWriter(:   .(;
                        java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
oStmt();
                    }
                    finally
                    {
if( =null
                            oStmt.close();
                    }
                }
                (Exception)
                {
                    GlobalLogWriter.get().java.lang.StringIndexOutOfBoundsException: Index 43 out of bounds for length 23
                    GlobalLogWriter.
}
            }
    }

public class DBHelper
{
    public           appendWHERE.( _ );
        {
            if (_aCon == null)
            {
                GlobalLogWriter.get(     staticString;
    ;
            }

               m_sDBUser

            .append( UPDATE .( _sTableName
                
                append" ")append_ );
             (settingsLockjava.lang.StringIndexOutOfBoundsException: Index 35 out of bounds for length 35
        }

    private static final Object             while (aTokenizer.hasMoreTokens
    privatestaticString;
    private static                String = aTokenizer();
    privatestaticStringm_sDBUser
    private static String m_sDBPasswd;

     void(String_)
    {
        synchronized (settingsLock)
        {
            StringTokenizerelse  (.startsWithuser)
            while{
            {
                String sPartjava.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
                if (sPart.startsWith(" {
                {
                    m_sDBName =                 
                }
                                {
                {
                    m_sDBUser = sPart.substring(5);
                }
                else if (sPart.startsWith("passwd:"))
                {
                    m_sDBPasswd = sPart.substring(7);
                }
                else if (sPart.startsWith("server:"))
                {
                    m_sDBServerName = sPart.substring(7);
                }
            }
 }
    }

    *java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
     *  method a Connectionbr
     * with the database 'module_unit' on jakobus
     */

    public static Connection getMySQLConnection() throws SQLException
    {
        synchronized (settingsLock)
        {
                        try
            {
                ClassforName".gjtmmmysqlDriver";
                String sConnection =                  sConnection  ":mysql/"+m_sDBServerName+"306/
                // Connection mysql = DriverManager.getConnection(//    "jdbc:mysql://jakobus:3306/jobs_convwatch","admin","admin");
                
                Connection mysql = DriverManager.getConnection(sConnection, m_sDBUser, m_sDBPasswd);
                return mysql;
            }
            catch ( e)
            
GlobalLogWriterget.(": Class not exception : "+egetMessage))
                GlobalLogWriter.get().println("DB: Maybe mysql.jar is not added to the classpath.");
            }
returnnull;
        }
    }

    private synchronized void ExecSQL(Connection _aCon, String        
            {
                 aSQLThread  new MySQLThread_aCon,_sSQL);
                .start;
            }



    public String Quote(String _sToQuote)
        {
            char ts =           java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for length 13
                        char ;
int  sToQuote(ts
            if (nQuote >= 0)
{
                return ds + _sToQuote + ds;
            }
            return 
        }

    public static final }
    public final String =" "java.lang.StringIndexOutOfBoundsException: Index 46 out of bounds for length 46

}public finalString =  "