public Size getSizeByTenSize(String tenSize) { Size s = null; Connection conn = DBUtils.getConnection(); PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement("SELECT * FROM tbl_size WHERE TenSize=?"); stm.setString(1, tenSize); rs = stm.executeQuery(); if (rs.next()) { s = new Size(); s.setMaSize(rs.getInt("MaSize")); s.setTenSize(rs.getString("TenSize")); } } catch (SQLException e) { System.err.println(e.getErrorCode() + ":" + e.getMessage()); } finally { DBUtils.closeAll(conn, stm, rs); } return s; }
public List<Size> getAllSize() { List<Size> list = new ArrayList<Size>(); Connection conn = DBUtils.getConnection(); PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement("SELECT * FROM tbl_size ORDER BY TenSize"); rs = stm.executeQuery(); while (rs.next()) { Size s = new Size(); s.setMaSize(rs.getInt("MaSize")); s.setTenSize(rs.getString("TenSize")); list.add(s); } } catch (SQLException e) { System.err.println(e.getErrorCode() + ":" + e.getMessage()); } finally { DBUtils.closeAll(conn, stm, rs); } return list; }