Share My Creation [B4XPages] jRDC2 + CRUD MySql + Login [Source Code Free]

Hello, look how the project turned out

1) Login;
2) Add User;
3) List Users;
4) Edit User;
5) Delete user;

background5.jpg
background5 (1).jpg


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/

1712533153288.png



or https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.44

1712533302723.png



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)
1712534683914.png


6) If I've done useful work for you, buy me a coffee! kkkkkkkkkk
 

Attachments

  • JRBC.zip
    72.9 KB · Views: 107
Top