模拟简单数据库表的java类
我有一组从数据库表 mtable 中提取的异构数据。然后，对于 A 列中的每个唯一值 uv，我计算一个函数 (SELECT * FROM mtable WHERE A=uv)。然后我对 B 列和 C 列执行相同的操作。有相当多的唯一值，所以我不想重复访问数据库 - 我宁愿有一个类来复制一些功能（最重要的是一些功能） SELECT WHERE 的版本）。此外，我想将列名从类定义中抽象出来，如果这有意义的话——构造函数应该采用名称列表作为参数，而且，我想，还有一个类型列表（现在这只是String[]，这看起来很hacky）。我正在从 RowSet 获取初始数据。
我或多或少通过使用将字符串映射到对象列表/数组的哈希图来完成此操作，但我一直陷入比较和类型的困境，并且我认为我当前的实现确实不如它那么干净和清晰可能是。我对java也很陌生，并且不确定我是否走上了一条完全错误的道路。 有人有什么建议吗？
I have a collection of heterogenous data that I pull from a database table mtable. Then, for every unique value uv in column A, I compute a function of (SELECT * FROM mtable WHERE A=uv). Then I do the same for column B, and column C. There are rather a lot of unique values, so I don't want to hit the db repeatedly - I would rather have a class that replicates some of the functionality (most importantly some version of SELECT WHERE). Additionally, I would like to abstract the column names away from the class definition, if that makes any sense - the constructor should take a list of names as a parameter, and also, I suppose, a list of types (right now this is just a String[], which seems hacky). I'm getting the initial data from a RowSet.
I've more or less done this by using a hashmap that maps Strings to lists/arrays of Objects, but I keep getting bogged down in comparisons and types, and am thinking that my current implementation really isn't as clean and clear as it could be. I'm pretty new to java, also, and am not sure if I'm not going down a completely incorrect path.
Does anyone have any suggestions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
你可以尝试 JoSQL，它有一种类似于 SQL 的对象集合语言。
You can try JoSQL, it has an SQL like language over collections of objects.