JDBC 入門(一)
Jun 01, 2016 pm 02:08 PMJDBC
作者:axeon
你需要做的第一事情是你要正確的安裝。這包含下列幾個步驟:
在你的計算機(jī)上安裝 Java 和 JDBC
Java 數(shù)據(jù)庫連接 (JDBC) 是一個標(biāo)準(zhǔn) SQL(Structured Query Language,結(jié)構(gòu)化查詢語言)數(shù)據(jù)庫訪問接口, 可以為多種關(guān)系數(shù)據(jù)庫提供統(tǒng)一訪問。JDBC(Java DataBase Connection,Java 數(shù)據(jù)庫連接) 也提供一種基準(zhǔn),據(jù)此可以構(gòu)建更高級的工具和接口。 目前的 JDK(Java Development Kit,Java 開發(fā)工具包)軟件捆綁包括 JDBC 和 JDBC-ODBC(Open DataBase Connection,開放式數(shù)據(jù)庫連接)橋。這些包也可獨(dú)立得到,以跟 JDK 1.0 一起使用。應(yīng)該注意的是,本文的示例使用了 JDBC 2.0 接口,需要 JDK 2.0 來運(yùn)行,不能在 JDK 1.1 下運(yùn)行。
你可以從 http://java.sun.com/products/JDK/CurrentRelease 找到最新版。
安裝驅(qū)動程序
你的驅(qū)動程序應(yīng)該有安裝方法。為特定的 DBMSs 寫的 JDBC 驅(qū)動程序安裝時只要拷貝到你的計算機(jī)上就可以了。并不需要特殊的配置。
如果你下載的是 Solaris 或 Windows JDK1.1 版本,橋作為包 sun.jdbc.odbc 與 JDK 一起自動安裝。有關(guān)安裝和配置 ODBC 的信息,請咨詢 ODBC 驅(qū)動程序廠商。橋無須特殊配置。有關(guān)客戶機(jī)安裝和配置信息,請咨詢數(shù)據(jù)庫廠商。
如果需要,安裝數(shù)據(jù)庫系統(tǒng)
如果你不能確認(rèn)是否安裝了數(shù)據(jù)庫系統(tǒng),你需要按照供應(yīng)商的要求安裝數(shù)據(jù)庫。大多數(shù)用戶都已經(jīng)安裝了數(shù)據(jù)庫,可繼續(xù)使用他們安裝好的數(shù)據(jù)庫。
配置數(shù)據(jù)庫
我們假設(shè)數(shù)據(jù)庫 COFFEEBREAK 已經(jīng)存在。(創(chuàng)建一個數(shù)據(jù)庫并不困難,但需要一定的權(quán)限并通常是由數(shù)據(jù)庫管理員來做)你還需要在此數(shù)據(jù)庫里創(chuàng)建本教程作為例子使用的表。我們有意限制表的大小跟及數(shù)目,以便于管理。
假設(shè)我們的數(shù)據(jù)庫是在一個咖啡館里使用, 咖啡豆按磅賣,而咖啡則以杯為單位。為了簡單起見,還假定經(jīng)營者只需要 2 張表,分別存放不同種類的咖啡及咖啡供應(yīng)商的有關(guān)信息。
首先我們演示怎么打開一個 DBMS 連接, 及 JDBC 是怎么發(fā)送 SQL 語句到你的 DBMS。通過這些代碼,我們將表明使用 JDBC 傳遞 SQL 語句到你的 DBMS 并處理返回的結(jié)果是非常簡單的。
所有的代碼在主要的幾個 DBMS 產(chǎn)品做了測試。然而, 如果你使用 JDBC-ODBC 橋來連接舊版本 ODBC 驅(qū)動程序時,可能會遇到一些兼容性問題

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

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

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

There are three common methods to traverse Map in Java: 1. Use entrySet to obtain keys and values at the same time, which is suitable for most scenarios; 2. Use keySet or values to traverse keys or values respectively; 3. Use Java8's forEach to simplify the code structure. entrySet returns a Set set containing all key-value pairs, and each loop gets the Map.Entry object, suitable for frequent access to keys and values; if only keys or values are required, you can call keySet() or values() respectively, or you can get the value through map.get(key) when traversing the keys; Java 8 can use forEach((key,value)->

In Java, Comparable is used to define default sorting rules internally, and Comparator is used to define multiple sorting logic externally. 1.Comparable is an interface implemented by the class itself. It defines the natural order by rewriting the compareTo() method. It is suitable for classes with fixed and most commonly used sorting methods, such as String or Integer. 2. Comparator is an externally defined functional interface, implemented through the compare() method, suitable for situations where multiple sorting methods are required for the same class, the class source code cannot be modified, or the sorting logic is often changed. The difference between the two is that Comparable can only define a sorting logic and needs to modify the class itself, while Compar

To deal with character encoding problems in Java, the key is to clearly specify the encoding used at each step. 1. Always specify encoding when reading and writing text, use InputStreamReader and OutputStreamWriter and pass in an explicit character set to avoid relying on system default encoding. 2. Make sure both ends are consistent when processing strings on the network boundary, set the correct Content-Type header and explicitly specify the encoding with the library. 3. Use String.getBytes() and newString(byte[]) with caution, and always manually specify StandardCharsets.UTF_8 to avoid data corruption caused by platform differences. In short, by

JavaScript data types are divided into primitive types and reference types. Primitive types include string, number, boolean, null, undefined, and symbol. The values are immutable and copies are copied when assigning values, so they do not affect each other; reference types such as objects, arrays and functions store memory addresses, and variables pointing to the same object will affect each other. Typeof and instanceof can be used to determine types, but pay attention to the historical issues of typeofnull. Understanding these two types of differences can help write more stable and reliable code.

HashMap implements key-value pair storage through hash tables in Java, and its core lies in quickly positioning data locations. 1. First use the hashCode() method of the key to generate a hash value and convert it into an array index through bit operations; 2. Different objects may generate the same hash value, resulting in conflicts. At this time, the node is mounted in the form of a linked list. After JDK8, the linked list is too long (default length 8) and it will be converted to a red and black tree to improve efficiency; 3. When using a custom class as a key, the equals() and hashCode() methods must be rewritten; 4. HashMap dynamically expands capacity. When the number of elements exceeds the capacity and multiplies by the load factor (default 0.75), expand and rehash; 5. HashMap is not thread-safe, and Concu should be used in multithreaded

InJava,thestatickeywordmeansamemberbelongstotheclassitself,nottoinstances.Staticvariablesaresharedacrossallinstancesandaccessedwithoutobjectcreation,usefulforglobaltrackingorconstants.Staticmethodsoperateattheclasslevel,cannotaccessnon-staticmembers,

std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)

ReentrantLock provides more flexible thread control in Java than synchronized. 1. It supports non-blocking acquisition locks (tryLock()), lock acquisition with timeout (tryLock(longtimeout, TimeUnitunit)) and interruptible wait locks; 2. Allows fair locks to avoid thread hunger; 3. Supports multiple condition variables to achieve a more refined wait/notification mechanism; 4. Need to manually release the lock, unlock() must be called in finally blocks to avoid resource leakage; 5. It is suitable for scenarios that require advanced synchronization control, such as custom synchronization tools or complex concurrent structures, but synchro is still recommended for simple mutual exclusion requirements.
