mirror of
https://github.com/wahyd4/wahyd4.github.com.git
synced 2026-08-21 03:25:57 +10:00
65 lines
7.9 KiB
Markdown
65 lines
7.9 KiB
Markdown
---
|
|
title: 一个Java JDBC连接简单实例
|
|
author: wahyd4
|
|
comments: true
|
|
excerpt: >
|
|
今天在学习java JDBC,这里写了一个简单的java 连接Mysql
|
|
数据库的实例供大家参考。此代码代码可以运行。
|
|
layout: post
|
|
permalink: /2010/11/java-jdbc/
|
|
categories:
|
|
- 我说
|
|
tags:
|
|
- java
|
|
- JDBC
|
|
---
|
|
<div style="background: #fdfdfd; color: black;">
|
|
今天在学习java JDBC,这里写了一个简单的java 连接Mysql 数据库的实例供大家参考。此代码代码可以运行。
|
|
</div>
|
|
|
|
<div style="background: #fdfdfd; color: black;">
|
|
需要注意的是如果你在Eclipse 或者 My Eclipse 里面运行这个代码，你需要下载mysql 数据库的JDBC驱动程序,下载在mysql 官方网站下载即可。并将包里面的mysql-connector-java-5.1.1-bin.jar加入到build path 里面即可（注：这个5.1.1是我下载的connector 版本号，你们的可能不一样。）
|
|
</div>
|
|
|
|
<div style="background: #fdfdfd; color: black;">
|
|
下面就是代码
|
|
</div>
|
|
|
|
<div style="background: #fdfdfd; color: black;">
|
|
<span style="text-decoration: underline;">Java语言</span>:
|
|
</div>
|
|
|
|
<div class="source" style="font-family: '[object HTMLOptionElement]', Consolas, 'Lucida Console', 'Courier New'; color: #000000; background-color: #f9f7ed;">
|
|
<p>
|
|
<span style="color: #000000;">import</span> <span style="color: #000000;">java.sql.*</span>;
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000080; font-weight: bold;">public</span> <span style="color: #000080; font-weight: bold;">class</span> <span style="color: #000000;">TestJDBC</span> <span style="color: #000000;">{</span><br /> <span style="color: #000080; font-weight: bold;">public</span> <span style="color: #000080; font-weight: bold;">static</span> <span style="color: #000080; font-weight: bold;">void</span> <span style="color: #000000;">main</span>(<span style="color: #000000;">String</span><span style="color: #000000;">[]</span> <span style="color: #000000;">args</span>) <span style="color: #000080; font-weight: bold;">throws</span> <span style="color: #000000;">Exception</span> <span style="color: #000000;">{</span><br /> <span style="color: #000000;">String</span> <span style="color: #000000;">user</span> <span style="color: #000000;">=</span> <span style="color: #0000ff;">“root”</span>;<br /> <span style="color: #000000;">String</span> <span style="color: #000000;">pwd</span> <span style="color: #000000;">=</span> <span style="color: #0000ff;">“root”</span>;<br /> <span style="color: #000000;">String</span> <span style="color: #000000;">conJDBC</span> <span style="color: #000000;">=</span> <span style="color: #0000ff;">“jdbc:mysql://localhost:3306/jdbc”</span>;<span style="color: #008800; font-style: italic;">// 设置连接JDBC地址</span><br /> <span style="color: #000000;">Class</span><span style="color: #000000;">.</span><span style="color: #ff0000;">forName</span>(<span style="color: #0000ff;">“com.mysql.jdbc.Driver”</span>); <span style="color: #008800; font-style: italic;">// 加载驱动</span>
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000000;">Connection</span> <span style="color: #000000;">conn</span> <span style="color: #000000;">=</span> <span style="color: #000000;">DriverManager</span><span style="color: #000000;">.</span><span style="color: #ff0000;">getConnection</span>(<span style="color: #000000;">conJDBC</span><span style="color: #000000;">,</span> <span style="color: #000000;">user</span><span style="color: #000000;">,</span> <span style="color: #000000;">pwd</span>);<span style="color: #008800; font-style: italic;">// 创建连接</span>
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000000;">Statement</span> <span style="color: #000000;">stmt</span> <span style="color: #000000;">=</span> <span style="color: #000000;">conn</span><span style="color: #000000;">.</span><span style="color: #ff0000;">createStatement</span>();<span style="color: #008800; font-style: italic;">// 创建执行语句对象</span><br /> <span style="color: #000000;">ResultSet</span> <span style="color: #000000;">res</span> <span style="color: #000000;">=</span> <span style="color: #000000;">stmt</span><span style="color: #000000;">.</span><span style="color: #ff0000;">executeQuery</span>(<span style="color: #0000ff;">“SELECT *FROM stdinfo”</span>);<span style="color: #008800; font-style: italic;">// 执行语句，获取结果</span>
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000080; font-weight: bold;">while</span> (<span style="color: #000000;">res</span><span style="color: #000000;">.</span><span style="color: #ff0000;">next</span>()) <span style="color: #000000;">{</span>
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000000;">System</span><span style="color: #000000;">.</span><span style="color: #ff0000;">out</span><span style="color: #000000;">.</span><span style="color: #ff0000;">println</span>(<span style="color: #000000;">res</span><span style="color: #000000;">.</span><span style="color: #ff0000;">getInt</span>(<span style="color: #0000ff;">“id”</span><span style="color: #000000;">)+</span><span style="color: #0000ff;">“,”</span><span style="color: #000000;">+</span><span style="color: #000000;">res</span><span style="color: #000000;">.</span><span style="color: #ff0000;">getString</span>(<span style="color: #0000ff;">“name”</span><span style="color: #000000;">)+</span><span style="color: #0000ff;">“,”</span><span style="color: #000000;">+</span><span style="color: #000000;">res</span><span style="color: #000000;">.</span><span style="color: #ff0000;">getInt</span>(<span style="color: #0000ff;">“age”</span>));<span style="color: #008800; font-style: italic;">// 输出对象</span><br /> <span style="color: #000000;">}</span><br /> <span style="color: #000080; font-weight: bold;">try</span> <span style="color: #000000;">{</span><br /> <span style="color: #000080; font-weight: bold;">if</span> (<span style="color: #000000;">res</span> <span style="color: #000000;">!=</span> <span style="color: #000080; font-weight: bold;">null</span>) <span style="color: #000000;">{</span><br /> <span style="color: #000000;">res</span><span style="color: #000000;">.</span><span style="color: #ff0000;">close</span>(); <span style="color: #008800; font-style: italic;">// 处理异常，关闭 ResultSet 对象</span><br /> <span style="color: #000000;">}</span><br /> <span style="color: #000000;">}</span> <span style="color: #000080; font-weight: bold;">catch</span> (<span style="color: #000000;">Exception</span> <span style="color: #000000;">e</span>) <span style="color: #000000;">{</span><br /> <span style="color: #000000;">e</span><span style="color: #000000;">.</span><span style="color: #ff0000;">printStackTrace</span>();<br /> <span style="color: #000000;">}</span> <span style="color: #000080; font-weight: bold;">finally</span> <span style="color: #000000;">{</span><br /> <span style="color: #000080; font-weight: bold;">try</span> <span style="color: #000000;">{</span><br /> <span style="color: #000080; font-weight: bold;">if</span> (<span style="color: #000000;">conn</span> <span style="color: #000000;">!=</span> <span style="color: #000080; font-weight: bold;">null</span>) <span style="color: #000000;">{</span><br /> <span style="color: #000000;">conn</span><span style="color: #000000;">.</span><span style="color: #ff0000;">close</span>(); <span style="color: #008800; font-style: italic;">// 关闭 Connecton 对象</span><br /> <span style="color: #000000;">}</span><br /> <span style="color: #000000;">}</span> <span style="color: #000080; font-weight: bold;">catch</span> (<span style="color: #000000;">Exception</span> <span style="color: #000000;">e</span>) <span style="color: #000000;">{</span><br /> <span style="color: #000000;">e</span><span style="color: #000000;">.</span><span style="color: #ff0000;">printStackTrace</span>();<br /> <span style="color: #000000;">}</span><br /> <span style="color: #000000;">}</span>
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000000;">}</span>
|
|
</p>
|
|
|
|
<p>
|
|
<span style="color: #000000;">}</span>
|
|
</p>
|
|
</div>
|