efforts.
The JDBC standard is divided into two parts: the application development interface for application developers and the developer (usually database vendor) interface for database drivers. In the JDBC standard, the driver is divided into four types by operation.
Type 1:jdbc-
different URL .The 3.JDBC DatabaseMetaData interface provides a range of methods to check the DBMS's support for specific features and determine what features are in order to support the characteristics of a particular database 4.JDBC also supports multiple database connections in the application, and JDBC makes it easy to access multiple heterogeneous databases
I used jdbc to connect to the database before writing the program. Suddenly I learned how to connect to the database using odbc. I found that there is a difference between the two.JDBCClass. forName ("database driver name"); // such as com. microsoft. jdbc. sqlserver. string url = "
Tags: What is JDBC? JDBC, called Java Database Connectivity Standard, is an object-oriented application interface (API) that allows access to a variety of relational databases. JDBC is also part of the Java Core Class library. The most important feature of JDBC is that it is independent of the specific relational d
independent of a specific database and neither is NBSP;NBSP; The difference between them: we know that ODBC is almost able to connect almost all of the databases on all platforms. Why doesn't Java use ODBC? The answer is: Java is able to use ODBC. But preferably in the form of Jdbc-
Brief Introduction
JDBC has no special features in terms of technology. It is nothing more than an access standard similar to ODBC, which is independent of the database vendor and shared by the world. I even doubt that Sun's design of Java is actually just a language mechanism for database access. I never thought that JDBC would have a huge impact later.
Four
JDBC Driver Uncover
A common source of confusion for Java is that JDBC has different versions, and JDBC drivers have different types that can be used by different versions of Java. Also, the new Java specification is always under development because the related functionality is continually being extended through the J
Tags: javaJava database Connection (JDBC-ODBC mode) Environment: Win7 64-bit and NetBeans IDE 7.1.2 jdk1.7.0_17 (64-bit) Write the program and run the error: java.sql.SQLException: [MICROSOFT][ODBC Driver Manager] in the specified DSN, the architecture between the driver a
Use Access to create a database. Assume that you can save it as D: mydata. mdb to connect to the Access database in two ways: directly using the Access driver, and using the DSN link. We first define several variables in the method, filePath refers to the address of the database file, url is the string linking the database, dbDriver is JDBC-OD
Use Access to create a database. Assume that you can save it as
preceding two cases, the newly loaded driver class must be self-registered by calling the drivermanager. registerdriver class. As described above, this process is automatically executed when a class is loaded.
For security reasons, the JDBC management layer will track which class loader provides which driver. In this way, when the drivermanager class opens the
Create a database with access, and save it as D:/mydata. MDB.
There are two ways to connect to the Access Database: one is to directly use the access driver, and the other is to use the DSN link. We first define several variables in the method, filepath refers to the address of the database file, URL is the string linking the database, dbdriver is the JDBC-ODBC
/* Demo JDBC-ODBC Bridge connection* 1. Configure the data source* 2. Connect to the data source in the program**/Package Shujuku;Import java.sql.*;public class Test1{public static void Main (string[] args){Connection Ct=null;Statement Sm=null;try {1. Load the driver (add the required
String url = new string ();Url = "JDBC: ODBC: Psy ";/*A database identification method is provided to enable the corresponding driverProgramIdentifies the database and establishes a connection with it.JDBC: Sub-Protocol: ODBC; Sub-Name: Local ODBC Data Source PsyODBC is a special case. The complete syntax is:
that the QueryString parameter does not contain the page parameter. The first page of data is displayed.
IntPage=1;
} Else {
// Converts a string to an integer.
IntPage=Java. Lang. Integer. parseInt (strPage );
If (intPage1)IntPage=1;}
// Load the JDBC-ODBC driver
Class. forName ("sun. jdbc.
Operationimpl () method. Of course, there are often more than one method in the actual system.Methods in an abstract hierarchical structure implement their own functionality by delegating to the corresponding implementation object, which means that the abstract role can achieve the purpose of dynamically transforming its own functionality by delegating to different implementation objects .Advantages of bridge modeseparating abstraction and implementa
For jsp servers set up in windows, and the system is relatively small, using access is a good choice, but to use an access database usually through the data source. Here we provide a method to directly connect to the data source without using the data source using java. The example program is as follows: importjava. SQL. *; publicclassAccess {publicstaticvoidmain (Strin AccessJDBCODBC
For jsp servers set up in windows, and the system is relatively small, using access is a good choice, but t
ArticleDirectory
Sometimes in W7, ODBC data source driverProgramOnly SQL
Many people have encountered similar problems.
In some versions, you can [access "Administrative Tools" from the "control panel" and then access "Data Source (ODBC)"] as follows: CMD enter % WinDir % \ syswow64 [There are 32-bit programs in it! A lot!] You can also manually enter and run odbcad32.exe, And the settings are the
The JDBC ODBC brige driver is the driver for the JSP connection database, which is installed by default as long as the JDK is installed.To configure a JDBC ODBC data source: http://blog.csdn.net/lissdy/article/details/7059828Creat
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.