Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://192.168.43.222:3306/car_info","app","app123");
- Statement stmt = con.createStatement();
- String minusStr = String.valueOf(minus);
- ResultSet rs = stmt.executeQuery("select * from CAR_PROC where DATE(DAY) = DATE(ADDDATE(SYSDATE(), -"+ minusStr +"));");
- boolean hasResult = false;
- while(rs.next()) {
- hasResult=true;
- avgSpeed = String.format("%.2f",rs.getFloat(3));
- avgFuelCon = String.format("%.2f",rs.getFloat(4)/1000.0);
- idleTime = String.valueOf(rs.getInt(5));
- fuelUsed = String.format("%.2f",rs.getFloat(6));
- distanceTravelled = String.format("%.2f",rs.getFloat(7)/1000.0);
- topSpeed = String.valueOf(rs.getFloat(8));
- idleFuelUsed = String.format("%.2f",rs.getFloat(9)*1000);
- publishProgress(avgSpeed, topSpeed, avgFuelCon, idleTime, fuelUsed, idleFuelUsed, distanceTravelled);
- }
- if (!hasResult){
- publishProgress("0", "0", "0", "0", "0", "0", "0");
- }
- con.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement