Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.util.List;
- import java.util.ArrayList;
- // 商品マスタテーブルアクセス用クラス
- public class ItemDAO {
- // 接続文字列
- private static final String CONNECTION_STR =
- "jdbc:oracle:thin:@//172.16.4.6:1521/infopdb";
- // DB接続ユーザー名
- private static final String DB_USER = "demo2017";
- // DB接続パスワード
- private static final String DB_PASSWD = "demo2017";
- // 全件検索用メソッド
- public static List<Item> findAll() throws SQLException {
- List<Item> list = new ArrayList<>();
- Connection con =
- DriverManager.getConnection(CONNECTION_STR, DB_USER, DB_PASSWD);
- Statement stmt = ((Connection) con).createStatement();
- ResultSet rs = ((Statement) stmt).executeQuery("SELECT 商品id, 商品名, 卸単価 FROM 商品マスタ");
- while (((ResultSet) rs).next()) {
- list.add(new Item(rs.getInt("商品id"), rs.getString("商品名"), rs.getInt("卸単価")));
- }
- return list;
- }
- }
Add Comment
Please, Sign In to add comment