每日总结3.28
每日总结：
所花时间：6h
代码量：100行
博客量：1篇
————————————~~~~~~刷~~~~~————————————————
今天上课学了python，课下的主要内容其实是完善我的结对作业的web页面部分，主要是做了一丢丢的美化，这里我给一部分的结果的截图和代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>地铁查询系统</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<div style="width: 100%; font-family: 微软雅黑; text-align: center; font-size: 20pt;">地铁查询系统</div>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<div style="text-align:center">
<form action="#" method="get">
<br>
<input type="button" class="btn one" value="线路查询" onclick="location.href='linecheck.jsp'"/><br>
<br>
<input type="button" class="btn two" value="站点查询" onclick="location.href='sitecheck.jsp'" /><br>
<br>
<input type="button" class="btn three" value="起点-终点查询" onclick="location.href='star-end.jsp'" /><br>
<br>
<br>
</p>
</form>
</div>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>线路查询</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<form action="linecheck_back.jsp" method="get">
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
线路号
<input type="text" name="linename" >
<br>
<input type="submit" class="btn one" value="查询" >
</p>
</form>
</body>
</html>
<%@ page import="com.util.Util" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="com.bean.Bean" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="com.dao.Dao" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
<input type="button" class="btn one" value="返回菜单" onclick="location.href='main.jsp'" /> <br>
</p>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<table border="1" cellspacing="0" align=center >
<tr>
<td align="center" width=10%>站点</td>
<td align="center" width=10%>站点序号</td>
<td align="center" width=10%>可否换乘</td>
</tr>
<%
String linename = request.getParameter("linename");
Connection connection = Util.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from line where linename = '"+linename+"'";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
%>
<tr>
<td align="center"width=10%><%=rs.getObject(2) %>'/n'<%=rs.getObject(3) %></td>
<td align="center"width=10%><%=rs.getObject(3) %></td>
<td align="center"width=10%><%=rs.getObject(4) %></td>
</tr>
<%
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
Util.close(rs);
Util.close(preparedStatement);
Util.close(connection);
}
%>
</table>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>站点查询</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<form action="sitecheck_back.jsp" method="get">
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
站点名称
<input type="text" name="site" >
<br>
<input type="submit" class="btn two" value="查询" >
</p>
</form>
</body>
</html>
<%@ page import="com.util.Util" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="com.bean.Bean" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="com.dao.Dao" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
<input type="button" class="btn two" value="返回菜单" onclick="location.href='main.jsp'" /> <br>
</p>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<table border="1" cellspacing="0" align=center >
<tr>
<td align="center" width=10%>线路</td>
<td align="center" width=10%>站点序号</td>
<td align="center" width=10%>可否换乘</td>
</tr>
<%
String site = request.getParameter("site");
Connection connection = Util.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from line where site = '"+site+"'";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
%>
<tr>
<td align="center"width=10%><%=rs.getObject(1) %></td>
<td align="center"width=10%><%=rs.getObject(3) %></td>
<td align="center"width=10%><%=rs.getObject(4) %></td>
</tr>
<%
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
Util.close(rs);
Util.close(preparedStatement);
Util.close(connection);
}
%>
</table>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<form action="star-end_back.jsp" method="get">
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
起点
<input type="text" name="star" >
<br>
终点
<input type="text" name="end" >
<br>
<input type="submit" class="btn three" value="查询" >
</p>
</form>
</body>
</html>
<%@ page import="com.util.Util" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="com.bean.Bean" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="com.dao.Dao" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
body {
background: url(images/image2.jpg);
background-size:cover;
}
</style>
<style>
#neon-btn {
display: flex;
align-items: center;
justify-content: space-around;
height: 100vh;
background: #031628;
}
.btn {
border: 1px solid;
background-color: transparent;
text-transform: uppercase;
font-size: 14px;
padding: 10px 20px;
font-weight: 300;
}
.one {
color: #60E605;
}
.two {
color: #f038ff;
}
.three {
color: #f7452a;
}
.btn:hover {
color: white;
border: 0;
}
.one:hover {
background-color: #60E605;
-webkit-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
-moz-box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
box-shadow: 10px 10px 99px 6px rgba(76,201,240,1);
}
.two:hover {
background-color: #f038ff;
-webkit-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
box-shadow: 10px 10px 99px 6px rgba(240, 56, 255, 1);
}
.three:hover {
background-color: #f7452a;
-webkit-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
-moz-box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
box-shadow: 10px 10px 99px 6px rgba(185, 231, 105, 1);
}
</style>
</head>
<body>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
<input type="button" class="btn three" value="返回菜单" onclick="location.href='main.jsp'" /> <br>
</p>
<div id="datetime"; style="text-align: center;">
<script>
setInterval("document.getElementById('datetime').innerHTML=new Date().toLocaleString();", 1000);
</script>
</div>
<%
String star = request.getParameter("star");
String end = request.getParameter("end");
Dao dao=new Dao();
String MinLine = dao.fsecheck(star, end);
%>
<div style="width: 100%; font-family: 微软雅黑; text-align: center; font-size: 20pt;"><%=MinLine %></div>
</body>
</html>
浙公网安备 33010602011771号