JDBC
9
In addition, download and install MySQL Administrator as well
as MySQL Query Browser. These are GUI based tools that will make
your development much easier.
Finally, download and unzip MySQL Connector/J (the MySQL JDBC
driver) in a convenient directory. For the purpose of this tutorial, we will
assume that you have installed the driver at C:\Program
Files\MySQL\mysql-connector-java-5.1.8.
Accordingly, set CLASSPATH variable to C:\Program Files\MySQL\mysql-
connector-java-5.1.8\mysql-connector-java-5.1.8-bin.jar. Your driver
version may vary based on your installation.
PostgreSQL DB: PostgreSQL is an open source database. You can
download it from PostgreSQL Official Site.
The Postgres installation contains a GUI based administrative tool called
pgAdmin III. JDBC drivers are also included as part of the installation.
Oracle DB: Oracle DB is a commercial database sold by Oracle. We
assume that you have the necessary distribution media to install it.
Oracle installation includes a GUI based administrative tool called
Enterprise Manager. JDBC drivers are also included as a part of the
installation.
Install Database Drivers
The latest JDK includes a JDBC-ODBC Bridge driver that makes most Open
Database Connectivity (ODBC) drivers available to programmers using the JDBC
API.
Now-a-days, most of the Database vendors are supplying appropriate JDBC
drivers along with Database installation. So, you should not worry about this
part.
Set Database Credential
For this tutorial we are going to use MySQL database. When you install any of
the above database, its administrator ID is set to root and gives provision to set
a password of your choice.
Using root ID and password you can either create another user ID and
password, or you can use root ID and password for your JDBC application.
There are various database operations like database creation and deletion, which
would need administrator ID and password.
For rest of the JDBC tutorial, we would use MySQL Database with username as
ID and password as password.
剩余161页未读，继续阅读
LimitedEditio
- 粉丝: 0
- 资源: 3
我的内容管理
展开
最新资源
- 构建Cadence PSpice仿真模型库教程
- VMware 10.0安装指南：步骤详解与网络、文件共享解决方案
- 中国互联网20周年必读：影响行业的100本经典书籍
- SQL Server 2000 Analysis Services的经典MDX查询示例
- VC6.0 MFC操作Excel教程：亲测Win7下的应用与保存技巧
- 使用Python NetworkX处理网络图
- 科技驱动：计算机控制技术的革新与应用
- MF-1型机器人硬件与robobasic编程详解
- ADC性能指标解析：超越位数、SNR和谐波
- 通用示波器改造为逻辑分析仪：0-1字符显示与电路设计
- C++实现TCP控制台客户端
- SOA架构下ESB在卷烟厂的信息整合与决策支持
- 三维人脸识别：技术进展与应用解析
- 单张人脸图像的眼镜边框自动去除方法
- C语言绘制图形：余弦曲线与正弦函数示例
- Matlab 文件操作入门：fopen、fclose、fprintf、fscanf 等函数使用详解
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
