Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void getSalesData() {
- try {
- Connection con = DriverManager.getConnection(connectionUrl);
- //Get all records from table
- String SQL = "EXEC dbo.Order_Information";
- try (Statement stmt = con.createStatement(); ResultSet rs =
- stmt.executeQuery(SQL)) {
- while (rs.next()) {
- todayTot = Double.parseDouble(rs.getString(7));
- weekTot = Double.parseDouble(rs.getString(8));
- monthTot = Double.parseDouble(rs.getString(9));
- yearTot = Double.parseDouble(rs.getString(10));
- yearTar = Double.parseDouble(rs.getString(11));
- monthTar = Double.parseDouble(rs.getString(12));
- weekTar = Double.parseDouble(rs.getString(13));
- todayTar = Double.parseDouble(rs.getString(14));
- deltaValue = Double.parseDouble(rs.getString(17));
- yearPer = yearTot / yearTar * 100;
- monthPer = monthTot / monthTar * 100;
- weekPer = weekTot / weekTar * 100;
- todayPer = todayTot / todayTar * 100;
- todayTotal.setText("£" + formatter.format(todayTot));
- weekTotal.setText("£" + formatter.format(weekTot));
- monthTotal.setText("£" + formatter.format(monthTot));
- yearTotal.setText("£" + formatter.format(yearTot));
- yearTarget.setText("£" + formatter.format(yearTar));
- monthTarget.setText("£" + formatter.format(monthTar));
- weekTarget.setText("£" + formatter.format(weekTar));
- todayTarget.setText("£" + formatter.format(todayTar));
- yearPercent.setText(percentFormatter.format(yearPer) + "%");
- currentDelta.setText("Current Delta (Week Ends): £"
- + formatter.format(deltaValue));
- }
- }
- } catch (SQLException | NumberFormatException e) {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement