Hello, look how the project turned out
1) Login;
2) Add User;
3) List Users;
4) Edit User;
5) Delete user;
There are several sites where you can download the java connection library: mysql-connector-java-5.1.44
https://downloads.mysql.com/archives/c-j/
or https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.44
in b4j you must edit the config.properties file with your settings:
1) in b4j you must edit the config.properties file with your settings:
2) Run the b4x_users.sql file to create the b4x_users table in your database
and the fields:
id type int(11) auto incremeto
user type text
password type text
3) put the mysql connection library (mysql-connector-java-5.1.44) in the b4j libraries folder.
4) in b4a change the rdcLink variable with the IP and port of the server that is running b4j.
5) for some reason if we declare the types (DBResult and DBCommand) in Class_Globals inside B4XMainPage, I was getting an error, when I changed it to Process_Globals inside main, it worked.
6) If I've done useful work for you, buy me a coffee! kkkkkkkkkk
1) Login;
2) Add User;
3) List Users;
4) Edit User;
5) Delete user;
There are several sites where you can download the java connection library: mysql-connector-java-5.1.44
https://downloads.mysql.com/archives/c-j/
or https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.44
in b4j you must edit the config.properties file with your settings:
1) in b4j you must edit the config.properties file with your settings:
B4X:
JdbcUrl=jdbc:mysql://localhost:3306/namedatabase?characterEncoding=utf8&useSSL=false
User=name_user
Password=senha_user
2) Run the b4x_users.sql file to create the b4x_users table in your database
and the fields:
id type int(11) auto incremeto
user type text
password type text
3) put the mysql connection library (mysql-connector-java-5.1.44) in the b4j libraries folder.
4) in b4a change the rdcLink variable with the IP and port of the server that is running b4j.
5) for some reason if we declare the types (DBResult and DBCommand) in Class_Globals inside B4XMainPage, I was getting an error, when I changed it to Process_Globals inside main, it worked.
B4X:
Type DBResult (Tag As Object, Columns As Map, Rows As List)
Type DBCommand (Name As String, Parameters() As Object)
6) If I've done useful work for you, buy me a coffee! kkkkkkkkkk