Android Question B4A Login Form

[Hikari]

Hi, I'm a new member and a beginner on programming. I'm making an app which consists of Log in form and application form to be filled, my problem is my username and password can't be evaluated. I have already watched some tutorials and read some threads in this forum regarding to my problem but still it can't be fixed, I use activity modules rather than b4xpages by the way. And I also use XAMPP as my database server. Can someone help me on my problem?

Thanks in advance!

Sub Process_Globals
    'These global variables will be declared once when the application starts.
    'These variables can be accessed from all modules.
    Private xui As XUI
   
    Type DBResult (Tag As Object, Columns As Map, Rows As List)
    Type DBCommand (Name As String, Parameters() As Object)
    Private const rdcLink As String = "http://192.168.254.106:17178/rdc"
End Sub

Sub Globals
    'These global variables will be redeclared each time the activity is created.
    Private ButtonLogin As Button
    Private ImageView1 As ImageView
    Private LabelHead As Label
    Private LogAdmin As Label
    Private Panel1 As Panel
    Private Panel2 As Panel
    Private Panel3 As Panel
    Private Panel4 As Panel
    Private Password As EditText
    Private StudentID As EditText
    Private TextHeader As Label
End Sub

Sub Activity_Create(FirstTime As Boolean)
    Activity.LoadLayout("front")
   
    StudentID.Color = Colors.Transparent
    Password.Color = Colors.Transparent
   
    GetRecord
End Sub

Sub GetRecord
    Dim req As DBRequestManager = CreateRequest
    Dim cmd As DBCommand = CreateCommand("getId", Null)
    Wait For (req.ExecuteQuery(cmd, 0, Null)) JobDone(j As HttpJob)
    If j.Success Then
        req.HandleJobAsync(j, "req")
        Wait For (req) req_Result(res As DBResult)
        'work with result
        req.PrintTable(res)
    Else
        Log("ERROR: " & j.ErrorMessage)
    End If
    j.Release
End Sub

Sub Activity_Resume

End Sub

Sub CreateRequest As DBRequestManager
    Dim req As DBRequestManager
    req.Initialize(Me, rdcLink)
    Return req
End Sub

Sub CreateCommand(Name As String, Parameters() As Object) As DBCommand
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = Name
    If Parameters <> Null Then cmd.Parameters = Parameters
    Return cmd
End Sub

Sub Activity_Pause (UserClosed As Boolean)

End Sub

Private Sub LogAdmin_Click
    StartActivity(Admin)
End Sub

Private Sub ButtonLogin_Click
    If StudentID.Text = "" Or Password.Text = "" Then
        Msgbox("Input Student ID and Password", "INVALID!")
        Return
    Else
'        GetRecord
    End If
End Sub

 

[aeric]

GetRecord

Why do you put this method in Activity_Create and commented out in ButtonLogin_Click ?

 

[Hikari]

Why do you put this method in Activity_Create and commented out in ButtonLogin_Click ?

I just tested it if it's gonna work, I tried all possibilities but I got no luck so I commented it on ButtonLogin_Click

 

[aeric]

Please post your jRDC server and your database schema and data.

 

[aeric]

I hope you are not making the same mistake.

You are not passing any parameter to jRDC2, you're passing Null

Login Form using MySql in jRDC2 Help!

Hi! I'm an absolute newbie here, I need help in validating my database using MySQL. here's my query sql.validate=SELECT * FROM `tbl_userinfo` WHERE `Username` = '" & uName.Text & "' AND `Password`='" & pWord.Text & "' In here, I have two edit texts, uName and pWord. It works just fine when I...

www.b4x.com

 

[Hikari]

Please post your jRDC server and your database schema and data.

 

[aeric]

DriverClass=com.mysql.jdbc.Driver

You just missing "com." in DriverClass

 

[Hikari]

It still says error..

ResponseError. Reason: java.net.UnknownServiceException: CLEARTEXT communication to 192.168.254.106 not permitted by network security policy, Response:
ERROR: java.net.UnknownServiceException: CLEARTEXT communication to 192.168.254.106 not permitted by network security policy

 

[aeric]

It still says error..

ResponseError. Reason: java.net.UnknownServiceException: CLEARTEXT communication to 192.168.254.106 not permitted by network security policy, Response:
ERROR: java.net.UnknownServiceException: CLEARTEXT communication to 192.168.254.106 not permitted by network security policy

This is because Android does not permit non-SSL connection due to changes in targetSdkVersion. You can solve it by adding a line in manifest editor.

CreateResourceFromFile(Macro, Core.NetworkClearText)

CLEARTEXT communication to 192.168.0.101 not permitted by network security policy

Hi All, I tried to implement the JRDC2 implementation of Erel in one program. The implementation of Erel is in the below URL: https://www.b4x.com/android/forum/threads/b4x-jrdc2-b4j-implementation-of-rdc-remote-database-connector.61801/ I get the following error: ResponseError. Reason...

www.b4x.com