数据访问对象或内联方法
我对 Actionscript 还很陌生，并且对 Flex 也有一定的了解。我正在开发一个在下面运行 SQLite 数据库的 AIR 应用程序。数据库只有 3 个表（项目、项目和类型）。我想知道 Actionscript 最佳实践是否是使用数据访问对象或层来存储我的所有数据库函数，或者只是根据需要内联运行它们。我认为访问层最适合与数据库交互以提高可用性，但我似乎在 AIR 中找不到太多有关 SQLite 的文档。
I am still very new to Actionscript and have an okay working knowledge of Flex. I am working on an AIR application that runs a SQLite database underneath. The database is only 3 tables (projects, items and types). I was wondering if Actionscript best practices are to use a data access object or layer to store all of my database functions or to just run them inline as needed. I would assume an access layer would be best for interacting with the database for usability, but I can't seem to find much documentation for SQLite in AIR.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这在一定程度上取决于应用程序的复杂性，但一般来说，我建议对数据库访问使用抽象。关键是创建一个应用程序将与之对话的接口，然后提供 SQLite 实现。好处是您可以轻松创建用于测试的存根或模拟实现，并且可以创建与其他技术交互的新实现。 Spring ActionScript 框架有一些很好的实用程序来实现这一点。
我在此处回答了类似的问题。
It depends a bit on the complexity of your application, but in general I would propose using an abstraction over the database access. The key is to create an interface that your application will talk to and then provide a SQLite implementation. The benefit is that you can easily create a stub or mock implementation for testing and you can create new implementation that talk to other technologies. The Spring ActionScript framework has some good utilities to achieve this.
I responded to a similar question here.