Thoughts on ADO. NET login cases and Thoughts on ado.net Cases

Thoughts on ADO. NET login cases and Thoughts on ado.net Cases

Overall Thinking. Based on the user name and password entered by the user, it is determined that the login is successful, if the same as that stored in the database, otherwise the login fails.

Solution 1:

1. select * from table name where username = "user input username"

2. if reader exists. read (), that is, the user name exists, and then judge the password entered by the user, and the obtained password (reader. getString (reader. getOridinal ("password field") is the same. If the same is true, the logon succeeds. Otherwise, the logon fails.

Solution 2:

Select * from table name where username = "user input username" and password = "user input password". If data is found, the logon is successful. Otherwise, the logon fails.