我写追踪RFID标签的运动,因为它RFID检查员之间移动的计划。这是模仿房间之间钱包的移动。每个检查员将是一个门不同的房间。
我持有的卡,该位置的名称SQLite数据库,并且标签的名称不同卡之间进行区分。
我需要一个ArrayList,它告诉我,目前在数据库上什么标签。
我具有如图显示在一个ArrayList数据库并将其存储的所有值的DAO方法:
SELECT * FROM Wallets;
[name: Henry, location: 0, tag: 5c00ce6df0, name: jim, location: 0, tag: wallet1]
我想写只会显示这样的标签的另一个DAO的方法:
SELECT Tag FROM Wallets;
[5c00ce6df0, wallet1]
一旦我保存在一个ArrayList这些值我打算将它们传递到其需要的标签,并返回所有相关信息,这样另一个DAO的方法:
SELECT * FROM Wallets WHERE Tag = 'wallet1';
name: jim, location: 0, tag: wallet1
这里是我的getAllWallets() DAO的代码:
public ArrayList getAllWallets() throws SQLException{
Connection dbConnection = null;
Statement statement = null;
ResultSet resultset = null;
String query = "SELECT * FROM Wallets;";
ArrayList list = new ArrayList<>();
try {
dbConnection = getDBConnection();
statement = dbConnection.createStatement();
System.out.println(query);
// execute SQL query
resultset = statement.executeQuery(query);
while (resultset.next()) {
Wallet w = new Wallet(query, 0, query);
w.setName(resultset.getString("Name"));
w.setLocation(resultset.getInt("Location"));
w.setTag(resultset.getString("Tag"));
list.add(w);
}
}
catch (SQLException e) {
System.out.println(e.getMessage());
}
finally
{
resultset.close();
statement.close();
dbConnection.close();
}
return list;
}
以下是我迄今为止尝试了我getWalletTag() DAO:
public ArrayList getWalletTag() throws SQLException {
Connection dbConnection = null;
ResultSet resultset = null;
Statement statement = null;
ArrayList list = new ArrayList();
String query = "SELECT Tag FROM Wallets;";
try {
dbConnection = getDBConnection();
statement = dbConnection.createStatement();
// execute SQL query
System.out.println(query);
resultset = statement.executeQuery(query);
String tag = tag.toString(); // i know this is totally wrong but i got stuck
list.add(tag);
}
catch (SQLException e) {
System.out.println(e.getMessage());
}
finally
{
if (resultset != null) {
resultset.close();
}
if (statement != null) {
statement.close();
}
if (dbConnection != null) {
dbConnection.close();
}
}
return list;
}
我所挣扎的是如何得到Tag列的所有值到一个数组列表。是否有捷径可寻?任何帮助将不胜感激。谢谢。