Student information management system summary

It has been about half a month since I started to knock on the student system, to the acceptance project, and to modify the Bug During the acceptance process. In the past half month, I received a large amount of goods. At the time of project acceptance, I was deeply touched by what Shi said. The system we did was not for ourselves, but for others. We wanted to serve the people.

At first, I thought everything would be okay if I had knocked on the system without making any mistakes. I was very happy because this was a system I had knocked on since I went to the advanced class. I was very happy to go to the senior engineer's project for acceptance all night, I thought it could pass the acceptance test very well. I didn't expect that, with the help of my brother's face, my gray-faced face would be back. During the acceptance process, shi Ge pointed out that there are still many imperfections in my system! Let me modify it! In addition, I have few comments and the Code does not meet the requirements. The most important thing is that my interface is unfriendly. During the entire acceptance process, I wrote down every sentence that my brother said.

So when I came back, I began to improve my code! By searching for information on the Internet, I finally completed all the mistakes I made. I also learned about the imperfection and improvement of the student information management system. It also increases your knowledge!

There are also some common errors encountered in the student information management system, such:

Real-time error "91"
/The database is not connected successfully.

Real-time error 3021"
/The Data Query record is empty.

Real-time error "-2147217887 (80040e21 )"
/The Database Type assignment space is insufficient.

Real-time error "-2147467259 (8004005 )"
/The date of data stored in the database exceeds the database date limit.

 

I have fixed these errors during code coding, and I will not summarize them here, because I have read many blogs and there are methods to summarize and solve them, it is similar to my solution.

Next I will solve the issue of the order of birth date and admission date of the student status form in the student system. I think we should all know that the newly-born children do not go to school! At least a child needs to enter kindergarten at the age of 4 or 5. In this case, how can we limit the interval between four or more years when users enter a student status in the student system!

This is actually quite simple. There is such a function datediff ()

What does it mean! I will introduce it to you.

Datediff (Interval, date1, date2[, Firstdayofweek[,
Firstweekofyear])

DatediffThe function syntax includes the following naming parameters:

Interval:Required. String expression used to calculateDate1And
Date2Time Difference

Date1 and date2: required;Variant(Date). The two dates used in the calculation.

Firstdayofweek: Optional. Specifies the constant of the first day of a week. If not specified, Sunday is the first day.

Firstweekofyear:Optional. Specifies the constant of the first week of a year. If not specified
The week of January 1, January 1 is the first week.

Interval parameters include YYYY (year), Q (season), m (month), y (number of days in a year), D (day), and w (number of days in a week), ww (week), H (hour), n (minute), S (second ).

In the past half month, I had my own sweat and joy, which brought me a lot of GAINS. At this point, the student information management system is also included in paragraphs.