User Interface + Data & SQL

SQL

LOGIN:
SELECT *

FROM Passwords
WHERE Username = ?
AND Password = ?

The Login button will check if the user exists in the system and then go to the Account List page.

SQL

SELECT *

FROM Passwords

WHERE Active = 1

ORDER BY Name

SELECT *

FROM Passwords

WHERE Active = 0

ORDER BY Name

UPDATE Passwords

SET Active = 1

WHERE Name = ?

You can change from Active to Archive. This will change the data in the table. Active has a button that will let you edit a single account on the edit page.

Archive will let you restore the account.

SQL

SELECT *

FROM Passwords

WHERE Name = ?

UPDATE Passwords

SET Active = 0

WHERE Name = ?

INSERT INTO Password (Name, Username, Password, URL, Comment, Active)

VALUES (?, ?, ?, ?, ?, 1)

Validation:

• Make sure the name, username and password are the correct lengths
• The URL should be checked to make sure it is a URL

The Save button will save the account.

Archive will edit the account.

Cancel will go back to the List Page.