B4J Question b4j insert, update delete with database mysql

[rudolf]

need help,
hy everyone,,,
i need to build simple application insert, update and delete connected with mysql database,
the data showed in tableview,
Can someone give me the source code to my learned
sorry i am beginner,

 

[Roycefer]

Check this out: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content

 

[Erel]

Also check this example: https://www.b4x.com/android/forum/threads/dbutils-example.34611/#content

 

[rudolf]

thanks reycefer and erel for replay my question, i have some trouble here :
#Region Project Attributes
#MainFormWidth: 600
#MainFormHeight: 400

#End Region
#AdditionalJar: sqlite-jdbc-3.7.2

Sub Process_Globals
Private fx As JFX
Private MainForm As Form
Private SQL1 As SQL '<<<<<<<<<<< error
Private Button1 As Button
Private Label1 As Label
Private TableView1 As TableView
End Sub

Error parsing program.
Error description: Unknown type: sql
Are you missing a library reference?
Occurred on line: 11 (Main)
Private SQL1 As SQL

What do I do now ?

 

[rwblinn]

Hi,

you need to add the jSQL library to the project. In the IDE, select jSQL from the Libraries Manager Tab at the bottom right.

 

[rudolf]

Thank You rwblinn,
done,,,