@Override
public List<VipadVO> getVipadByMember(String member_id) {
List<VipadVO> list = new ArrayList<VipadVO>();
VipadVO vipadVO = null;
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, userid, passwd);
pstmt = con.prepareStatement(GET_VIPAD_BY_MEMBER);
pstmt.setString(1, member_id);
rs = pstmt.executeQuery();
while (rs.next()) {
// empVO 也稱為 Domain objects
vipadVO = new VipadVO();
vipadVO.setVid(rs.getInt("vid"));
vipadVO.setMember_id(rs.getString("member_id"));
vipadVO.setGid(rs.getInt("gid"));
vipadVO.setJoindate(rs.getTimestamp("joindate"));
vipadVO.setQuitdate(rs.getTimestamp("quitdate"));
vipadVO.setStatus(rs.getInt("status"));
list.add(vipadVO); // Store the row in the list
}
// Handle any driver errors
} catch (ClassNotFoundException e) {
throw new RuntimeException("Couldn't load database driver. " + e.getMessage());
// Handle any SQL errors
} catch (SQLException se) {
throw new RuntimeException("A database error occured. " + se.getMessage());
// Clean up JDBC resources
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException se) {
se.printStackTrace(System.err);
}
}
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException se) {
se.printStackTrace(System.err);
}
}
if (con != null) {
try {
con.close();
} catch (Exception e) {
e.printStackTrace(System.err);
}
}
}
return list;
}
@Override
public VipadVO findByPrimaryKey(Integer vid) {
VipadVO vipadVO = null;
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, userid, passwd);
pstmt = con.prepareStatement(GET_ONE_STMT);
pstmt.setInt(1, vid);
rs = pstmt.executeQuery();
while (rs.next()) {
// empVo 也稱為 Domain objects
vipadVO = new VipadVO();
vipadVO.setVid(rs.getInt("vid"));
vipadVO.setMember_id(rs.getString("member_id"));
vipadVO.setGid(rs.getInt("gid"));
vipadVO.setJoindate(rs.getTimestamp("joindate"));
vipadVO.setQuitdate(rs.getTimestamp("quitdate"));
vipadVO.setStatus(rs.getInt("status"));
}
// Handle any driver errors
} catch (ClassNotFoundException e) {
throw new RuntimeException("Couldn't load database driver. " + e.getMessage());
// Handle any SQL errors
} catch (SQLException se) {
throw new RuntimeException("A database error occured. " + se.getMessage());
// Clean up JDBC resources
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException se) {
se.printStackTrace(System.err);
}
}
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException se) {
se.printStackTrace(System.err);
}
}
if (con != null) {
try {
con.close();
} catch (Exception e) {
e.printStackTrace(System.err);
}
}
}
return vipadVO;
}
