Combined Query BUG of the data room charging system and combined query of the Charging System

Combined Query BUG of the data room charging system and combined query of the Charging System
Disclaimer: the following content only applies to queries on-board records (combined queries) of students, and queries on-board records only for operator work records (combined queries!


It is a BUG. In fact, this is not a BUG. It is just an error that is easy to make. If you don't pay attention to it, you can't find it. The following is a detailed description:

There are three combined queries in the data room charging system: basic student information query, student computer record query, and operator work record query. The students' computer record query, I personally think that only the records that have already been down should be queried, and the records on the machine should not be queried. The operator's work records are also the same.

If you share the same idea with me, let's see if our implementation method is the same: the SQL statements for combined queries are all concatenated strings, but are we correct?

Method 1:

Method 2:





What are the different query results for the same data and the same combination query? How can this happen? It must be our own problem. We all know that the SQL query statements in the Combined Query are concatenated by conditions, but are we correct?

First splicing:

Select * from T_Line where status! = 'Machine in id' and cardNo> '0' or cardNo <'5'

Splicing:

Select * from (select * from T_Line where status! = 'Machine in id') as T_Line where cardNo> '0' or cardNo <'5'

The first splicing method is to simply add a condition to the backend for splicing. I believe someone has made the same mistake with me! In fact, as long as we write the SQL statement, we can easily see where we are wrong: if all the conditions are connected with "and", we can also query the correct results, however, when we use "or" to connect conditions?

For the second join, use a subquery to query the result that meets the "offline" condition as a temporary change, and then query the data we want to query from this temporary table, in this way, no matter whether the following conditions are "and" or ", the records on the computer will be queried.

After a simple explanation above, I believe everyone understands where their bugs are. If you still don't understand them or have better solutions, please discuss them in private ......

How to crack the school data room Charging System

You can check the charging system and find it on the computer. You can also go to the computer of the charging system to check the disk on which the installation directory is located and the files,
What kind of floppy disk are you using, the CD, the USB flash disk, boot the computer, and delete these files under DOS, so the boot will not boot ..

How to crack the charging system of the IDC room ???

You can check the task manager to see that there is a paid system process and it will end, and you will be able to access the Internet for free!