C # Build: Student Achievement Management System

I haven't updated my blog for a long time. I am nearing the examination. This junior in computer science is really a lot of things to do. I have n or more large jobs, and the tests are all completed in a week or two weeks, it was so painful that I had done a good job of checking on a Monday at three o'clock last night. The assignment requirements are as follows:

Lab 2 Student Score Management System
Enter Student Information
Users: instructors and Administrators
Score Input by instructors
Administrators establish instructor users and establish subject-teacher relationships
The system automatically analyzes the score and generates a ranking report based on the score.

At the beginning, I thought it was very difficult to use win form. parameter passing would be a big problem. I wanted to do the best in database design according to my own practices, if notProgramBut isn't it a mix of teachers? I can't go through it myself. After a long time on a web page, I used access to create a database. The most complex relationship is the log and comment, there is a relationship between the entire website and it is not difficult. Here, this assignment is just for the instructor. There are no students yet. The students choose courses and query their scores. So there is no student logon link. I need to add the assignment to it, it is not impossible to do it either, but it is impossible to do it well in such a short period of time, and not only this section is pushed to the neck, well, send it here:

with the arrival of the end of the semester, JSP class ends, JSP the arrival of a comprehensive design experiment, I struggled between JAVA and C # . Learning JAVA is not long at all, programs for other subjects are also used C # , therefore, JAVA has no right to speak. However, for the JSP course selection system, most database operations are performed, the two are more or less aware of each other. JavaBean really attractive ~ no advanced stuff like struts . I don't know how I feel when I use it? Using database operations with JavaBean is a pleasant experiment, for C # , ADO. net components are also a pleasant task. ~

It seems that there are more questions....... -_-!!The database of this system usesAccess, ContactAccessFor a long timeASPI have been using it since the beginning. It is very small and exquisite. Especially this time, when the database is designed to a certain degree of paradigm, it is really a headache when data queries update multi-Table connections, I want to create a network with a maximum of those items.SQLCommand, the statement of this job is really difficult, but fortunatelyAccessThere is a query designer that visually selects tables and columns, and it automatically generates statements. Although I don't know how efficient these statements are, it is not easy to import and execute data, but it is really easy for me!

This time, the security and security class MD5 I used it, but I used it once from my previous web experience. MD5 . Password MD5 Encrypted. The Hidden values of passwords are considered here. This password has the value of the current system for the current system, but most people do not bother to remember too many passwords, so the same password is used for bank cards, student IDs, and other passwords, if the password is lost, the password will be used one after another. MD5 It is irreversible to record the password, which means that even if someone else knows the value of the password in the database, the original password cannot be known, reducing the loss. I think this also solves a security vulnerability, database injection problem, and password. But I can inject it without considering the name. ...... Therefore, when logging on to the application, fill in the following Username: 1' Or' 1' = '1 If the password is known to others, you can log on to it. However, I have never thought of anyone who knows my Forum password or mailbox password. Qq Password ~ Ha ~ Therefore, under such a large premise, security is guaranteed to a certain extent. Of course, improvements are needed, ASP I will separate the single quotes, but how can this C # They are new things that haven't been in touch for too long. They don't know how to use this function yet, Baidu search first, so they can be improved after a long vacation.

PS: The generated HTML file does not know why there is nothing to browse in the browser, but you can open it in Notepad without modifying anything. You can view the data after saving it and opening it in the browser, that's strange... Originally, I wanted to generate xml and convert it to HTML, but I forgot about XSL from the winter vacation to the start of school, and the experiment was not successful yet. What should I say about the outdated transform form, the book is still in the library. If you don't have time, just generate HTML and write it into the file.

Program source code: http://files.cnblogs.com/lanse777/MarkManager.rar
Rough work. If any error occurs, please testify. Thank you!