我在 .jsp 文件中創(chuàng)建了它。當我運行它時，我的 if else 語句不起作用。它運行沒有錯誤，但 if else 語句沒有得到實現(xiàn)。如何從數(shù)據(jù)庫中檢索數(shù)據(jù)，然后以 if else 語句的形式使用檢索到的數(shù)據(jù)進行檢查。數(shù)據(jù)庫表具有 Orderid 和 dstatus 列，它們都是字符串值。<html> <head> <body> <div class="button_box2"> <form action="trackingtest.jsp" method="POST"> <input type="text" name="Orderid" placeholder="Enter Order ID here..." required> <button type="submit">Search</button> </form> </div> </body><%! public class track { Connection connection = null; PreparedStatement ps = null; ResultSet rs = null; public track() { try { connection = DBConnector.getConnection(); ps = connection.prepareStatement("select * from Payroll.status where Orderid = ?"); rs = ps.executeQuery(); } catch (Exception e) { e.printStackTrace(); } } public ResultSet gettrack(String Orderid) { try { ps.setString(1, Orderid); rs = ps.executeQuery(); } catch (Exception e) { e.printStackTrace(); } return rs; } }%><% String Orderid = new String(); if (request.getParameter("Orderid") != null) { Orderid = request.getParameter("Orderid"); } track t1 = new track(); ResultSet rs = t1.gettrack(Orderid);%> <% while (rs.next()) { String Status = rs.getString("dstatus"); if (Status.equals("Processing")) { System.out.print(Status + "1"); } else if (Status.equals("Out")) { System.out.print(Status + "2"); } else if (Status.equals("Delivered")){ System.out.print(Status + "3"); } } %> </body> </html>
在結(jié)果集之后使用 If - Else
慕工程0101907
2021-06-28 08:23:35
