mysql jdbc 示例_JDBC简单示例（MySQL）

1.在数据库建立表tab_stud，并插入一些测试数据：

CREATE TABLE tab_stud

(

stud_no INT primary key,

stud_name VARCHAR(20) not null,

birthday DATE not null

);

INSERT INTO tab_stud VALUES(1001, 'huey', '2001-01-01');

INSERT INTO tab_stud VALUES(1002, 'sugar', '2002-02-02');

INSERT INTO tab_stud VALUES(1003, 'jing', '2003-03-03');

2.Student实体：

package com.huey.jdbc;

import java.text.DateFormat;

import java.util.Date;

/**

* @version 2013-07-14

* @author huey2672

*

*/

public class Student {

private int number;

private String name;

private Date birthday;

public int getNumber() {

return number;

}

public void setNumber(int number) {

this.number = number;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public Date getBirthday() {

return birthday;

}

public void setBirthday(Date birthday) {

this.birthday = birthday;

}

public Student() {

}

public Student(int number, String name, Date birthday) {

setNumber(number);

setName(name);

setBirthday(birthday);

}

@Override

public String toString() {

return String.format("No.%d: %s, %s",

number, name,

DateFormat.getDateInstance().format(birthday));

}

}

3.JDBC示例代码：

package com.huey.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Date;

/**

* @version 2013-07-14

* @author huey2672

*

*/

public class TestDB {

public static void main(String[] args) {

Connection conn = null;

try {

// 加载驱动

Class.forName("com.mysql.jdbc.Driver");

// 数据库连接url

String url = "jdbc:mysql://localhost:3306/mydb";

// 获取数据库连接

conn = DriverManager.getConnection(url, "root", "******");

String sql = "SELECT stud_no, stud_name, birthday FROM tab_stud";

// 获取PreparedStatement对象

PreparedStatement ps = conn.prepareStatement(sql);

// 执行查询获取结果集

ResultSet rs = ps.executeQuery();

// 迭代结果集

while (rs.next()) {

int number = rs.getInt("stud_no");

String name = rs.getString("stud_name");

Date birthday = rs.getDate("birthday");

Student student = new Student(number, name, birthday);

System.out.println(student);

}

if (rs != null) {

// 关闭结果集

rs.close();

}

if (ps != null) {

// 关闭PreparedStatement对象

ps.close();

}

if (conn != null) {

// 关闭数据库连接

conn.close();

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

4.结果输出：

No.1001: huey, 2001-1-1

No.1002: sugar, 2002-2-2

No.1003: jing, 2003-3-3

5.补充：

几种流行的JDBC数据库URL格式：

RDBMS

数据库URL格式

MySQL

jdbc:mysql://hostname:portNumber/databaseName

ORACLE

jdbc:oracle:thin:@hostname:portNumber/databaseName

DB2

jdbc:db2:hostname:portNumber/databaseName

PostgreSQL

jdbc:postgre://hostname:portNumber/databaseName

SQL Server

jdbc:sqlserver://hostname:portNumber;databaseName=databaseName

Sybase

jdbc:sybase:Tds:hostname:portNumber/databaseName