vcadodaoadb

个人理财系统是我用MFC做的一个有界面的程序，里面涉及了数据库编程，常用的控件等知识。里面的数据都存储在SQL Server2005里面，我用的是ado方式访问数据库，实现了记录日常每餐的消费食物，消费水平，并可以自动算出一段时间的消费金额。(Personal financial management system is an interface program I do with MFC, which involves a database programming, controls and other knowledge. Inside the data stored in SQL Server 2005 which I use ado to access the database, to record daily meal consumption of food, consumption levels, and can automatically calculate the amount of the consumer for a period of time.)

在VS2010开发环境下开发，可进行数据库的连接、查询、插入、删除，适合初学者学习。(VS2010 development environment under development, database connection, query, insert, delete, suitable for beginners to learn.)

利用ADO技术设置数据库名，用户ID密码，也可以倒入数据(use ADO set up the database name, user ID password, data can be poured into the)

用VC++下用ADO两节Access数据库，实现对Access的操作(With VC++ next two Access database with ADO, to achieve the operation of Access)

将Dataset导出到Excel，本程序阐述基本功能(Dataset exported to Excel, the program described the basic functions of)

使用ODBC访问数据库，一则ODBC是直接封装在MFC库里面的，二则忙着考研没有时间学习dao。 ODBC和DAO用起来可能最大的区别就是ODBC使用之前得先建立数据源，根据不同的数据库，使用的参数也不同。具体请看在这之前的一片文章。里面有许多东西没有说，属于高级技巧性东西，得学你们自己摸索。(Using ODBC to access the database, an ODBC database directly encapsulated in the MFC inside, two busy Kaoyan no time to learn dao. ODBC and DAO can be at the biggest difference is that must be built before using ODBC data source, depending on the database, the parameters used are also different. Details, please read an article before this. There are many things not said, things are high skill, have to learn your own. )

本系统有三种操作权限，其中，营业员只可以执行开台、点菜、买单及查询日收入操作；领班可以执行开台、点菜、买单、进货、添加新员工、日收入及月收入查询等操作；经理具有最高权限，除了领班及营业员的操作权限外，还可以设置员工权限、添加商品信息及菜式信息、备份与恢复数据库及初始化数据等操作。(The system has three operating authority, which can only be executed Founding salesperson, a la carte, pay and check daily revenue operations foreman can perform Founding, a la carte, pay, purchase, adding new employees, daily income and monthly income of inquiry operation manager with the highest authority, in addition to the foreman and the operating authority salesperson, you can also set permissions for employees, product information and dishes to add information, database backup and recovery, and initial data and other operations.)

本例将对数据库的基本操作封装成一个基本类,实现同时连接不同的数据库(mysql和mssql),并从其中取出数据利用socket发送.(the cases will be the basic operation of the database packaged as a basic category, simultaneously connect different databases (mysql and mssql) remove from which to send data using socket.)

vc MFC带有界面的管理系统，实现用ado的方式连接access(vc MFC with the interface management system, to achieve ado way connection to access)

vc6.0和vs2005访问access数据库，包括增删改查，有示例，可在此基础上进行功能添加。(VC6.0 and VS2005 visit ACCESS database, including the crud, example, can be carried out on the basis of function add.)