我在 .jsp 文件中创建了它。当我运行它时，我的 if else 语句不起作用。它运行没有错误，但 if else 语句没有得到实现。如何从数据库中检索数据，然后以 if else 语句的形式使用检索到的数据进行检查。数据库表具有 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>
暮色呼如
慕婉清6462132
相关分类