Advertisement
Guest User

sdf

a guest
Nov 15th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.33 KB | None | 0 0
  1. try {
  2.             Class.forName("com.mysql.jdbc.Driver");
  3.             Connection con = DriverManager.getConnection("jdbc:mysql://192.168.43.222:3306/car_info","app","app123");
  4.             Statement stmt = con.createStatement();
  5.             String minusStr = String.valueOf(minus);
  6.             ResultSet rs = stmt.executeQuery("select * from CAR_PROC where DATE(DAY) = DATE(ADDDATE(SYSDATE(), -"+ minusStr +"));");
  7.             boolean hasResult = false;
  8.             while(rs.next()) {
  9.                 hasResult=true;
  10.                 avgSpeed = String.format("%.2f",rs.getFloat(3));
  11.                 avgFuelCon = String.format("%.2f",rs.getFloat(4)/1000.0);
  12.                 idleTime = String.valueOf(rs.getInt(5));
  13.                 fuelUsed = String.format("%.2f",rs.getFloat(6));
  14.                 distanceTravelled = String.format("%.2f",rs.getFloat(7)/1000.0);
  15.                 topSpeed = String.valueOf(rs.getFloat(8));
  16.                 idleFuelUsed = String.format("%.2f",rs.getFloat(9)*1000);
  17.                 publishProgress(avgSpeed, topSpeed, avgFuelCon, idleTime, fuelUsed, idleFuelUsed, distanceTravelled);
  18.             }
  19.             if (!hasResult){
  20.                 publishProgress("0", "0", "0", "0", "0", "0", "0");
  21.             }
  22.             con.close();
  23.         } catch (Exception e) {
  24.             e.printStackTrace();
  25.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement