JDBC SQL Select 기본 예제

try {

conn = DBUtil.getConnection();

st = conn.createStatement();

// user_id 조회

String users_sql = "select user_id from users;

rs = st.executeQuery(users_sql);

while (rs.next()) {

user_id = rs.getString(1);

System.out.println("user_id : " + user_id);

}

rs.close();

} catch (SQLException e) {

e.printStackTrace();

} finally {

if (rs != null)

rs.close();

}

}