📄 scores.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 Id; //比赛Id
if (request.getParameter("Id")==null){
Id="";
}else{
Id=request.getParameter("Id");
}
String sql;
ConnSql connSql = new ConnSql();
connSql.setConnectDatabase();
sql="select TeamA,TeamB from [220.231.152.180].db_bcbb.dbo.wap_Scheme where Id="+Id;
ResultSet rs;
rs=connSql.executeQuery(sql);
rs.next();
%>
<form action="home.jsp" method="post">
<table align="center" width="50%" height="50" bgcolor="EECC11">
<tr>
<td width="40%" align="center"><%=rs.getString("TeamA")%></td>
<td width="5%">VS</td>
<td width="20%" align="center"><%=rs.getString("TeamB")%> </td>
<td> </td></tr>
<tr>
<td align="center">进球：<input type="text" name="TeamA_Score" size="10" maxlength="2"></td>
<td> : </td>
<td><input type="text" name="TeamB_Score" size="10" maxlength="2"> </td>
<td> </td></tr>
<tr><td align="center" colspan=2>最佳教练</td><td colspan=2><input type="text" name="Coach_Best" maxlength="20"></td> </tr>
<tr><td align="center" colspan=2>最佳球员</td><td colspan=2><input type="text" name="Player_Best" maxlength="20"></td> </tr>
<tr><td colspan=3 align="right">
<input type="hidden" name="action" value="alt">
<input type="hidden" name="Id" value="<%=Id%>">
<input type="submit" value="完成">
</td><td> </td>
</tr>
</talbe>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -