测试mysql数据库连接_java测试数据库连接

万事俱备，只剩下写代码

Code:

package jdbc;

import java.sql.*;

/**

* Created 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) {

}

}

}

}

}