🔒 Closed Login stored procedure in mysql and javafx

[Xianmark]

Hi mga idol, baguhan pa kasi ako sa stored procedure. gusto ko kasing i change ang paraan ng pag query sa system ko.. patulong po ako sa user login gamit ang stored procedure at javafx, bali maydalawang parameter po siya, username at password at kung nag exist po yung data may i-return ang procedure na value.

Salamat po.

 

[juwilin]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE sp_check_user
-- Add the parameters for the stored procedure here
User_name varchar(100),
Password varchar(100)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT * from user_table where username = username and password = Password
END
GO

ayan irereturn nya yung buong data nya sa table if existing