Lessons learned from the score Processing System

The processing after data entry has always been very important. The poor dean of the Anhui Examination Institute missed the college entrance examination data (to tell the truth, this mistake is really not easy ...) However, you are not authorized to perform this operation. The company also received a similar task here. There are only a few counties with a population of about people in each county. I finished my work again in the pitfalls, and I found that my work was not satisfactory.

 

1. Data Entry is an entry software provided by a company in Shenzhen to the Ministry of Education. According to the traditional spirit of responsibility push, after the college entrance examination data accident, the customer service phone of the company evaporated. However, based on past experience, there is nothing to do. It is necessary to import the Registration Form volunteer table registration point code table so that the input work will go smoothly in an orderly manner. Programs Written by others are good, fully functional, and stable, and basically don't bother.

2. After the data is input, the problem is solved. After opening the database, a bunch of tables are found ......, The scores of all input fields are the same as those of the subject. The first and second times are the same as those of the school team. A huge table is definitely a headache. Fortunately, there is a function in the provided program to export data to the CSV format, so that you can import the desired excel. It is much easier to start a table.

3. I thought that the table should be underestimated and I thought it would be enough to make a simple table. What I started to do was import an Excel table and then process it according to the customer. I don't have to worry about programming. In the future, we will know that no matter what tables we make, we will generate them directly from the database, instead of generating a semi-finished table for processing through Excel.

4. The tables to be generated are three simple tables (sorted by high/low seat numbers and the admission number) and the score section are sorted by the school score, and the paper of the expected score is printed ...... These solutions are troublesome. There are several artificial scores ...... It's terrible. Now I have taken out the post-event solutions.

Experience plan:

1. The database re-creates the SQL database, and the database provided by the input program cannot be used directly. Make the table of that database into the final table (it cannot be modified because someone will ask to modify the Score data later ...... Cute China ). In the score table, remember to set aside the [segment] indicators for each score. In many regions, the score table is the place where the scores of all subjects are ranked in the region. First, you need to obtain the number of students in the SQL statement, and obtain the score in proportion. The score is specified as the standard, this completes direct SQL statements, but it takes some time to execute the statements. The last is the total score. You only need to add the total score. But pay attention to the 0.5 decimal point issue. Are these completed using SQL statements ?...... Don't think about it

2. Simple tables are generated simply. As long as order sorting is done, the output table is naturally beautiful, and it is better to output it into an Excel file, but programming always looks better. There are many controls for printing tables, the most famous are Crystal Reports and activereport. These two controls are available for download on the Internet. I use grid ++ report 4.5 Made in China because the program is small and Chinese, and there are many examples, so select it. Although there are not many functions, they can also meet the requirements. You can directly input SQL statements on the table control to create a table. It looks simple and troublesome. In some cases, we need to make some adjustments ...... If less data is found, it is better to write it directly to the program table, and then the table directly prints the expected positive table ...... It seems much simpler. The problem still exists. The poor msflexgrid provided by VB to deal with tables with more than 1 million rows is just a turtle speed. So I chose vsflexgrid, which is commonly used by everyone ...... It is impossible to write data in one row. (If you use the virtualdata attribute of vsflexgrid, you can enable an active rs to be displayed efficiently. However, you only need to execute the results of each line using SQL statements. In some cases, this is really slow .) Return to the commonly used temporary table. The query result should be changed to a temporary table as much as possible, so that the last SQL statement can obtain data from the temporary table, both in speed and in concise statement. (writing programs also become troublesome, temporary table processing is really annoying. If it is not necessary, you do not need to write the stored procedure, and the balance will shake and shake ).

3. Collapse of complex tables ...... This is a pessimistic table, because volunteers are divided into several groups, and the scores are poor. Naturally, people will slide to the next volunteer. Finally, output the list of each high school student (this table was not created at the beginning. Just like how good the college entrance examination system is, there is no sharing on the internet ...... Really hate people ). This type of table creation 1. Use the proportion of the number of people to define the score line, and put the remaining people into the temporary table, so that this temporary table has all the first Volunteers not to be admitted. Find the second volunteer in this table. It's really easy to use SQL-server ...... A bunch of people don't volunteer, or the volunteers are wrong or garbled ......, But I also know that some schools do not want to score, as long as they have a transcript, they can go to the school. The score segment table is naturally much simpler and can be made manually. Finally, I printed my transcript. The transcript was printed. I used a Needle printer and printed more than a dozen pieces of paper continuously. I found that the best way was ...... Print the TXT file and hardly adjust it manually. Write one more print applet, a very simple program, add the calculated space and blank lines to the data, and write it into a text. Print: The cmd command print cannot print files larger than 65535 bytes. Replace the following command copy result.txt LPT1, which means to directly copy to print Serial 1. In some cases, the transcript must be printed on your own. Simply make a template and print it according to the template (paste it into the notepad to make it more beautiful, and select for the font ). If it is found that the print speed of the dot matrix printer is very slow, the simplest way is to change the driver and replace it with a later version of the same type, with unexpected gains.

# Begin

 

XX District 2007 annual Junior high school graduation examination score notice

First Volunteer: <zy1> Graduate School: <byxx>

Please refer to the following link for more information:

Admission Ticket No., seat No., name, Chinese language, mathematics, English language, politics, history, physics, chemistry, physical education, total score

Please refer to the following link for more information:

Average <zkh> average <zwh> average <XM> average <YW> average <SX> average <YY> average <SP> average <ls> average <WL> average <HX> latency <ty> latency <Sy> latency <ZG> latency <ZF> latency

Please refer to the following link for more information:

 

----------------------------------------- Cut down the line -----------------------------------------------------------

# End

 

"Effect", "allow ", "effect", "allow", "allow"

Nine rows

The above plans, experiences and lessons can be put into practice only after the next time. Finally, let's talk about the problem of VB. Vb ide is very good, but it is really lagging behind than. Net working environment (if vs2005 can be opened as quickly as VB6.0 ). We recommend that you install codesmart 2007 as a plug-in so that I can write some vbprograms every day. At the same time, he is also fascinated by the tab labels, Maxthon and VB. Now, even the system has installed qttabbar with labels.

Sometimes it is better to use web pages for such operations. As the hardware level increases, the performance of JavaScript virtual machines and flash is becoming more and more powerful, today, people are gradually getting used to the web services provided on the network, rather than installing a lot of software, the installed software comes standard with only office, WinRAR, kill software, player, and Im (XX input method and XX securities software may be installed for you ). If you have a job or a professional need, you can install a few other things (not limited to software control and IT industry personnel ). With the efforts of evil companies such as Google, cross-platform Web has become the main way of work and communication. The maintenance program is simple and updated frequently. operations on the browser can naturally meet the needs of the general public. In the future, the EXE programs that need to be compiled and installed are estimated to be specialized only in the industry.