在1.0.x版本,通过直接执行SQL语句获得数据的应用中,有用到prepareStatement()和executeQuery()两个方法。
在1.2.x版本中,有所更新,相应变为prepared()和execute()两个方法。
例如:
1: $con = Propel::getConnection(DATABASE_NAME);
2:
3: $sql = "SELECT books.* FROM books WHERE NOT EXISTS (SELECT id FROM review WHERE book_id = book.id)";
4: $stmt = $con->prepare($sql);
5: $stmt->execute();
6:
7: $books = BookPeer::populateObjects($stmt);