This Library can be used to connect your Device to a MySQL database. The Library use a direct connection to the MySQL databaseserver.
Requisites: The Database must be accessible from "outside"
DisAdvantages: Due to the app needs the Databasecredentials (including username and password). There Credentials must be included in your App. I suggest using this Library only for private or company intern use.
MSMySQL
Version: 1.06
- MySQL
Events:Methods:
- BatchResult (batch As Map)
- ExecResult (meta As Map)
- ListTables (tables As List, ms as Long As )
- QueryResult (data as List As , meta As Map)
- QueryResult2 (data as List As , meta As Map)
- Status (Connected As Boolean, ReConnecting As Boolean, RetriesLeft As Int)
Properties:
- CloseDatabase
Closes the database
Example:<code>
db.closedatabase
</code>- DisableReconnect
Disable automatic auto_reconnect if the MySQL Database Connection is lost
By default this is enabled- EnableReconnect
Enable automatic auto_reconnect if the MySQL Database Connection is lost
By default this is enabled.- ExecuteASync (query As String, Task As String)
executes ONE SQL-Commands (insert, update, delete)
Example:<code>
db.executeasync("INSERT INTO b4alog SET log_value='Test"&i&"', log_time="&DateTime.Now&";")
</code>- ExecuteBatchASync (batch As List, Task As String)
executes a batch of SQL-Commands (insert, update, delete)
Example:<code>
Dim batch As List
For i=1 To 100
batch.Add("INSERT INTO b4alog SET log_value='Test"&i&"', log_time="&DateTime.Now&";")
Next
db.executebatchasync(batch)
</code>- ExecutePeparedStatement
- Initialize (event As String, host As String, user As String, password As String, Database As String)
Initialize the Library
the url to your database. You dont need to prefix it with
jdbc:mysql:// as this will be done automatically
Example:<code>
db.Initialize("eventname","mydbdomain.com","dbusername","dbpassword","dbname")</code>- ListTablesAsync
Get a list of all tables inside this catalog (database)
The event listtables will be raised
Example:<code>
db.ListTablesAsync
Sub sql_listtables(tables As List)
Log("sql_listtables()")
For i=0 To tables.Size-1
Log("Table "&tables.Get(i))
Next
End Sub
</code>- PeparedStatement (sql As String)
- QueryASync (query As String, Task As String)
Query the Database. When the Method finishes the event QueryResult
will be raised
QueryResult gets two values. A "List of Maps" for the results. Each
Item in the List contains a Map holding the Values from on Resultrow
The Second value is a Map containing some informations:
ColumnCount, RecordCount and time elapsed in ms for the query
Example:<code>
db.queryasync("select * from members LIMIT 0,1 ;")</code>- QueryASync2 (query As String, Task As String)
Query the Database. When the Method finishes the event QueryResult2
will be raised
QueryResult gets two values. A "List of Strings" for the results. Each
Item in the List contains a String holding the Values from on Resultrow
in the format "["+field1+","+field2+"]"
The Second value is a Map containing some informations:
ColumnCount, RecordCount and time elapsed in ms for the query
Example:<code>
db.queryasync2("select * from members LIMIT 0,1 ;")</code>- SelectDB (database As String) As Boolean
Manually select the database to Query.- SetPeparedBlob (parameterIndex As Int, imagepath As String)
- SetPeparedInt (parameterIndex As Int, x As Int)
- SetPeparedLong (parameterIndex As Int, x As Long)
- SetPeparedString (parameterIndex As Int, x As String)
- check_connection
- isReconnectEnabled As Boolean
Test whether or not automatic reconnect is currently enabled.
By default automatic auto_reconnect is enabled
Return type: @return:true if automatic auto_reconnect is enabled, false if it is disabled
- ReconnectNumRetry As Int
Returns the maximum number of automatic reconnection attempts before giving
up and throwing an exception.
If this value was not changed with {@link #setReconnectNumRetry(int)} the default
number of attempts is 15- ReconnectTime As Int
Returns the waiting time before attempting to auto_reconnect to the MySQL
Database server.
If this value was not changed with {@link #setReconnectTime(int)} the default
waiting time is 5 seconds
The library is not free. You need to donate as low as 5$ to get the library.
I just send out the registration mail a minute ago.I have 'donate' you, and now?
To obtain the user ID:INSERT INTO S1 (User) VALUES ("Foo");
but to read the result should I use another QueryASync in the MySQL_ExecResult eventSELECT LAST_INSERT_ID () AS Lindex;
Yes. You could use a php-script as man in the middle which inserts the record and do a query for the last record and return this id.Is there an easier way?
Dim Query AS List
'disable button to reenable after end of SQL lines
Query.Add("Insert...")
Query.Add("Delete...")
db.ExecuteASync("Update...", "Task1")
Sub MySQL_ExecResult(meta As Map)
Select (meta.Get("TaskID"))
Case "Task1"
If (Query.Size>0) Then
db.ExecuteASync(Query.Get(0), "Task1")
Query.RemoveAt(0)
Else
'for example enable button or other action
End If
End Select
End SubnoCan I Connect To MsSql Server with this lib
Thanks JashswaniNO cursors here.
No. You need to provide MORE information.
For example the db-schema you are using. if for example iD is an autoincrementdield then you can not set your own id.
Additional the field iD is most probably not known as in the select you do use ID and not iD. So, what is the right name?
then you should most probably use a insert statement likeYes I 'have ID (int) with autoincrement
db.ExecuteASync($"INSERT INTO tbluser1 SET username="${txtusername.Text}", password="${txtpassword.Text}";"$,"")Full Support.Code:
db.ExecuteASync($"INSERT INTO tbluser1 SET username="${txtusername.Text}", password="${txtpassword.Text}";"$,"")
Full Support.
No. The data will come from the database when te app is running. No chance to see it at design-time.that in Designer were visible data retrieved from the database?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?