SQL笔记整理

基于数据库的VC++提醒精灵软件，设置好日期、时间、内容，就会在指定的日期、时间提示，须确定看到提示，否则两分钟后又提示。修改，删除，查询，日期，待自动启动到时间一会提示。 　　其中包括一个数据库操作类觉得不错，这个类是CPingDatabase，能插入、修改、查看、删除ACCESS数据库、SQLSERVER及所有的ODBC得用数据源来连接的数据库。使用类时出现一个警告，不用管它，那是微软的一个动态的原因。 (VC++ based on database software to remind the wizard, set the date, time, content, will be in the specified date, time, tips, to be sure to see tips, or two minutes later prompt. Modify, delete, query, date, to be automatically activated to the time for a prompt. Including a class of database operations that good, this class is CPingDatabase, to insert, modify, view, delete the ACCESS database, SQLSERVER and all ODBC starting a data source to connect to the database. A warning when using the class, do not ignore it, that is the reason Microsoft is a dynamic.)

百度数据库中间层讲的主要有 MySQL数据库集群面临的问题 数据库中间层整体设计 数据库中间层主要功能模块和策略 数据库中间层应用 数据库中间层发展(Baidu middle layer of the main MySQL cluster problems The overall design of the middle layer of the Database middle layer main function modules and strategies Database middle tier application Database middle tier development)

根据ArcSoft的工具包设计的简单人脸识别DEMO，仅供学习。APPID等需要到ArcSoft注册一个应用获得 开发环境准备：###开发使用到的软件和工具：Jdk8、mysql5.7、libarcsoft_face.dll(so)、libarcsoft_face_engine.dll(so)、libarcsoft_face_engine_jni.dll(so)、idea注：libarcsoft_face.dll(so)、libarcsoft_face_engine.dll(so)、libarcsoft_face_engine_jni.dll(so)、app-id、sdk-key可以到虹软官网 http://ai.arcsoft.com.cn/ 免费申请下载本地配置：配置环境(推荐jdk8，mysql5.7，maven3，idea)引擎库libarcsoft_face、libarcsoft_face_engine、libarcsoft_face_engine_jni。把dll或so文件拷贝到java.library.path所包含的路径下,注意区分X86和X64，和当前jdk版本一致。初始化项目 创建数据库arcsoft_face_demo，执行脚本arcsoft_face_demo.sql使用idea启动项目修改配置文件srcmainesourcesapplication.properties填写数据库地址：spring.datasource.druid.url填写数据库用户名：spring.datasource.druid.username填写数据库密码：spring.datasource.druid.password填写人脸识别id：config.freesdk.app-id填写人脸识别key：config.freesdk.sdk-key启动项目右键Application，选择Run ‘Application’项目访问地址http://127.0.0.1:8080/demo

Ado类 包括在access中写入blob数据并实现读取(Ado categories including access writes blob data and reading achievement)

数据库操作类，包括数据库连接，增删改查等(Database operations)

PB权限设置代码（控制控件是否可用）很不错的啊！(PB permissions set code (Control control is available) is pretty good, ah!)

医院门诊收费系统，在Myeclipse环境下开发，实现了门诊挂号收费、医生开具处方及药库管理、系统管理的功能。(Hospital outpatient billing system developed under the environment in the Myeclipse realized outpatient registration fee, the doctor issued prescription and Drug Storehouse management, system management functions.)

数据库监视备份软件客户端通信软件广播状态参数 当前的主库(DWORD)+当前的状态(DWORD) (Database to monitor the backup software client software radio communication parameters the current state of the main library (DWORD)+ Current status (DWORD))

地址簿管理系统，visual c++与Access数据库实现(Address book management system, Visual C + + and Access database to achieve)

用数据库的方式操作excel文件，包括了读取文件的表名，字段名和数据，有详细的注释(Operate with the database excel documents, including a table read from the file name, field names and data have detailed notes)