<%--
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"%>
项目赛程
<%
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("'");
}
%>
| 项目类型 |
比赛名称 |
比赛队伍 |
赛后比分 |
比赛时间 |
场馆名字 |
|
|
|
|
|
|