Database instance learning Summary

On the sixth day of school, the five database instances had a mis system. Let's talk about some things in this database. Let's start with the five instances. The five examples are database operations, from a simple data extraction operation to subsequent connection, command,

On the sixth day of school, the five database instances had a mis system. Let's talk about some things in this database. Let's start with the five instances. The five examples are database operations, from a simple data extraction operation to subsequent connection, command,

On the sixth day of school, the five database instances had a mis system. Let's talk about some things in this database.

Let's start with the five instances. The five examples are database operations, from a simple data extraction operation to subsequent connection, command, recordset. However, looking at these five instances, a connection is established first, then the record set is obtained, and then compared with the input characters in the program, or display the data in the record set to the program. In fact, this is the three steps: establishing a data source Connection (creating a Connection object), retrieving data (creating a Recordset object), and operating data.

Although the steps are the same, but the methods are different, from the creation of the data source is the same, to the second step when creating a Recordset is different. You can use the command object to obtain the Recordset object or the SQL statement to obtain the Recordset object. But what is the difference between the two? According to Kun Ge, the command will be very useful in the future, and now it is enough to remember it. Speaking of this command object, there is also the parameter object, what is a parameter (this is a general understanding of what is specific ). The final operation on data can be performed through the filter attribute of recordset or through SQL statements. If you use the command object to perform operations, it is quick (maybe this is the advantage of command ). This is all done. In fact, there is also the issue of paging display in the recordset. There is a logical paging in the recordset. It means that the control does not support it. If the data Grid cannot be directly connected to the recordset page, you should create a recordset object with the paging data, and then set the control data source. The MSFlexGrid control does not need to be used. It seems that this control does not get data by setting the data source, but adds the data in the record set to the TextMatrix one by one.

In fact, we can see that the learning of these databases only involves some applications. The understanding of the database is not very deep. It may be related to the application of the database.

Again, the student management system has been knocked on by itself. The most obvious improvement is the speed of coding. The content involved in the system is not very fresh, sometimes, the context of the system is not very clear, and it is always passive. I suddenly think this is not important. This refers to implementing this thing (system ). The important thing is to analyze this system. I think if I have done all the preliminary analysis and documents of this system, now, it is easy to crack the code (the author used an exaggerated method here ~). The general meaning is that the early analysis is important, just like the idea of solving the problem is more important than solving the problem.

What we are doing now (the five instances and one MIS System) is a bit of knowledge, and there is no difficulty. In the words of Mr. Mi, the wolf eats everything, whether you are the control or the control, whether you are the object or the object, and the visitor does not refuse. Haha, stomach-realm ~......

At the beginning, the major drama is still behind.

Remind yourself again: Today is the seventh day!