Public Sub MainPgm()
InitDB
tmrMAIN.Enabled = True
End Sub
Sub tmrMAIN_Tick
tmrMAIN.Enabled = False
getData_1
GetDaora
putData_1(ValDaoraUnico)
tmrMAIN.Enabled = True
End Sub
Public Sub InitDB
Try
ConPool.Initialize("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:8889/DB64?characterEncoding=utf8&useSSL=false&zeroDateTimeBehavior=convertToNull", "root", "root")
Log("DB Opened")
Catch
Log("Last Pool Init Except: "&LastException.Message)
End Try
Dim jo As JavaObject = ConPool
jo.RunMethod("setMaxPoolSize", Array(100))
End Sub
Public Sub putData_1(Valdaora As String)
mySql_DB64 = ConPool.GetConnection
mySql_DB64.BeginTransaction
Try
mySql_DB64.ExecNonQuery($"UPDATE SerialDataAllDevice SET dataora = "$ & Valdaora & $" WHERE id = 1 ;"$)
mySql_DB64.TransactionSuccessful
Catch
Log("Error putData 1")
mySql_DB64.Rollback
End Try
mySql_DB64.Close
End Sub
Public Sub getData_1
mySql_DB64 = ConPool.GetConnection
mySql_DB64.BeginTransaction
Try
Dim RS As ResultSet
RS = mySql_DB64.ExecQuery($"SELECT * FROM Servizi WHERE Servizio = '01';"$)
RS.NextRow
ListView1.Items.Add(RS.GetString("Lettera") & "-" & RS.GetString("Descrizione1"))
mySql_DB64.TransactionSuccessful
Catch
Log("Error getData 1")
mySql_DB64.Rollback
End Try
RS.Close
mySql_DB64.Close
End Sub