bitsCN.com
每个数据的访问都用自己的通信协议，包括还有不同的接口调用，参数传递。在同一个程序里要使用不同数据库里的信息，按照正常的情况来说，那就要写不同的数据库连接的方法，就像在程序里写了多个精简版的 数据库 客户端。这样的编程方式肯定会让人不好难受，所以就期望能够有一种统一的访问数据库的方式，大家都用这一种方式去连接数据库，那么将减少很多痛苦。
话说微软是第一个给大家带来曙光的人，推出了ODBC的概念，从此所有的程序都不用自己写数据库连接程序了，从此跨入了解放时代。ODBC是一组基于C语言的API，它能兼容不同的数据库，然后提供统一的访问接口，这样就为大家节省出了YY的时间。
在ODBC推出后多年，有出了一个新概念OLE DB。这个是ODBC的升级版，因为一切都开始面向对象了，所以这个自然就是以对象方式来实现的。而且在性能方面也有了一些提高，自此OLE DB成为微软的新宠。
ODBC、OLE DB都是底层的数据库访问接口，使用起来不是很方便、容易，大家YY的时间又被占用的，为此微软决定再次解放大家、所以就出来了ADO的概念。很显然这是一个对象，就是对OLE DB、ODBC的高层封装，把大家经常要做的数据库操作都给直接提供出来，大家的YY时间再次被解救回来了。
不过在这期间Sun公司也没闲着，为了更大层次的解救JAVA程序猿们的YY时间，就单独写了一套专门用于JAVA的数据库访问接口JDBC，听名字就知道是山寨创意了。换汤不换药，唯一的好处就是java代码里调用会更舒服，自己家养的东西肯定用起来更顺手。
当然sun除了山寨创意外，还保留了对ODBC的调用接口【JDBC-ODBC桥】，以防不时之需；这样万一有一天除了一个新的东西只有ODBC支持，JDBC不支持。这时还不至于太有压力。当然ODBC的支持也是目前最广的，某些非主流的数据库文件的访问接口也都支持，所以还是留一手的好。
这样的话，数据库访问方式就开始明朗了。见下：
这样看来，用途最广、最底层的就是ODBC了。基本所有其它的都会可能调用它，JDBC、OLE DB是一个等级的；一个是sun的，一个是微软的；ADO不是直接访问的程序，只是一个访问快速通道而已。
注：所有的链接方式都需要本机有相应的驱动，而驱动是和具体的数据库是对应的。这样就会有3类驱动类型，每类访问N种数据库都要N个驱动。
MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AMMySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand
MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AMToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith
MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AMToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters
MySQL: String Data Types and ENUMs?May 13, 2025 am 12:05 AMMySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.
MySQL BLOB: how to optimize BLOBs requestsMay 13, 2025 am 12:03 AMOptimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.
Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AMMastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.
Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AMChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic
MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AMBest practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
SublimeText3 Chinese version
Chinese version, very easy to use
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
Dreamweaver Mac version
Visual web development tools
