從中獲取字符串名稱變量JTextField我正在嘗試從數據庫中匹配該列值并獲取該列的所有行值public User1 getUserDestination(String name){ try{ //String s="Select * FROM trainschedule WHERE Destination="+name1; rs=stm.executeQuery("SELECT * FROM trainschedule WHERE Destination="+name); // rs=stm.executeQuery(s); if(rs.next()){ user1=new User1(); user1.setTrainNo(Integer.parseInt(rs.getString("Train_No"))); user1.setTrainName((rs.getString("tName"))); user1.setDeparture((rs.getString("Departure"))); user1.setDepartureTime((rs.getString("dTime"))); user1.setArrival((rs.getString("Arrival"))); user1.setArrivalTime((rs.getString("aTime"))); user1.setTicketPrice((rs.getString("Ticket_Price"))); System.out.println(user1.getTrainName()); return user1; } else{ return null; } }catch(Exception e){ e.printStackTrace(); } return null;}總是給我這樣的sql異常Unknown column in 'where clause' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97).
如何修復來自 mysql 數據庫的 ComboBox getSelectedItem() 匹配
慕碼人2483693
2022-10-20 17:05:58
