DriverManager

java.sql.DriverManager [1]

私は一連のJDBC(Java DataBase Connectivity)ドライバを管理します。

メソッド

• getConnection - 指定データベースURLへの接続を試みる

例

static final String URL = "jdbc:mysql://localhost:3306/day_results";
static final String USER = "yoosuke";
static final String PASSWD = "hoge";

public static ArrayList<Item> itemGet() {
try (Connection con = DriverManager.getConnection(URL, USER, PASSWD);) {
    Statement stm = con.createStatement();
    String sql = "SELECT * FROM pfmc ORDER BY date desc LIMIT 15";
    ResultSet rs = stm.executeQuery(sql);
   
    ArrayList<Item> items = new ArrayList<Item>();
    while (rs.next()) {
    Item item = new Item();
    item.setDate(rs.getString("date"));
    item.setScTime(rs.getString("sc_time"));
    item.setStTime(rs.getString("st_time"));
    item.setJogg(rs.getString("jogg"));
    items.add(item);
    }   
    rs.close();
    stm.close();
    return items;
} catch (Exception e) {
    e.printStackTrace();
    return null;
}
}