我問自己如何a.rowname使用 jbdc sqlite 在 Java 中列印。或者我是否采取了錯誤的解決方案來獲取所有選定的資料？
我試過這個：
String vergleichVon ="DB_18_12_2021_02h13m05s";
String vergleichBis ="DB_18_12_2021_08h28m19s";
Connection connection = null;
try
{
//Connect to Database
connection = DriverManager.getConnection("jdbc:sqlite:" dataBasePath "");
Statement c = connection.createStatement();
c.setQueryTimeout(30); // set timeout to 30 sec.
ResultSet rs = c.executeQuery("SELECT a.name, a.pt, b.pt, a.sz, a.bd"
"FROM " vergleichVon " AS a, " vergleichBis " AS b "
"WHERE a.name= b.name AND a.pt>'1000' AND b.pt>='1000' AND a.pt!='n/v' AND b.pt!='n/v' "
"ORDER BY a.pt DESC");
while(rs.next())
{
// read the result set
System.out.print("nameA = " rs.getString("a.name"));
System.out.print(" ");
System.out.println("ptB = " rs.getString("b.pt"));
}
}
我收到這個錯誤：
no such column: 'a.name'
在 Python 中，它的作業方式是這樣的。稍后我可以從陣列中獲取 Selected 資料：
c.execute('''SELECT a.name, a.pt, b.pt, a.sz, a.bd
FROM ''' vergleich_von ''' AS a, ''' vergleich_bis ''' AS b
WHERE a.name= b.name AND a.pt>'1000' AND b.pt>='1000' AND a.pt!='n/v' AND b.pt!='n/v'
ORDER BY a.pt DESC''')
array = c.fetchall()
uj5u.com熱心網友回復：
你沒有選擇 a.spieler
嘗試：
ResultSet rs = c.executeQuery("SELECT a.name as spieler, a.pt, b.pt as bpt, a.sz, a.bd"
"FROM " vergleichVon " AS a, " vergleichBis " AS b "
"WHERE a.name= b.name AND a.pt>'1000' AND b.pt>='1000' AND a.pt!='n/v' AND b.pt!='n/v' "
"ORDER BY a.pt DESC");
while(rs.next())
{
// read the result set
System.out.print("nameA = " rs.getString("spieler"));
System.out.print(" ");
System.out.println("ptB = " rs.getString("bpt"));
}
問題編輯后更新 對不帶點的列使用別名：
ResultSet rs = c.executeQuery("SELECT a.name as name, a.pt as apt, b.pt as bpt, a.sz as asz, a.bd as adb"
"FROM " vergleichVon " AS a, " vergleichBis " AS b "
"WHERE a.name= b.name AND a.pt>'1000' AND b.pt>='1000' AND a.pt!='n/v' AND b.pt!='n/v' "
"ORDER BY a.pt DESC");
while(rs.next())
{
// read the result set
System.out.print("nameA = " rs.getString("name"));
System.out.print(" ");
System.out.println("ptB = " rs.getString("bpt"));
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/385363.html