在最后一個<%=rs.getString("results")%>下面的我的 jsp 檔案中,結果回傳 3 個不同的結果,分別為 W、L 和 D。如何使用 if 顯示綠色的 W、紅色的 L 和黃色的 D條件和/或其他宣告?
如果有任何問題,我在此鏈接中添加了代碼:https ://codeshare.io/EBbOyO
提前感謝那些愿意提供幫助的人。
<table class="table ">
<thead>
<tr class="d-flex">
<th class="text-center col-xs-1" style="width:1%" scope="col">Week</th>
<th class="text-center col-xs-1" scope="col">Match Date</th>
<th class="text-left col-xs-1" scope="col">Home</th>
<th class="text-left col-xs-1" scope="col">Away</th>
<th class="text-center col-xs-1" style="width:5%" scope="col">Home Score</th>
<th class="text-center col-xs-1" style="width:5%" scope="col">Away Score</th>
<th class="text-center col-xs-1" style="width:5%" scope="col">Result</th>
</tr>
<%
if(request.getParameter("uid")!=null)
{
int id=Integer.parseInt(request.getParameter("uid"));
String dburl="jdbc:mysql://localhost:3306/teams";
String dbusername="root";
String dbpassword="Fener2013";
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con=DriverManager.getConnection(dburl,dbusername,dbpassword);
PreparedStatement pstmt=null; //create statement
pstmt=con.prepareStatement("select m.week, m.match_date, t1.team_name hometeam, m.home_score as homescore, t2.team_name awayteam,m.away_score as awayscore,l.league_name, CASE WHEN m.home_score > m.away_score THEN 'W' WHEN m.home_score < m.away_score THEN 'L' WHEN m.home_score = m.away_score THEN 'D' END AS results from matches m join teams t1 on m.home_team_id = t1.team_id join teams t2 on m.away_team_id = t2.team_id join leagues l on l.league_id = m.league_id where m.home_team_id = ? or m.away_team_id = ?");
pstmt.setInt(1,id);
pstmt.setInt(2,id);
ResultSet rs=pstmt.executeQuery();
while(rs.next())
{
%>
<tbody>
<tr class="d-flex">
<td class="something col-xs-1" style="width:1%"><%=rs.getString("m.week")%></td>
<td class="something col-xs-1" ><%=rs.getString("m.match_date")%></td>
<td class="text-left col-xs-1" ><%=rs.getString("hometeam")%></td>
<td class="text-left col-xs-1" ><%=rs.getString("awayteam")%></td>
<td class="something col-xs-1" style="width:5%" ><%=rs.getString("homescore")%></td>
<td class="something col-xs-1" style="width:5%" ><%=rs.getString("awayscore")%></td>
<!-- Below Strings returns 3 different result as W,L and D. How can I show W for green, L for red and D for yellow for using if or other statement? -->
<td class="something col-xs-1" style="width:5%"> <span class="label label-success"><%=rs.getString("results")%></span></td>
</tr>
</tbody>
<%
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
%>
</table>
uj5u.com熱心網友回復:
<span class='label label-success color-<%=rs.getString("results")%>'><%=rs.getString("results")%></span>
您可以將結果傳遞給類,并添加樣式
<style>
.color-W{
color:green;
}
.color-L{
color:red;
}
.color-D{
color:yellow;
}
</style>
轉載請註明出處,本文鏈接:https://www.uj5u.com/ruanti/427210.html
