org.liveSense.api.sql.SQLExecute.class Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of org.liveSense.service.dataSourceProvider Show documentation
Show all versions of org.liveSense.service.dataSourceProvider Show documentation
Simple DBCP pooled datasource provider.
The newest version!
???? 2?
+? *? *? *? *??
? *? *? *?/ *? *??
? *? *? *? *??
? *? *? ?? ?? ??
????
???
??
?
?
?
? ???
(? ???
+? ???
.? ???
1??
??
?
*?
*?
*
q
*
*
E?
E
q
E , ? q ?
R
S
*
! *"
*# ,$
*%&
*'
()
?*+,
c-./01
g2
f3
e4
5
*6
*7 ,8
*9:
*;
<=
>
(?
(@AB
x?CD
xEF G HI JK JLMNO
x?PQ ,R
*S
*T
*UVWXYZ[
c\ ,]
*^
*_
*`
*ab ,c
*d
*e
*f
gh
(i
Ijkl
??m
?no ,p
*q
*r ?s tu tv tw
?x y qz{
x? qI
x*
x| }~
?? ??
*?
E??
?????
??
??
??
?
??
+?
(?
(? ? q?
(?
*?
z ?
*?
*? ? ?I? ?? ??
S
R ??
*?
*?
*?
*??
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*?
*??
???
???
??
??
???
??
??
??
???
?
???
????
??? ??
??
?? ?? ???
*?
*?
(???
??? ?? ?? *?
<?
*? ?? ???
*??
*?1 ?????????
StatementType InnerClasses BLOBNAMES [Ljava/lang/String; ,THIS_TYPE_OF_JDBC_DIALECT_IS_NOT_IMPLEMENTED Ljava/lang/String;
ConstantValue? %CLASS_DOES_NOT_HAVE_ENTITY_ANNOTATION !CLASS_DOES_NOT_HAVE_ID_ANNOTATION ENTITY_IS_NULL ENTITY_TYPE_MISMATCH COLUMN_NAME_IS_UNDEFINED COLUMN_DEFINITION_IS_UNDEFINED WRONG_PREPARED_STATEMENT THE_STATEMENT_IS_NOT_PREPARED clazz Ljava/lang/Class; preparedStatementType 0Lorg/liveSense/api/sql/SQLExecute$StatementType; preparedStatementClass preparedConnection Ljava/sql/Connection; preparedNPP /Lorg/liveSense/api/sql/NamedParameterProcessor; preparedNamedParameters Ljava/util/List; Signature $Ljava/util/List; preparedSQLParametersCount I preparedFields Ljava/util/ArrayList; )Ljava/util/ArrayList; preparedSQL preparedStatement Ljava/sql/PreparedStatement; preparedProcedureOutputParams Ljava/util/Map; 6Ljava/util/Map; lastNamedParameters 5Ljava/util/Map; lastSQLParameters )Ljava/util/ArrayList; builder .Lorg/liveSense/misc/queryBuilder/QueryBuilder; toSQLStringEvent 2Lorg/liveSense/misc/queryBuilder/ToSQLStringEvent; mapResultSetHandler -Lorg/apache/commons/dbutils/ResultSetHandler; eLorg/apache/commons/dbutils/ResultSetHandler;>;>; ()V Code LineNumberTable LocalVariableTable this "Lorg/liveSense/api/sql/SQLExecute; LocalVariableTypeTable 'Lorg/liveSense/api/sql/SQLExecute; getClazz ()Ljava/lang/Class; getPreparedStatementType 2()Lorg/liveSense/api/sql/SQLExecute$StatementType; getPreparedStatementClass getPreparedConnection ()Ljava/sql/Connection; getPreparedNamedParameters ()Ljava/util/List; &()Ljava/util/List; getPreparedSQLParametersCount ()I getPreparedFields ()Ljava/util/ArrayList; +()Ljava/util/ArrayList; getPreparedSQL ()Ljava/lang/String; getPreparedStatement ()Ljava/sql/PreparedStatement; getPreparedProcedureOutputParams ()Ljava/util/Map; 8()Ljava/util/Map; getLastNamedParameters 7()Ljava/util/Map; getLastSQLParameters +()Ljava/util/ArrayList; getJdbcDriverByConnection O(Ljava/sql/Connection;)Lorg/liveSense/misc/queryBuilder/jdbcDriver/JdbcDrivers; metaData Ljava/sql/DatabaseMetaData; msg e /Lorg/liveSense/api/sql/exceptions/SQLException; conn
StackMapTable?
Exceptions getExecuterByJdbcDriver \(Lorg/liveSense/misc/queryBuilder/jdbcDriver/JdbcDrivers;)Lorg/liveSense/api/sql/SQLExecute; driver 8Lorg/liveSense/misc/queryBuilder/jdbcDriver/JdbcDrivers; executer %Lorg/liveSense/api/sql/SQLExecute<*>;? _(Lorg/liveSense/misc/queryBuilder/jdbcDriver/JdbcDrivers;)Lorg/liveSense/api/sql/SQLExecute<*>; getExecuterByConnection 9(Ljava/sql/Connection;)Lorg/liveSense/api/sql/SQLExecute; <(Ljava/sql/Connection;)Lorg/liveSense/api/sql/SQLExecute<*>; J(Ljava/sql/Connection;Ljava/lang/Class;)Lorg/liveSense/api/sql/SQLExecute; Ljava/lang/Exception;?&? M(Ljava/sql/Connection;Ljava/lang/Class;)Lorg/liveSense/api/sql/SQLExecute<*>; addWhereClause J(Lorg/liveSense/api/sql/ClauseHelper;)Lorg/liveSense/api/sql/ClauseHelper;? addLimitClause addOrderByClause getSelectQuery %(Ljava/lang/Class;)Ljava/lang/String; 7(Ljava/lang/Class;Ljava/lang/String;)Ljava/lang/String; getLockQuery getBlobName clearPrepare clearLastStatement checkPrepare D(Lorg/liveSense/api/sql/SQLExecute$StatementType;Ljava/lang/Class;)V type prepare {(Lorg/liveSense/api/sql/SQLExecute$StatementType;Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;)V
statementType
connection sql fields
localClass ?(Lorg/liveSense/api/sql/SQLExecute$StatementType;Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;)V preparedStatementSetObject (ILjava/lang/Object;)V valueD Ljava/sql/Date; idx value Ljava/lang/Object; prepareQueryStatement F(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)V W(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)V i(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)V
tableAlias localTableAliasM (Ljava/sql/Connection;)V )(Ljava/sql/Connection;Ljava/lang/Class;)V idColumn prepareLockStatement prepareInsertStatement <(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;)V list 9(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;)V
columnName i$ Ljava/util/Iterator;
annotationMap tableName sb Ljava/lang/StringBuffer; sb2 first Z 5Ljava/util/Map;?:B? M(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;)V prepareUpdateStatement J(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V condition 2Lorg/liveSense/misc/queryBuilder/domains/Operator; J(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V 2Lorg/liveSense/misc/queryBuilder/domains/Criteria; [(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V [(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V n(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V n(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V k(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V (Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V k(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V (Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V }(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V }(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V columns tableAlias2 1Lorg/liveSense/api/sql/SimpleBeanSQLQueryBuilder;, ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V prepareDeleteStatement m(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V m(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V prepareInsertSelectStatement ?(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Ljava/lang/Class;Ljava/lang/String;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V insertClass insertFields selectClass selectFields selectCondition list1 list2??? ?(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Ljava/lang/Class;Ljava/lang/String;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Criteria;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V localClassInsert localClassSelect insertTableName selectTableName
insertColumns insert
selectColumns select?? ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V j(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)V g(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)V? {(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)V prepareExecuteProcedure *(Ljava/sql/Connection;Ljava/lang/String;)V paramName paramType Ljava/lang/Integer; procName procedureOutputParams inParamNames
outParamTypes out in rs Ljava/sql/ResultSet; %Ljava/util/List;? "queryEntitiesWithPreparedStatement !(Ljava/util/Map;)Ljava/util/List; params paramValues run (Lorg/apache/commons/dbutils/QueryRunner; rh queryParams [Ljava/lang/Object; $Ljava/util/List; DLorg/apache/commons/dbutils/ResultSetHandler;>;??, L(Ljava/util/Map;)Ljava/util/List; queryEntityWithPreparedStatement &(Ljava/lang/Object;)Ljava/lang/Object; entity map TT; Ljava/util/List;? (TT;)TT; !lockEntitiesWithPreparedStatement lockEntityWithPreparedStatement !insertEntityWithPreparedStatement (Ljava/lang/Object;)V param field objs (TT;)V #updateEntitiesWithPreparedStatement $(Ljava/lang/Object;Ljava/util/Map;)V key object ;(TT;Ljava/util/Map;)V !updateEntityWithPreparedStatement #deleteEntitiesWithPreparedStatement (Ljava/util/Map;)V 8(Ljava/util/Map;)V !deleteEntityWithPreparedStatement !insertSelectWithPreparedStatement %executeProcedureWithPreparedStatement (Ljava/util/Map;)Ljava/util/Map; Ljava/util/Date; entry Entry Ljava/util/Map$Entry; ;? l(Ljava/util/Map;)Ljava/util/Map;
queryEntities U(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; Z(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; d(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; ?(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; f(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; k(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; u(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; ?(Ljava/sql/Connection;Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; x(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; }(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; queryEntity ;(Ljava/sql/Connection;Ljava/lang/Object;)Ljava/lang/Object; beans (Ljava/sql/Connection;TT;)TT; lockEntities
lockEntity insertEntity *(Ljava/sql/Connection;Ljava/lang/Object;)V (Ljava/sql/Connection;TT;)V :(Ljava/sql/Connection;Ljava/lang/Object;Ljava/util/List;)V ?(Ljava/sql/Connection;TT;Ljava/util/List;)V updateEntities l(Ljava/sql/Connection;Ljava/lang/Object;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V q(Ljava/sql/Connection;TT;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V o(Ljava/sql/Connection;Ljava/lang/Object;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V `(Ljava/sql/Connection;TT;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V ?(Ljava/sql/Connection;Ljava/lang/Object;Ljava/lang/String;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V r(Ljava/sql/Connection;TT;Ljava/lang/String;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V ~(Ljava/sql/Connection;Ljava/lang/Object;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V ?(Ljava/sql/Connection;TT;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;)V ?(Ljava/sql/Connection;Ljava/lang/Object;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V ?(Ljava/sql/Connection;TT;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V updateEntity =(Ljava/sql/Connection;Ljava/lang/Object;[Ljava/lang/String;)V .(Ljava/sql/Connection;TT;[Ljava/lang/String;)V deleteEntities |(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V deleteEntity insertSelect ?(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Ljava/lang/Class;Ljava/lang/String;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V ?(Ljava/sql/Connection;Ljava/lang/Class;[Ljava/lang/String;Ljava/lang/Class;Ljava/lang/String;[Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V ?(Ljava/sql/Connection;Ljava/lang/Class;Ljava/util/List;Ljava/lang/Class;Ljava/lang/String;Ljava/util/List;Lorg/liveSense/misc/queryBuilder/domains/Operator;Ljava/util/Map;)V executeProcedure G(Ljava/sql/Connection;Ljava/lang/String;Ljava/util/Map;)Ljava/util/Map; res ?(Ljava/sql/Connection;Ljava/lang/String;Ljava/util/Map;)Ljava/util/Map;
executeScript &(Ljava/sql/Connection;Ljava/io/File;)V Ljava/io/File; 8(Ljava/sql/Connection;Ljava/io/File;Ljava/lang/String;)V section J(Ljava/sql/Connection;Ljava/io/File;Ljava/lang/String;Ljava/lang/String;)V use fr Ljava/io/FileReader; br Ljava/io/BufferedReader; Ljava/io/IOException; j tInt tStr i Ljava/sql/SQLException; inst st Ljava/sql/Statement; si separator s
actSection stmts?????? queryEntitiesAsMap {(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List;>; g(Ljava/sql/Connection;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List; ?(Ljava/sql/Connection;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;)Ljava/util/List;>; ?(Ljava/sql/Connection;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List;>; v(Ljava/sql/Connection;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List; sqlParams ?(Ljava/sql/Connection;Ljava/lang/String;Lorg/liveSense/misc/queryBuilder/QueryBuilder;Ljava/util/Map;)Ljava/util/List;>; createTable colDef annotations "[Ljava/lang/annotation/Annotation; id Ljavax/persistence/Id; col Ljavax/persistence/Column; fld Ljava/lang/reflect/Field;
firstField stm +Ljava/util/List;???? dropTable existsTable (Ljava/sql/Connection;)Z )(Ljava/sql/Connection;Ljava/lang/Class;)Z dbm tables? (Ljava/lang/Object;
SourceFile SQLExecute.java ab @A B? CD EF java/util/ArrayList GH KL MN P3 QR java/util/HashMap ST VT XN \] "org/liveSense/api/sql/SQLExecute$1 a? ^_ >?? ?? ??? z @Cannot determinate JDBC Driver by name. Connection is not alive. java/lang/Exception a -org/liveSense/api/sql/exceptions/SQLException java/lang/StringBuilder #Failed to create registry database. z z a
? "org/liveSense/api/sql/MySqlExecute a ? #org/liveSense/api/sql/HSqlDbExecute
? %org/liveSense/api/sql/FirebirdExecute ? #org/liveSense/api/sql/OracleExecute .This type of JDBC dialect is not implemented: z a ?? ?? ?? )Could not get SqlExecuter by connection: z a 9Could not get SqlExecuter by connection, executer is null b? The statement is not prepared Wrong prepared statement. Entity class type mismatch ?b ?b -org/liveSense/api/sql/NamedParameterProcessor ~ z A u !u java/util/Date
java/sql/Date "# a$ %? ??? jk &z Z[ ?? 'A ?? java/lang/Class ??( )? *u 7Entity does not contain javax.persistence.Id annotation /org/liveSense/api/sql/SimpleBeanSQLQueryBuilder a+ 5org/liveSense/misc/queryBuilder/operators/AndOperator 7org/liveSense/misc/queryBuilder/criterias/EqualCriteria 7org/liveSense/misc/queryBuilder/operands/DefaultOperand : a, a- a> ./ ?? ?? 0A ?? java/util/List ??1 23 a4 56 7? \Class does not contain javax.persistence.Entity or javax.persistence.Entity.Table annotation java/lang/StringBuffer INSERT INTO ( 8 ( 9:; <=? >? ?@ java/lang/String , ? ) VALUES ) AA ?? ?? ?? . UPDATE SET = ? WHERE BC DA ?? ?? ?? ?? DELETE FROM EA ?? ? ??F GH IJ 5org/liveSense/misc/queryBuilder/SimpleSQLQueryBuilder SELECT FROM * KL
MA ? ?? NO? ?? PQ RS TU VW XY EXECUTE PROCEDURE Z[ \J java/lang/Integer java/sql/CallableStatement ]u ^_ ?? `% &org/apache/commons/dbutils/QueryRunner 3org/apache/commons/dbutils/handlers/BeanListHandler ,org/apache/commons/dbutils/BasicRowProcessor 8org/liveSense/api/beanprocessors/DbStandardBeanProcessor aa ab cd ef gk hi )j k4 kl mi ?? n? CD IJ op java/util/Map$Entry q@ rl s@ W\ W^ Wb $% Entity is null h\ h^ hb ;% jm => ov ox zm }? }? }~ ?? MJ NO ?? ; java/io/FileReader at java/io/BufferedReader au vz wz @ xH yS zH {b java/io/IOException a| }~ BEGIN TRANSACTION ? END TRANSACTION
END TRANSACTION ?? COMMIT ?? ?Y ?z ?b? ?? java/sql/SQLException ?? ?? ??
CREATE TABLE java/lang/reflect/Field ?? javax/persistence/Column javax/persistence/Id Column name is undefined ?z Column definition is undefined 01 ?? ?z ?? NOT NULL ?? UNIQUE PRIMARY KEY ?? DROP TABLE ?? ?? BLOB CLOB LONGTEXT LONGVARCHAR org/liveSense/api/sql/SQLExecute java/lang/Object .org/liveSense/api/sql/SQLExecute$StatementType ,This type of JDBC dialect is not implemented java/sql/Connection @org/liveSense/misc/queryBuilder/exceptions/QueryBuilderException
java/util/Map java/util/Iterator java/lang/IllegalAccessException +java/lang/reflect/InvocationTargetException java/lang/NoSuchMethodException 0org/liveSense/misc/queryBuilder/domains/Operator ,org/liveSense/misc/queryBuilder/QueryBuilder java/sql/ResultSet +org/apache/commons/dbutils/ResultSetHandler java/io/File java/sql/Statement java/sql/DatabaseMetaData %(Lorg/liveSense/api/sql/SQLExecute;)V isClosed ()Z getMetaData ()Ljava/sql/DatabaseMetaData; getDatabaseProductName 6org/liveSense/misc/queryBuilder/jdbcDriver/JdbcDrivers "getJdbcDriverByMetaDataProductName L(Ljava/lang/String;)Lorg/liveSense/misc/queryBuilder/jdbcDriver/JdbcDrivers; (Ljava/lang/String;)V append -(Ljava/lang/String;)Ljava/lang/StringBuilder;
getMessage toString *(Ljava/lang/String;Ljava/lang/Throwable;)V MYSQL (I)V HSQLDB FIREBIRD ORACLE name clear
getParameters keySet ()Ljava/util/Set; addAll (Ljava/util/Collection;)Z getSqlStatement PROCEDURE prepareCall 0(Ljava/lang/String;)Ljava/sql/CallableStatement; size prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; java/sql/PreparedStatement getParameterMetaData ()Ljava/sql/ParameterMetaData; java/sql/ParameterMetaData getParameterCount getTime ()J (J)V setObject
getTableAlias SELECT &org/liveSense/api/sql/AnnotationHelper getIdColumnName length (Ljava/lang/Class;)V ((Ljava/lang/String;Ljava/lang/Object;Z)V '(Ljava/lang/String;Ljava/lang/Object;)V setWhere 5(Lorg/liveSense/misc/queryBuilder/domains/Operator;)V LOCK java/util/Arrays asList %([Ljava/lang/Object;)Ljava/util/List; (Ljava/util/Collection;)V getAnnotationMap 3(Ljava/lang/Class;Ljava/util/List;Z)Ljava/util/Map; getTableName ,(Ljava/lang/String;)Ljava/lang/StringBuffer; values ()Ljava/util/Collection; java/util/Collection iterator ()Ljava/util/Iterator; hasNext next ()Ljava/lang/Object; INSERT
buildWhere W(Ljava/lang/Class;Lorg/liveSense/misc/queryBuilder/domains/Operator;)Ljava/lang/String; UPDATE DELETE #org/apache/commons/lang/StringUtils isEmpty (Ljava/lang/String;)Z getClassColumnNames 9(Ljava/lang/Class;Ljava/util/List;Z)Ljava/util/ArrayList; replace D(Ljava/lang/CharSequence;Ljava/lang/CharSequence;)Ljava/lang/String;
INSERT_SELECT getProcedureColumns ^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; getInt (I)I getString (I)Ljava/lang/String; valueOf (I)Ljava/lang/Integer; put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; add (Ljava/lang/Object;)Z deleteCharAt (I)Ljava/lang/StringBuffer; putAll intValue registerOutParameter (II)V getSQLParameters -(Lorg/apache/commons/dbutils/BeanProcessor;)V =(Ljava/lang/Class;Lorg/apache/commons/dbutils/RowProcessor;)V toArray ()[Ljava/lang/Object; query {(Ljava/sql/Connection;Ljava/lang/String;Lorg/apache/commons/dbutils/ResultSetHandler;[Ljava/lang/Object;)Ljava/lang/Object; getClass getObjectAsMap #(Ljava/lang/Object;)Ljava/util/Map; &(Ljava/lang/Object;)Ljava/lang/String; get (I)Ljava/lang/Object; getObjectAsMap2 execute entrySet
java/util/Set getValue getObject getKey (Ljava/io/File;)V (Ljava/io/Reader;)V readLine trim
startsWith substring equalsIgnoreCase close (Ljava/lang/Throwable;)V split '(Ljava/lang/String;)[Ljava/lang/String; contains (Ljava/lang/CharSequence;)Z
replaceAll 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; createStatement ()Ljava/sql/Statement; equals toUpperCase commit
executeUpdate (Ljava/lang/String;)I getAllFields #(Ljava/lang/Class;)Ljava/util/List; getAnnotations $()[Ljava/lang/annotation/Annotation; columnDefinition binarySearch (([Ljava/lang/Object;Ljava/lang/Object;)I nullable unique getTables _(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet;!*+ 01 23 4 5 63 4 w 73 4 b 83 4 ? 93 4 B :3 4 ;3 4 <3 4 A =3 4 @ >? @A B? CD EF GH I J KL MN I O P3 QR ST I U VT I W XN I Y Z[ \] ^_ I ` ? ab c ? q*? *? *? *? *? *? Y? ? *? *? Y? ?
* ? *?
*? Y? ? *? Y? ? *? Y? ? *? *? Y*? ? ? d > 5 P Q S T U # V ( W 3 X 9 Y > Z I \ T ] _ ` d?e qfg h qfi jk c A *? ? d fe fg h fi lm c A *? ? d he fg h fi nk c A *? ? d je fg h fi op c A *? ? d ke fg h fi qr c A *? ? d le fg h fi I s tu c A *? ? d me fg h fi vw c A *?
? d ne fg h fi I x yz c A *? ? d oe fg h fi {| c A *?
? d pe fg h fi }~ c A *? ? d qe fg h fi I ?~ c A *? ? d se fg h fi I ? ?w c A *? ? d te fg h fi I ? ?? c ? L*? *? ? *? L+? ? ? L? Y+? ?L? Y? !"? #+? $? #? %M? Y,+? &? * * * d " |
} ~ ? ! ? * ? + ? B ?e 4
?? ! ?3 B
?3 + !?? L?D ? K?? ?? c ? nL*? '? ? (Y? )L? Z*? *? ? +Y? ,L? G*? -? ? .Y? /L? 4*? 0? ? 1Y? 2L? !? Y? Y? !3? #*? 4? #? %? 5?+? d ? ? ? ( ? ; ? N ? l ?e n?? l?g h l?? ? ? ? ? I ? ?? c 0 *? 6? d ?e ?D ? I ? ?? c ? GM*? 7N-? 8M? #N? Y? Y? !9? #-? :? #? %-? ;?,? ,+? ?
? Y? E?g h E?? ? ? ??? ? ? I ??? ? ??? ? ??? ? ??? ? ??? ? ??? ? ??? ? ??z ?b c ? >*? *? *? *? *? ? = *? *?
? >* ? *?
*? ? ? ? d . h i
j k l m "n )o /p 4q =re >fg h >fi ?b c U *? ? ? *? ? >? d v w xe fg h fi ?? c ? M*? ? *? ? *? ?
*?
?
? Y@? 5?*? +?
? YA? 5?,*? ?
? YB? 5?? d ~ ? (? 0? :? B? L?e Mfg M?A M>? h Mfi ? ? ?? c ? ?*? C*? D-:? *? :*+? *? *,? *? EY? F? *? *? ? G? H ? I W?
*?
? JW**? ? K? *? ? L? !*,*? ? M ?
**? ? N ? ? #*,*? ? O ?
**?
? P ? Q ? ? d J ? ? ? ? ? ? !? &? 3? I? N? X? c? m? {? ?? ?? ??e H ?fg ??A ??D ?>? ??3 ??H ??? h ?fi ??J ?
? ?? A2 ? I ? ?? c ? $,? R? ? SY,? R? T? UN-M*?
,? V ? d ? ? ? ? #?e * ?? $fg $?L $?? h $fi ? ? ?? c ^
*+ ,? W? d
? ?e
fg
?D
Z[ h
fi ? ?? c h
*+, -? W? d
? ?e *
fg
?D
>?
Z[ h
fi ? ?? c P,:? *? :?
? X:-:?
? Y:? :*? Z*? [:*? \+? ]? d 2 ? ? ? ? ? "? )? .? 2? 8? B? O?e R Pfg P?D P>? P?3 PZ[ M?? 3?3 B ?3 h Pfi ? ? ? ? ?? ?? c T
*+? ^? _? d
? ?e
fg
?D h
fi ? ?? c p,N-? *? N-? `:? ? a?
? Yb? 5?? cY-? d:? eY? fY? gY ? Y? !h? #? #? %? i? j? k? l*+- ? W? d & ? ? ( 2 e o e > pfg p?D p>? n?? _?3 2 >Z[ h pfi ? ? ?? ? ? ?? c ^
*+ ,? m? d
e
fg
?D
Z[ h
fi ? ?? c h
*+, -? m? d
% &e *
fg
?D
>?
Z[ h
fi ? ?? c P,:? *? :?
? X:-:?
? Y:? :*? Z*? n:*? o+? ]? d 2 1 2 3 5 6 "7 )8 .9 2; 8< B> O?e R Pfg P?D P>? P?3 PZ[ M?? 3?3 B ?3 h Pfi ? ? ? ? ?? ?? c T
*+? ^? p? d
L Me
fg
?D h
fi ? ?? c p,N-? *? N-? `:? ? a?
? Yb? 5?? cY-? d:? eY? fY? gY ? Y? !h? #? #? %? i? j? k? l*+- ? m? d & X Y [ \ ] (` 2a ec ode > pfg p?D p>? n?? _?3 2 >Z[ h pfi ? ? ?? ? ? ?? c X *+? ^? q? r? d
t
ue fg ?D h fi ? ?? c _ *+,? q? r? d
?
?e fg ?D >? h fi ? ?? c ? ? Y-? s? t:*+,? r? d ?
? ?e 4 fg ?D >? ?1
?H h fi
?J ? ?? c e ,:? *? :*? Z-? u:? v:? ? a?
? Yw? 5?? xY? y:? xY? y:? Y? !z? #? #{? #? %? |W}? |W6 ? ~ ? :
? ? ? =
? ? ? ?: ? ?? |W?? |W? 6 ? |W?? |W???? Y? !? ?? #?? #? ?? #?? #? %:
*? ?+
? Y? H ? t? ]? d R ? ? ? ? ? #? 0? :? C? L? k? s? v? ?? ?? ?? ?? ?? ???e ?
? +?3 ? D??
fg ?D >? ?H ?? ??T # ??3 C ??? L ??? v ??? ? ?3
h fi ?J ??? ? B ? ?? !?? ? I ?????????? ? -?? ? I ? ?? c \ *+,? ?? d
? ?e fg ?D ?? h fi ? ?? c c *+? eY,? k? ?? d
? ?e fg ?D ?? h fi ? ?? c j *+,? q-? ?? d
? ?e * fg ?D >? ?? h fi ? ?? c q *+,? q? eY-? k? ?? d
? ?e * fg ?D >? ?? h fi ? ?? c ? ? Y-? s? t:*+,? ?? d ?
? ?e > fg ?D >? ?1 ??
?H h fi
?J ? ?? c ? ? Y-? s? t:*+,? eY? k? ?? d
e > fg ?D >? ?1 ??
?H h fi
?J ? ?? c ~ *+, -? ?? d
e 4 fg ?D >? ?H ?? h fi ?J ? I ? ?? c ? *+, -? eY? k? ?? d
e 4 fg ?D >? ?H ?? h fi ?J ? I ? ?? c ? *+,-? eY? k? ?? d
( )e > fg ?D >? ?3 ?H ?? h fi ?J ? I ? ?? c ? <,:? *? :*? Z? u:? v:? ? a?
? Yw? 5?-: ? a? ? Y? ! ? #?? #? %: ? xY? y:
? Y? !?? #? #?? #-? #?? #? %? |W6 ? ~ ? : ? ? ? D ? ? ? ?:
?
?? |W? 6
? Y? ! ? #
? #?? #? %? |W???? cY? d: ? $
? Y? !?? # ? ?? #? %? |W
? ?:
*? ?+
? Y? H ? t? ]? d ^ 4 5 7 9 : $; 1< ;? >@ FA \C eD ?E ?F ?G ?H ?I ?J ?K ?LN!P;Qe ? ? 2?3
? K?? <fg <?D <>? <?3 <?H <?? 9?? ?T $?3 > ??3 e ???
? ??? ? HZ? ! ?3
h <fi <?J ?? ? 2 ? ?? "?? ? ?? A??? %?? !? 0?? I ? ?? c T
*+? ^? ?? d
^ _e
fg
?D h
fi ? ?? c _ *+,? q? ?? d
j
ke fg ?D >? h fi ? ?? c ? ? Y-? s? t:*+,? ?? d v
w xe 4 fg ?D >? ?1
?H h fi
?J ? ?? c
g,:? *? :? `:? ? a?
? Yb? 5?? eY? fY? gY ? Y? !h? #? #? %? i? j? k:*+-? ?? d " ? ? ? ? "? ,? \? f?e H gfg g?D g>? g?H d?? R?3 \ ?? h gfi g?J ? ? ?? ? ? I ? ?? c \ *+,? ?? d
? ?e fg ?D ?? h fi ? ?? c c *+? eY,? k? ?? d
? ?e fg ?D ?? h fi ? ?? c h
*+, -? ?? d
? ?e *
fg
?D
>?
?? h
fi ? ?? c o *+, ? eY-? k? ?? d
? ?e * fg ?D >? ?? h fi ? ?? c y *+,-? eY? k? ?? d
? ?e 4 fg ?D >? ?3 ?? h fi ? ?? c ?
?,:? *? :*? Z? v:? ? a?
? Yw? 5?? xY? y:? Y? !?? #? #?? #-? #?? #? %? |W? cY? d:? $? Y? !?? #? ?? #? %? |W? ?: *? ?+ ? ]? d : ? ? ? ? ? '? 1? :? b? m? r? ?? ?? ??e f
?fg ??D ?>? ??3 ??? ??? ??3 : n?? m ;Z? ? ?3 h ?fi ? ? ?? ? ? a??? ?? c T
*+? ^? ?? d
? ?e
fg
?D h
fi ? ?? c
a,N-? *? N-? `:? ? a?
? Yb? 5?? eY? fY? gY ? Y? !h? #? #? %? i? j? k:*+-? ?? d "
( X `e > afg a?D a>? _?? P?3 X ?? h afi ? ? ?? ? ? ?? c ?
,? Y-? s? t:? Y? s? t: *+, ? ?? d ,
- / +0e f
,fg ,?D ,?? ,?1 ,?? ,?3 ,?1 ,??
?H ?H h ,fi
?J ?J ? ? ? ? c ?
*+,-? eY? k? ?? d
F Ge R fg ?D ?? ?1 ?? ?3 ?1 ?? h fi ? ? ? ? c ?
*+,-? eY? k? ?? d
T Ue R fg ?D ?? ?H ?? ?3 ?H ?? h fi ?J ?J ? ? ?I ? c 6 ?,:? *? :: ? *? : *? Z? v:
? ??
? Yw? 5? ? v: ? ??
? Yw? 5?-? ?: ? xY? y:
? Y? !z? #
? #{? #? %? |W6 ? ?:? ? ? -? ? ? ?:?
?? |W? 6
? |W???
?? |W
? ?:: ? ? Y? !? #?? #? %: ? ?:? xY? y:
6? ?:? ? ? ?? ? ? ?:?
?? |W? 6
? Y? !? #? #? %? |W???*? ?Y? Y? !?? #
? ?? #?? # ? #? %? ?? Z? *? Z? l* ? [?
? ?? ?:? Y? !? #?? #? #? %:*? ?+? ]? d ? * c d f g i "k )l 1m ;o Bp Jq Tu ]v fw ?x ?y ?z ?{ ?} ?~ ? ?? ?? ?? ?? ?? ?? ??? ?&?+?6?9?S?V?????????????e ? ? ?3 ? 4?? & -?3 F?? ?fg ??D ??? ??H ??? ??3 ??H ??? ?? ?? )?3
B? 3 ]o
N ff??
?D?? ? ? 3 ? ??3 ? ? N ? (
3 ?
?3 h 4 ?fi ??J ??J ]o
O ? ? O ? v ? ?? ?? ?? ?? : ????????????? ? %??
? /??? ?? %?? 9? ? ?I ? c ? ? Y-? s? t:*+,? ?? d ?
? ?e > fg ?D ?? ?1 Z[
?H h fi
?J ? ? ? ? c N
?,:? *? :*? Z? v:? ??
? Yw? 5?-? ?:? xY? y:? Y? !z? #? #{? #? %? |W6 ? ?:
? ? ? -
? ? ? ?: ? ?? |W? 6 ? |W????? |W? ?:
*? ?: ? Y? !
? #?? # ? #? %: *? ?+ ? ]? d Z ? ? ? ? ? #? -? 6? ?? ^? a? ~? ?? ?? ?? ?? ?? ?? ?? ?? ?? ??e ? ~ ?3 h 4??
?fg ??D ??? ??H ?Z[ ?? ?3 6 ?
N ? ??? a y?? ? / 3
? (
3 ?
?3 h ?fi ??J 6 ?
O ? > ? ?? ?? : ???????? ? %??
? ? ?I c 3
?*? Z? Y? N? Y? :? Y? :66+? ,? ? :? ? ? t? ? ? ? ? ? .-? ? ? ?? ? W? ? ? ?? ? W?? ? ? ? ? ???? ? ? ? W????? xY? Y? !?? #,? #? %? ?: ? N ? a }? |W? ? :
? ? ? 1
? ? ? ?: ? Y? !h? # ? #?? #? %? |W??? ? ?d? ?W ?? |W ? ?:
*? L+
? ]*? -? ? 6? ? : ? ? ? ( ? ? ? ?: *?
? ? ? ?? ? ???Ա d ? ? ?
? ? ? "? %? 6? @? X? l? ?? ?? ?? ?? ?? ?? ?? ? ? -5<H
R U
t???e ? ? 3 ? 8??
t ^ /?? ?fg ??D ?3
?T x H o H "l L %i L 6X ! ? ??? < R?3
h * ?fi
?U x J o " ? =
? 6 ??????# !*? 6??? 7? (??? .? $% c N |*? D*? \*? ? ?*? +? ?M+?
*? +? ? *? ,? JW? ?Y? ?N? ?Y*? ? ?Y? ?Y? · ÷ ?::*? ? ř *? ? ?:-*? *? ? ?? q? d 2 ! " $ % & &' /) 7* R, U- _. h0e > |fg |&T d'H 7 E() R **_ U '+, h * |fi |&W d'- R **. ? ? &?? A/01? I 2 34 c
?*? D*? \+? ȷ ?? Y? M+? ?N+? ?:,-? ? ? ? W*? ,? ?:,?
*? ,? ? *? ? JW? ?Y? ?:? ?Y*? ? ?Y? ?Y? · ÷ ?::*? ? ř *? ? ?:*? *? ? ?? q: ? N ? ? ? ? ? d N > ? A B C "D 3F =G AH KI UK ^L yN |O ?P ?R ?S ?T ?Ve f
?fg ?5? ?&T ?6T " ??3 = }'H ^ \() y A*_ | >+, ? ?H h H ?fi ?57 ?&W ?6W = }'- y A*. ? ?8 ? - ? K ?9???? ? C/01? !?? ? I : ;% c N |*? D*? o*? ? ?*? +? ?M+?
*? +? ? *? ,? JW? ?Y? ?N? ?Y*? ? ?Y? ?Y? · ÷ ?::*? ? ř *? ? ?:-*? *? ? ?? q? d 2 g h j k l &m /o 7p Rr Us _t hve > |fg |&T d'H 7 E() R **_ U '+, h * |fi |&W d'- R **. ? ? &?? A/01? I 2 <4 c
?*? D*? o+? ȷ ?? Y? M+? ?N+? ?:,-? ? ? ? W*? ,? ?:,?
*? ,? ? *? ? JW? ?Y? ?:? ?Y*? ? ?Y? ?Y? · ÷ ?::*? ? ř *? ? ?:*? *? ? ?? q: ? N ? ? ? ? ? d N ? ? ? ? ? "? 3? =? A? K? U? ^? y? |? ?? ?? ?? ?? ??e f
?fg ?5? ?&T ?6T " ??3 = }'H ^ \() y A*_ | >+, ? ?H h H ?fi ?57 ?&W ?6W = }'- y A*. ? ?8 ? - ? K ?9???? ? C/01? !?? ? I : => c . a*? D*? ?+? ȷ ?+? ?M>*?
? ?:? ? ? 0? ? ? ?:,? ? :* ? ?*? ? ?W????*?
? ? W? d 2 ? ? ? ? ? 5? ?? F? P? S? V? `?e H ? ?? 5 @3 7?? afg a5? MAT K?L h afi a57 MAW ? ? ??? 6? I B CD c ? ?*? D*? ?+? ȷ ?*? ,? ?N,?
*? ,? ? +? ?:6*?
? ?:? ? ? 2? ? ? ?:? ? :*? ?*? ? ?W????-? ? :? ? ? ? ? :*? ΄???*? -? JW*?
? ? W? d R ? ? ? ? ? &? ,? /? N? Y? a? k? n? q? ?? ?? ?? ?? ?? ??e p Y ?? N E3 8 9?? ? F? y !?? ?fg ?5? ?&T ?'H , ?AT / ?L h 4 ?fi ?57 ?&W ?'- , ?AW ? ? &?? ??? 8? ?? ? I G H> c ? ?+? ?M,?
,? a?
? Yb? 5?? Y? N+? ?:-,,? ? ? ? W*+-? ѱ d " ? ? ? ? "? (? 8? >?e 4 ?fg ?5? :?3 " &T ( 6T h * ?fi ?57 " &W ( 6W ? ? ? ? I B IJ c . d*? D*? ?*? ? ?*? +? ?M+?
*? +? ? *? ,? JW>,? ? :? ? ? ? ? :* ? ΄???*?
? ? W? d 6
& / 1 L
S V Y ce > L
?? 9 ?? dfg d&T L'H 1 3?L h dfi d&W L'- ? ? &?? ?? ? I K L> c ? >+? ?M,?
,? a?
? Yb? 5?? Y? N+? ?:-,,? ? ? ? W*-? ұ d " " (! 8# =$e 4 >fg >5? 9?3 " &T ( 6T h * >fi >57 " &W ( 6W ? ? ? ? I B MJ c . d*? D*? ?*? ? ?*? +? ?M+?
*? +? ? *? ,? JW>,? ? :? ? ? ? ? :* ? ΄???*?
? ? W? d 6
1 2 4 5 6 &7 /9 1: L; S< V= Y? c@e > L
F? 9 ?? dfg d&T L'H 1 3?L h dfi d&W L'- ? ? &?? ?? ? I K NO c ' ?*? D*? L*? ? ?*? +? ?M+?
*? +? ? *? ,? JW>*? ? ?:? ? ? ? ? :* ? ΄???*?
? ? W? Y? :*? ? ? ? ? :? ? ? [? ? ? ?:*?
? ?? ? ? ?? ?? ? :? S? ? RY? S? ط ?::? ? ? ? W???? d V H I K L M &N /P 1Q MR TS WT ZV dX mY ?Z ?[ ?\ ?] ?_ ?` ?be p M
?? : ?? ? ?P ? .?? ? IQS } b?? ?fg ?&T ?'H 1 ??L m u T h 4 ? IQT ?fi ?&W ?'- m u W ? ' ? &?? ?? ? "??? MU9? ? I V WX c [ *+? ^,? ۰ d te fg ?D Z[ h fi ? I Y WZ c p *+? ^,-? ܰ d ?e * fg ?D Z[ &T h fi &W ? I [ W\ c e *+, -? ݰ d ?e * fg ?D >? Z[ h fi ? I ] W^ c z *+, -? ݰ d ?e 4 fg ?D >? Z[ &T h fi &W ? I _ W` c o *+,-? ݰ d ?e 4 fg ?D >? ?3 Z[ h fi ? I a Wb c ? *? D*+,-? W*? ?:? d ? ?
? ?e H fg ?D >? ?3 Z[ &T ?H h fi &W ?8 ? I c de c \ ~,?
? Y߷ 5?,? ?N-?
-? a?
? Yb? 5?,? ?:? cY,? ȷ d:? eY? fY--? ? ? j? k? l*+,? ?? ?:*? Z? N ? ?? ? ? d 2 ? ? ? ? (? .? ;? W? d? i? s? u?e H ~fg ~?D ~5? k?3 . PAT ; CZ[ d fH h * ~fi ~57 . PAW d f8 ? ? ? ? L??? I g hX c [ *+? ^,? ? d ?e fg ?D Z[ h fi ? I Y hZ c p *+? ^,-? ? d ?e * fg ?D Z[ &T h fi &W ? I [ h\ c e *+, -? ? d ?e * fg ?D >? Z[ h fi ? I ] h^ c z *+, -? ? d
e 4 fg ?D >? Z[ &T h fi &W ? I _ h` c o *+,-? ? d e 4 fg ?D >? ?3 Z[ h fi ? I a hb c ? *? D*+,-? m*? ?:? d " #
$ &e H fg ?D >? ?3 Z[ &T ?H h fi &W ?8 ? I c ie c \ ~,?
? Y߷ 5?,? ?N-?
-? a?
? Yb? 5?,? ?:? cY,? ȷ d:? eY? fY--? ? ? j? k? l*+,? ?? ?:*? Z? N ? ?? ? ? d 2 5 6 7 8 (: .< ;= W? dA iC sD uFe H ~fg ~?D ~5? k?3 . PAT ; CZ[ d fH h * ~fi ~57 . PAW d f8 ? ? ? ? L??? I g jk c f *+,? ? d
V We fg ?D 5? h fi 57 ? I l jm c ? *? D*+,? ?-? r*,? ? d a b c de * fg ?D 5? ?H h fi 57 ?J ? I n op c ? *+, -? ? d
v we 4 fg ?D 5? ?H ?? h fi 57 ?J ? I q or c ? ? Y-? s? t:*+, ? ? d ?
? ?e > fg ?D 5? ?1 ??
?H h fi 57
?J ? I s ot c ? ? Y? s? t:*+,-? ? d ? ? ?e H fg ?D 5? ?3 ?1 ?? ?H h fi 57 ?J ? I u ov c ?
*+,-? ? d
? ?e >
fg
?D
5?
?3
?H
?? h
fi
57
?J ? I w ox c ? *? D*+,? ?-? ?*,? ѱ d ? ? ? ?e H fg ?D 5? ?3 ?H ?? &T h * fi 57 ?J &W ? I y zk c i *+,? q? ? d
?
?e fg ?D 5? h fi 57 ? I l z{ c ? ? Y-? s? t:*+,? ? d ?
? ?e 4 fg ?D 5? ?1
?H h fi 57
?J ? I | zm c X,?
? Y߷ 5?,? ?:? ? a?
? Yb? 5?,? ?:? eY? fY? ? ? j? k:*+, -? ? d " ? ? ? !? +? 1? L? W?e H Xfg X?D X5? X?H D?3 1 'AT L ?? h * Xfi X57 X?J 1 'AW ?
? ? ? I n }? c \ *+,? ? d
? ?e fg ?D ?? h fi ? }? c h
*+, -? ? d
? ?e *
fg
?D
>?
?? h
fi ? }? c s *+,-? ? d
?
?e 4 fg ?D >? ?3 ?? h fi ? }~ c ? *? D*+,-? ?*? ұ d
e > fg ?D >? ?3 ?? &T h fi &W ? I ?k c S,?
? Y߷ 5?,? ?N-?
-? a?
? Yb? 5?,? ?:? eY? fY--? ? ? j? k:*+,? ?? ? d " ( . G R e > Sfg S?D S5? @?3 . %AT G ?? h Sfi S57 . %AW ?
? ? ? I l ?? c ? .? Y-? s? t: ? Y? s? t:
*+,
? ? d 8
9 ; -<e p .fg .?D .?? .?1 .?? .?3 .?1 .?? .&T
!?H ?H
h * .fi .&W
!?J ?J
? I ? ?? c ? *? D*+,-? ?*? ?? d K L M Ne \ fg ?D ?? ?H ?? ?3 ?H ?? &T h * fi ?J ?J &W ? I ? ?? c ? *+,? ?*-? ?:? d U V
Xe 4 fg ?D 3 &T
?T h fi &W
?W ? I ? ?? c ] *+,? ? d
g he fg ?D ?? h fi ? ?? c h
*+,-? ? d
r se *
fg
?D
??
?3 h
fi ? ?? c H
m? ?Y? ?:? xY? y::? ?Y,? ?:? ?Y? ?: ? ?Y:? _? ??? ?? ? ?? ?:???6
-? 6
-? ? -? ?? 6
? ? Y? !? #?? #? %? |W??? ? ?? :? Y? ??:? ? ?? :? ? ?Y? ?S:6 ?? ? 2?? ? 6
??
2?? ?
??? Y? ! ]2? #? #? %S `6
? 6? Y? ! ]2? #?? # 2? #? #? %S ?S? ??ɻ Y? ! ]2? #? #? %S
2? : ??
2S?
S
d6 ? ??(6 ?? $ 2 ??S? ???6 ?? ?:
? 2? :
? ? ?Y 2S:
+? : 6
?? C
2? ? ?? -
2? ?? ? ?? +?
?
2? W? ???? : ? Y ? ??? ??n? ? ? ?WZ d ? ; } ~ ? ? ? *? 5? B? P? S? Z? l? o? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ??? ?)?O?V?\?v???????????????????????????? ??'?;?D?Q?W?Z?\?f?l?e ? S ;??
w?? * l?? ?
?? " :?L ? ??L
? ?1 ? ??L ? )?L H?L \
?? ? ??1
Z?? ? ??L mfg m?D m?? m?3 m?3 d?3 [?? X?3 ???1 h mfi ? ? ? *
?????????? %? ? ? ???????? ? ? $
? ? ? ? 9? 8$? ? ? ? (? ? $
?
?4 ? ? ????????$$ ?? ? ? ?X c Z
*+ ,?
? d +e
fg
?D
Z[ h
fi ? I ? ?? c c *+,-?
? d /e * fg ?D ?3 Z[ h fi ? I ? ?Z c n
*+ ,-?
? d 3e *
fg
?D
Z[
&T h
fi
&W ? I ? ?? c B v*? D*? C*-? Z? ?Y? ?:* ,? [:*? EY? F? **? ? K? *? *? ? ?? JW:*? ? ř *? ? ?:+*? ? K*? ? ?? q? d 2 9 : ;
? A C - D 8 E I G L H V I _ Ke R vfg v?D v?3 vZ[ v&T `() V?3 L *?, h vfi v&W ? ? _/?1? I ? ?? c Q *+?? d
Z [e fg ?D h fi ? ?? c ?*? D*? C*? Z,N-? *? N-? v:? ? a?
? Yw? 5?-?:? xY? y:? Y? !? #? #{? #? %? |W6? ? :? ? ?3? ? ?: ?:
: : 6
?? 6
2??
2?: ?
2??
2?: ?
??? ? ?? 6? ?? |W ? ? ? ? a? ? Y? 5? ? ? ? ?? ? Y? 5? ? ? |W ? :
?
? ?? *?:
? Y? !?? #
? #? %? |W ? ? ? |W ? ? ? |W ? ? |W????? |W? ?:*? EY? F? **? ? K? +*? ? O : ? ? W+?
? d ? . e f g
i j l m + n 5 q ; r D s d u g v ? w ? x ? y ? { ? | ? } ? ~ ? ? { ? ? ? ? ? ? ?/ ?< ?E ?S ?Y ?s ?} ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?e ? ? ;?L
E b?3
???
??? ??? ?!?? p:?? ?fg ??D ?>? ??? ??3 ;??H D??? g??? ? 3?3 ? ?R h ?fi ;??? ? ? ? ?? ? ? : ???????? ? % ???????????? ?
? )?,?
???????? ? ? ?? c Q *+?!? d
? ?e fg ?D h fi ? ?? c j ?*? D*? C*? Z,N-? *? N-? v:? ? a?
? Yw? 5?? xY? y:? Y? !"? #? #? %? |W? ?:*? EY? F? **? ? K? +*? ? O :? ? W+?
? d F ? ? ?
? ? ? ? + ? 5 ? > ? Y ? ` ? m ? x ? ? ? ? ? ? ?e R ?fg ??D ?>? ??? u?3 > U?? ` 3?3 ? ?R h ?fi ? ? ?? ? ? ?? c M *+?#? d ?e fg ?D h fi ? ?? c , f*? D*? C*? Z,N-? *? N-? v:? ? a?
? Yw? 5?+? :? ?? ?? ?$?% :? ?? ? ? d 6
? ? ?
? ? ? ? + ? 5 ? = ? W ? \ ? ^ ?e H ffg f?D f>? W?? H?3 = )?? W ?! h ffi ? ? ?? ? ? (?#? ?b c 8 ? ?Y&SY'SY(SY)S?? d ? I ?? ?. ,*-@ ?R