@Override
public void readAllordersDB() {
Order order;
int n = 0;
try {
// STEP 2: Register JDBC driver
// Class.forName("JDBC_DRIVER");
// STEP 3: Open a connection
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
// STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql =
"SELECT id, dateAndTime, addr1, addr2, addr34, distance, orderCost, "
+ "customerPhone, customerName, carNumber, carDriver, isDone FROM ordersdb";
ResultSet rs = stmt.executeQuery(sql);
// STEP 5: Extract data from result set
while (rs.next()) {
order = new Order();
order.setId(rs.getInt("id"));
order.setDateAndTime(rs.getTimestamp("dateAndTime"));
order.setAddr1(rs.getString("addr1"));
order.setAddr2(rs.getString("addr2"));
order.setAddr34(rs.getString("addr34"));
order.setDistance(rs.getFloat("distance"));
order.setOrderCost(rs.getFloat("orderCost"));
order.setCustomerPhone(rs.getString("customerPhone"));
order.setCustomerName(rs.getString("customerName"));
order.setCarNumber(rs.getString("carNumber"));
order.setCarDriver(rs.getString("carDriver"));
order.setIsDone(((rs.getInt("isDone")) != 0));
orderDB.orderAdd(order);
n++;
}
// STEP 6: Clean-up environment
rs.close();
stmt.close();
conn.close();
} catch (SQLException se) {
// Handle errors for JDBC
se.printStackTrace();
} catch (Exception e) {
// Handle errors for Class.forName
e.printStackTrace();
} finally { // finally block used to close resources
try {
if (stmt != null) stmt.close();
} catch (SQLException se2) {
} // nothing we can do
try {
if (conn != null) conn.close();
} catch (SQLException se) {
se.printStackTrace();
}
}
System.out.println("Read operation from DB done. Readed " + n + " Orders.");
}
