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;
}
