CRUD
<<interface>>
Engine
+
+
+
+
+
select (...)
execute (…)
insertGeneratedKeys
update (...)
batch
(...)
(...)
h24.database.def
: List <DTO>
: boolean
: DTO
: int
: int[]
Engine
h24.email
Primitive CRUD su database generico
Mail
h24.database.generic
GenericConnection
h24.database.data
DTO
GenericConnection
+ getConnection ()
: Connection
+ cursor
(…) : Cursor
Implementazione CRUD su specifiche JDBC
Cursor
<<create, call>>
<<create>>
Mail
DTO
Copyright © 2015 BUSCATI.COM - All rights reserved - [email protected]
Struttura bilanciamento connessioni
<<interface>>
EngineBalance
+TIMEOUT : int = 15 {readOnly}
+
+
+
+
+
+
+
+
getSize()
: int
setSize(...)
getTimeOut() : int
setTimeOut(...)
pop ()
: GenericConnection
push (...)
purge()
capacity()
: int
h24.database.balance
h24.database.generic
EngineBalance
GenericConnection
h24.database.balance
AliveConnection
Primitive ambiente bilanciato di connessioni
Fifo
<<call>>
Fifo
<<call>>
GenericConnection
AliveConnection
Copyright © 2015 BUSCATI.COM - All rights reserved - [email protected]
Costruzione query e recupero meta dati
<<enumeration>>
TypeField
number, alfaNumeric,
function
<<enumerati on>>
AggregateFunction
min, max, sum, avg,
count, count_distinct
<<interface>>
EngineBuild
+
+
+
+
+
+
+
+
+
+
+
+
+
engineSelect (…)
: String
engineSelectAggregate ()
: String
engineCount (...)
: Long
engineUpdate (...)
: String
engineInsert (...)
: String
engineDelete (…)
: String
engineField (…)
: String
engineFilter (...)
: String
engineTime (…)
: String
engineCreateTableFromSelect () : String
engineTruncateTable (...)
engineDropTable (...)
engineStoredProcess (…)
:String
h24.database.def
EngineBuild
Primitive per la costruzione di query su
database generico
h24.database.generic
SynchroConnection
SynchroConnection
Copyright © 2015 BUSCATI.COM - All rights reserved - [email protected]
SQL dialetto (MySql database)
<<abstract>>
SynchroConnection
h24.database.generic
-
fifo : EngineBalance
aliveConnection : AliveConnection
url
: String
user
: String
pwd
: String
h24.database.def
GenericConnection
EngineBuild
+
+
+
+
+
+
setSize(...)
setTimeOut(...)
pop () : GenericConnection
push(...)
purge()
capacity() : int
Implementazione ambiente bilanciato di
connessioni
AliveConnection
h24.database.balance
h24.database.mysql
Fifo
MySqlConnectionn
MySqlConnection
Gestore dialetto
SQL (database
mysql)
<<create, call>>
<<create, call>>
<<create, call>>
GenericConnection
Fifo
AliveConnection
Copyright © 2015 BUSCATI.COM - All rights reserved - [email protected]