1、JDBC是一种底层API，在访问数据库是需要在业务逻辑中直接嵌入SQL语句。JDBC不能够直接访问数据库，必须依赖数据库厂商提供的JDBC驱动程序来实现Java程序与MySql的交互。http://dev.mysql.com/downloads/connector/点击“Connector/J”链接
2、在打开的页面，点Platform Independent (Architecture Independent), ZIP Archive(mysql-connector-java-5.1.38.zip)后面的“download”链接Tips:当然下载“Platform Independent (Architecture Independent), Compressed TAR Archiv”(mysql-connector-java-5.1.38.tar.gz)也可以
3、在打开的页面，点击下面的“No thanks, just start my download.”链接http://120.52.72.59/cdn.mysql.com/c3pr90ntcsf0//Downloads/Connector-J/mysql-connector-java-5.1.38.zipTips:当然，注册一个帐户，然后再下载也可以
4、解压缩下载的mysql-connector-java-5.1.38.zip找到我们需要的mysql-connector-java-5.1.38-bin.jar
5、把mysql-connector-java-5.1.38-bin.jar添加到Project的依赖中
6、万事俱备，只剩下老揉孟阼写代码Code:package jdbc;import java.sql.*;/** * Creat髫潋啜缅ed by MyWorld on 2016/4/4. */public class JDBCForMysql { public static void main(String[] args) { Connection conn = null; Statement statement = null; ResultSet resultSet = null; try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8"; conn = DriverManager.getConnection(url, "mysql", "mysql"); System.out.println("Connection status, isClosed: " + conn.isClosed()); statement = conn.createStatement(); statement.executeUpdate("CREATE TABLE IF NOT EXISTS staff (id varchar(20),name varchar(20),lastModifiedTime datetime)"); for (int i = 0; i < 10; i++) { String sql = String.format("insert into staff (id,name,lastModifiedTime) values('%s','%s',current_timestamp()) ", "no" + i, "name" + i); statement.addBatch(sql); } statement.executeBatch(); resultSet = statement.executeQuery("select id,name,lastModifiedTime from staff"); ResultSetMetaData metaData = resultSet.getMetaData(); int columnCount = metaData.getColumnCount(); for (int i = 1; i <= columnCount; i++) { System.out.print(metaData.getColumnLabel(i) + "\t"); } System.out.println(""); while (resultSet.next()) { for (int i = 1; i <= columnCount; i++) { System.out.print(resultSet.getString(i) + "\t"); } System.out.println(""); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException ignored) { } } if (statement != null) { try { statement.close(); } catch (SQLException ignored) { } } if (conn != null) { try { conn.close(); } catch (SQLException ignored) { } } } }}
7、执行下看看结果：Output:Connection status, isClosed: falseid na罪焐芡拂me lastModifiedTime no0 name0 2016-04-04 16:47:02.0 no1 name1 2016-04-04 16:47:03.0 no2 name2 2016-04-04 16:47:03.0 no3 name3 2016-04-04 16:47:03.0 no4 name4 2016-04-04 16:47:03.0 no5 name5 2016-04-04 16:47:03.0 no6 name6 2016-04-04 16:47:04.0 no7 name7 2016-04-04 16:47:04.0 no8 name8 2016-04-04 16:47:04.0 no9 name9 2016-04-04 16:47:04.0
