📄 home.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>赛事安排</title>
<%@page language="java" contentType="text/html;charset=utf-8" %>
<%@page import="sql_db.ConnSql"%>
<%@page import="sql_db_remote.ConnSql_remote"%>
<%@page import="java.sql.*"%>
</head>
<body>
<table align="center" width="90%" height="50">
<tr>
<td width="90"><a href="queryMOMT.jsp">上下行查询</a></td>
<td width="90"><a href="home.jsp">赛事安排</a></td>
<td width="110"><a href="news.jsp?type=1">赛前各队综合分析</a></td>
<td width="110"><a href="news.jsp?type=2">临场专家博彩推荐</a></td>
<td width="100"><a href="news.jsp?type=3">PK终极推介</a></td>
<td width="100"><a href="news.jsp?type=4">各洲际赔率信息</a></td>
<td width="100"><a href="news.jsp?type=6">世界杯热点资讯</a></td>
<td width="100"><a href="news.jsp?type=7">明星动态及趣事</a></td>
<td ><a href=""></a></td>
</tr>
</table>
<%
String action;
String TeamA_Score;
String TeamB_Score;
String Result;
String Id; //比赛Id
String TeamA;
String TeamB;
String MatchDT;
String Coach_Best;
String Player_Best;
if (request.getParameter("action")==null){
action="view";
}else{
action=request.getParameter("action");
}
if (request.getParameter("TeamA_Score")==null){
TeamA_Score="-1";
}else{
TeamA_Score=request.getParameter("TeamA_Score");
int i=0;
while (i<TeamA_Score.length()){
if (java.lang.Character.isDigit(TeamA_Score.charAt(i))){
i++;
}else{
i=TeamA_Score.length();
TeamA_Score="-1";
}
}
}
if (request.getParameter("TeamB_Score")==null){
TeamB_Score="-1";
}else{
TeamB_Score=request.getParameter("TeamB_Score");
int j=0;
while (j<TeamB_Score.length()){
if (java.lang.Character.isDigit(TeamB_Score.charAt(j))){
j++;
}else{
j=TeamB_Score.length();
TeamB_Score="-1";
}
}
}
if (request.getParameter("TeamA")==null){
TeamA="";
}else{
TeamA=request.getParameter("TeamA");
TeamA=new String(TeamA.getBytes("8859_1"),"utf-8");
}
if (request.getParameter("TeamB")==null){
TeamB="";
}else{
TeamB=request.getParameter("TeamB");
TeamB=new String(TeamB.getBytes("8859_1"),"utf-8");
}
if (request.getParameter("Coach_Best")==null){
Coach_Best="";
}else{
Coach_Best=request.getParameter("Coach_Best");
Coach_Best=new String(Coach_Best.getBytes("8859_1"),"utf-8");
}
if (request.getParameter("Player_Best")==null){
Player_Best="";
}else{
Player_Best=request.getParameter("Player_Best");
Player_Best=new String(Player_Best.getBytes("8859_1"),"utf-8");
}
if (request.getParameter("MatchDT")==null){
MatchDT="";
}else{
MatchDT=request.getParameter("MatchDT");
MatchDT=new String(MatchDT.getBytes("8859_1"),"utf-8");
}
if (request.getParameter("Id")==null){
Id="";
}else{
Id=request.getParameter("Id");
}
boolean isValid;
String sql;
ConnSql connSql = new ConnSql();
connSql.setConnectDatabase();
if (action.compareTo("add")==0){
if (TeamA.length()==0||TeamB.length()==0||MatchDT.length()==0){
out.println("信息输入不完整!");
//alert("信息输入不完整");
}else{
//sql="insert into [220.231.152.180].db_bcbb.dbo.wap_Scheme(TeamA,TeamB,TeamA_Score,TeamB_Score,MatchDT,State) values('"+TeamA+"','"+TeamB+"',-1,-1,'"+MatchDT+"',1)";
sql="insert into [220.231.152.180].db_bcbb.dbo.wap_Scheme(MatchId,TeamA,TeamB,TeamA_Score,TeamB_Score,Coach_Best,Player_Best,MatchDT,State) select max(MatchId)+1,'"+TeamA+"','"+TeamB+"',-1,-1,'','','"+MatchDT+"',1 from [220.231.152.180].db_bcbb.dbo.wap_scheme where 0=DATEDIFF(day,MatchDT,'"+MatchDT+"')";
if (connSql.executeUpdate(sql) != 1){
out.println("插入数据库出错,可能时间输入不正确!");
}
}
}
if (action.compareTo("alt")==0){
if (TeamA_Score.compareTo(TeamB_Score)==0)
Result="1";
else if (TeamA_Score.compareTo(TeamB_Score)>0)
Result="3";
else
Result="0";
sql="update opendatasource('sqloledb','Data Source=220.231.152.180;User ID=sa;Password=vQms5W').db_bcbb.dbo.wap_Scheme set TeamA_Score="+TeamA_Score+",TeamB_Score="+TeamB_Score+",Coach_Best='"+Coach_Best+"',Player_Best='"+Player_Best+"',Result="+Result+",State=3 where Id="+Id;
if (connSql.executeUpdate(sql) !=1 ){
out.println("修改比分时，操作数据库出错!");
}
}
if (action.compareTo("del")==0){
sql="delete from [220.231.152.180].db_bcbb.dbo.wap_Scheme where Id="+Id;
connSql.executeUpdate(sql);
}
sql="select Id,TeamA,TeamB,isnull(TeamA_Score,-1) as TeamA_Score,isnull(TeamB_Score,-1) as TeamB_Score,Coach_Best,Player_Best,MatchDT,State=case State when 1 then '未比赛' when 2 then '比赛进行中' when 3 then '比赛结束' end from [220.231.152.180].db_bcbb.dbo.wap_Scheme order by MatchDT";
ResultSet rs;
rs=connSql.executeQuery(sql);
%>
<table border="1" align="center" width="85%" height="50">
<tr bgcolor="DDDDDD">
<td width="10%">国家队A</td>
<td width="10%">国家队B</td>
<td width="10%">A队进球数</td>
<td width="10%">B队进球数</td>
<td width="10%">最佳教练</td>
<td width="10%">最佳球员</td>
<td width="15%">开赛时间</td>
<td width="10%">比赛状态</td>
<td>操作</td>
</tr>
<%while (rs.next()){%>
<tr>
<td><%=rs.getString("TeamA")%></td>
<td><%=rs.getString("TeamB")%></td>
<td><%=rs.getString("TeamA_Score")%></td>
<td><%=rs.getString("TeamB_Score")%></td>
<td> <%=rs.getString("Coach_Best")%></td>
<td> <%=rs.getString("Player_Best")%></td>
<td><%=rs.getString("MatchDT")%></td>
<td><%=rs.getString("State")%></td>
<td><a href="home.jsp?action=del&Id=<%=rs.getString("Id")%>">删除</a>
<a href="scores.jsp?Id=<%=rs.getString("Id")%>">填写结果</a></td>
</tr>
<%}%>
</table>
<form action="home.jsp" method="post">
<table align="center" width="85%" height="50">
<tr><td>国家队A
<input type="text" name="TeamA">
</td>
<td>国家队B
<input type="text" name="TeamB">
</td>
<td>开赛时间 <input type="text" name="MatchDT">(格式:2006-04-08 09:20:00)
</td>
<td> </td></tr>
<tr><td colspan=4>
<input type="hidden" name="action" value="add">
<input type="submit" value="增加赛事">
</td>
</tr>
</talbe>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -