Skip to content

P
PairProject

Daisyeee / PairProject
与 Fork 源项目一致

Fork自 Lyu- / PairProject

通知 2
Star 0
Fork 1
P
PairProject

体验新版 GitCode，发现更多精彩内容 >>

切换分支/标签
查找文件 普通视图历史永久链接Permalink
scheduleSearch.jsp 3.3 KB
Newer Older
K__light's avatar
项目赛况查找  
K__light 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 
<%--
  Created by IntelliJ IDEA.
  User: K.night
  Date: 2022/3/24
  Time: 20:40
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8"%>
<%@ page import="java.io.*,java.util.*" %>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>

<html>
<head>
    <title>项目赛程</title>
</head>
<body>
    <sql:setDataSource var="snapshot" driver="com.mysql.cj.jdbc.Driver"
                             url="jdbc:mysql://localhost:3306/o_rank?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai"
                             user="root"  password="111"/>


    <%
        boolean flag = false;
        String sqlString = "SELECT * from rank_table";
        String itemcodename = new String(request.getParameter("itemcodename"));
        String startdatecn = new String(request.getParameter("startdatecn"));
        String venuename = new String(request.getParameter("venuename"));

        if (!itemcodename.equals("")) {
            sqlString = sqlString.concat(" WHERE itemcodename='").concat(itemcodename).concat("'");
            flag =true;
        }
        if (!startdatecn.equals("")) {
            if (flag)
                sqlString = sqlString.concat(" AND ");
            else
                sqlString = sqlString.concat(" WHERE ");
            sqlString = sqlString.concat("DATE_FORMAT(startdatecn, '%d')='").concat(startdatecn).concat("'");
            flag =true;
        }
        if (!venuename.equals("")) {
            if (flag)
                sqlString = sqlString.concat(" AND ");
            else
                sqlString = sqlString.concat(" WHERE ");
            sqlString = sqlString.concat("venuename='").concat(venuename).concat("'");
        }
    %>
    <sql:query dataSource="${snapshot}" sql="<%=sqlString%>" var="result"></sql:query>

    <table border="1" width="100%">
        <tr>
            <th>项目类型</th>
            <th>比赛名称</th>
            <th>比赛队伍</th>
            <th>赛后比分</th>
            <th>比赛时间</th>
            <th>场馆名字</th>
        </tr>
        <c:out value="共有${row.getRow()}"/>


        <c:forEach var="row" items="${result.rows}">
            <tr>
                <td><c:out value="${row.itemcodename}"/></td>
                <td><c:out value="${row.title} "/></td>
                <td>
                    <c:if test="${row.homename != \"\"}">
                        <c:out value="${row.homename}VS${row.awayname}"/>
                    </c:if>
                    <c:if test="${row.homename == \"\"}">
                        <c:out value="非对抗赛"/>
                    </c:if>
                </td>
                <td>
                    <c:if test="${row.homescore != \"\"}">
                        <c:out value="${row.homescore}:${row.awayscore}"/>
                    </c:if>
                    <c:if test="${row.homescore == \"\"}">
                        <c:out value="无比分信息"/>
                    </c:if>
                </td>
                <td><c:out value="${row.startdatecn}"/> </td>
                <td><c:out value="${row.venuename}"/> </td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>