Advertisement
Guest User

Database Query (Java)

a guest
Feb 15th, 2013
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.13 KB | None | 0 0
  1.  public void getSalesData() {
  2.         try {
  3.             Connection con = DriverManager.getConnection(connectionUrl);
  4.             //Get all records from table
  5.             String SQL = "EXEC dbo.Order_Information";
  6.             try (Statement stmt = con.createStatement(); ResultSet rs =
  7.                             stmt.executeQuery(SQL)) {
  8.                 while (rs.next()) {
  9.  
  10.                     todayTot = Double.parseDouble(rs.getString(7));
  11.                     weekTot = Double.parseDouble(rs.getString(8));
  12.                     monthTot = Double.parseDouble(rs.getString(9));
  13.                     yearTot = Double.parseDouble(rs.getString(10));
  14.                     yearTar = Double.parseDouble(rs.getString(11));
  15.                     monthTar = Double.parseDouble(rs.getString(12));
  16.                     weekTar = Double.parseDouble(rs.getString(13));
  17.                     todayTar = Double.parseDouble(rs.getString(14));
  18.                     deltaValue = Double.parseDouble(rs.getString(17));
  19.  
  20.                     yearPer = yearTot / yearTar * 100;
  21.                     monthPer = monthTot / monthTar * 100;
  22.                     weekPer = weekTot / weekTar * 100;
  23.                     todayPer = todayTot / todayTar * 100;
  24.  
  25.                     todayTotal.setText("£" + formatter.format(todayTot));
  26.                     weekTotal.setText("£" + formatter.format(weekTot));
  27.                     monthTotal.setText("£" + formatter.format(monthTot));
  28.                     yearTotal.setText("£" + formatter.format(yearTot));
  29.                     yearTarget.setText("£" + formatter.format(yearTar));
  30.                     monthTarget.setText("£" + formatter.format(monthTar));
  31.                     weekTarget.setText("£" + formatter.format(weekTar));
  32.                     todayTarget.setText("£" + formatter.format(todayTar));
  33.                     yearPercent.setText(percentFormatter.format(yearPer) + "%");
  34.                     currentDelta.setText("Current Delta (Week Ends): £"
  35.                             + formatter.format(deltaValue));
  36.                 }
  37.             }
  38.  
  39.         } catch (SQLException | NumberFormatException e) {
  40.         }
  41.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement