mysql jdbcの使用
3186 ワード
まずライブラリpetdbを作成し、 テーブルpettableをもう1つ作成し、データを追加します.jdbcを使用して読み出します.
import java.sql.*;
/**
* Created by chuiyuan on 2/6/16.
*/
public class mysql {
/**
* JDBC driver name and database URL
*/
static final String DB_NAME="petdb";
static final String TABLE_NAME="pettable";
static final String JDBC_DRIVER ="com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/"+DB_NAME;
/**
* database credentials
*/
static final String USER = "petuser";
static final String PASSWD = "petpwd";
public static void main(String [] args){
Connection conn = null ;
Statement stmt = null;
try {
/**
* register jdbc driver
*/
Class.forName(JDBC_DRIVER);
/**
* open a connection
*/
System.out.println("Connect to databse ....");
conn = DriverManager.getConnection(DB_URL, USER, PASSWD);
/**
* execute a query
*/
System.out.println("creating statement");
stmt = conn.createStatement() ;
String sql;
sql = "select * from "+ TABLE_NAME;
ResultSet rs = stmt.executeQuery(sql);
/**
* extract data from result set
*/
while (rs.next()){
//retrive by last column name
String name = rs.getString("name");
String species = rs.getString("species");
//Date birth = rs.getDate("birth");
Date death = rs.getDate("death") ;
//display
System.out.print("name:"+ name);
System.out.print(", species:"+ species);
//System.out.print(", birth:"+birth);
System.out.println(", death:"+ death);
}
/**
* clean up environment
*/
rs.close();
stmt.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}finally {
/**
* used to close resources
*/
try {
if (stmt!=null){
stmt.close();
}
}catch (SQLException se){
se.printStackTrace();
}
try {
if (conn!=null){
conn.close();
}
}catch (SQLException se1){
se1.printStackTrace();
}
}
}
}