实验一

Oracle 10g精要 第三版(essence of the third edition of Oracle 10g)

用Delphi编写的户籍管理系统(prepared with the names of Delphi Management System)

我上传的是一个数据库，是mysql的数据库，sql文件(I uploaded a database, the database is mysql, sql file)

说明：  数据库操作类，可以对SQL，ACCESS等进行方便的操作(Types of database operations can be SQL, ACCESS, etc. to facilitate the operation of)

说明：  首先要在登陆系统时有身份验证功能，其次能对有关学生的各类信息的数据进行添加、修改和删除，能对学生成绩的数据进行添加，修改，删除，能对学生信息进行按学号，姓名进行查询，能对学生成绩按照课程号和姓名进行查询；系统管理员除可实现普通用户的操作外还可以添加，修改，删除用户信息，并能对密码进行修改。(We must first login authentication, and second on the data of all kinds of information about students to add, modify and delete student achievement data to add, modify, delete, according to school student information, name queries on student achievement in accordance with the course number and name of the query In addition to the ordinary user of the operation, the system administrator can also add, modify, delete user information, and can modify the password. )

hr人力资源系统 sqlserver数据库(hr human resources systems sqlserver database)

这是我自己写的从数据库中读出数据，并显示，并构成不规则三角网的程序，可以在程序中添加约束线。(This is written in my own读出数据from the database and displays, and triangulated irregular network constitutes the procedure, you can add a constraint in the procedure line.)

说明：  每组不超过4人，每人从TPC-H中选择至少三个查询进行执行，并进行性能调整。同组人员所选择的查询不能相同。各查询均必须包含：两个以上的表连接操作，其包含至少一个聚集函数。 每位同学的该作业均放在一个命名如“姓名-学号-专业-作业1”的目录中 用尽能想到的所有技术方法，使得选定的查询的某些性能指标尽可能的差 用尽能想到的所有技术方法，使得选定的查询的某些性能指标尽可能的好(Each group has no more than 4 people. Each person selects at least three queries from TPC-H to perform and performs performance adjustment. The queries selected by the same group can not be the same. Each query must contain more than two table join operations, which contain at least one aggregation function. Each student's homework is placed in a directory named "name student number professional operation 1". Using all the technical methods that can be thought of, make certain performance indicators of selected queries as poor as possible. Use all the technical methods that you can think of, and make certain performance indicators of selected queries as good as possible.)

本人为出租屋编写的电费管理程序,应用了MFC DAO链接了ACCESS数据库,利用可编辑的listctrl控件,综合考虑了多房间线损耗电的业务细节 和 界面皮肤美观,灵活方便的将物业电费管理轻松掌控.(err)

记事本程序源码主要涉及的技术点就是SQLite，源码不大注释得体，并且附带项目报告一份。是安卓菜鸟拿来练手的绝好程序。日记的数据主要记录在本地的SQLite数据库中，程序里面有个日志搜索功能，不过没用模糊查询。(Notepad program source code is mainly involved in the technical point is SQLite, the source code is not well commented, and comes with a project report. The program is under the vast Android rookie. Diary of the data is mainly recorded in the local SQLite , the program which has a log search function, but did not use the fuzzy query.)