学习记录（3.13）
学习时长：5h
代码行数：约400行
今天又到了一周一度的软工课时间，我们先结成了两两小组，在学习完理论知识后，在课堂练习环节进行了结队作业。总体上来说是制作一个北京地铁的查询系统，但是第三个功能属实有点让人摸不到头脑，不知道具体该怎样显示路线，如果始末站在一条线还好说，但是如果需要换乘了该怎么办呢？
之后我们在课上实现了第一个功能——选择线路查询线路中的所有站点，我们还输出了该站是否为换乘车站帮助用户换成，优化用户体验。
<%@ page language= "java" contentType= "text/html; charset=UTF-8"
pageEncoding= "UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta charset="UTF-8">
<h1 align = "center">欢迎使用地铁查询系统</h1><br>
</head>
<body>
<form action="line_back.jsp" method="post">
<table align="center" border="1" width="500">
<tr>
<td>
<input type="radio" name="line" value="一号线">地铁一号线
</td>
<td>
<input type="radio" name="line" value="二号线">地铁二号线
</td>
</tr>
<tr>
<td>
<input type="radio" name="line" value="四号线">地铁四号线
</td>
<td>
<input type="radio" name="line" value="五号线">地铁五号线
</td>
</tr>
<tr>
<td>
<input type="radio" name="line" value="六号线">地铁六号线
</td>
<td>
<input type="radio" name="line" value="七号线">地铁七号线
</td>
</tr>
<tr>
<td>
<input type="radio" name="line" value="八号线">地铁八号线
</td>
<td>
<input type="radio" name="line" value="二号线">地铁二号线
</td>
</tr>
</table>
<center><input type="submit" name="查询" value="查询"></center>
</form>
</body>
</html>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="com.util.Util" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>站点浏览</title>
</head>
<body>
<table align= "center" border="1" cellspacing="0" style="text-align:center;">
<tr>
<td align="center" width=10%>No</td>
<td align="center" width=10%>路过线路</td>
<td align="center" width=10%>是否可换乘</td>
</tr>
<%
String no = (String)request.getParameter("station");
Connection connection = Util.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
int i=1;
try {
String sql = "select * from main";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
if(no.equals(rs.getObject(1)))
{
//重要
String zhanming= (String) rs.getObject(1);
session.setAttribute("zhanming",zhanming);
%>
<tr>
<td align="center"><%=i %></td>
<td align="center"><%=rs.getObject(2) %></td>
<td align="center"><%=rs.getObject(4) %></td>
</tr>
<%
i++;
}
}
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
Util.close(rs);
Util.close(preparedStatement);
Util.close(connection);
}
%>
</table>
<center><input type="button" value="返回菜单" onclick="location.href='Menu.jsp'" /> <br></center>
</p>
</body>
</html>
<%@ page language= "java" contentType= "text/html; charset=UTF-8"
pageEncoding= "UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta charset="UTF-8">
<h1 align = "center">欢迎使用地铁查询系统</h1><br>
</head>
<body>
<form action="station_back.jsp" method="get">
<table align="center" border="1" width="500">
<tr>
<td>
<p style="text-align:center">请输入查找的站名</p>
</td>
</tr>
<tr>
<td>
<p style="text-align:center"><input type="text" name="station"></p>
</td>
</tr>
</table>
<center><input type="submit" name="查询" value="查询"></center>
</form>
</body>
</html>
<%@ page language= "java" contentType= "text/html; charset=UTF-8"
pageEncoding= "UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta charset="UTF-8">
<h1 align = "center">欢迎使用地铁查询系统</h1><br>
</head>
<body>
<form action="station_back.jsp" method="get">
<table align="center" border="1" width="500">
<tr>
<td>
<p style="text-align:center">请输入查找的站名</p>
</td>
</tr>
<tr>
<td>
<p style="text-align:center"><input type="text" name="station"></p>
</td>
</tr>
</table>
<center><input type="submit" name="查询" value="查询"></center>
</form>
</body>
</html>
package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* JDBC��������
*/
public class Util {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Connection connection = null;
PreparedStatement ps = null;
ResultSet rs = null;
Class.forName("com.mysql.cj.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/subway?useSSL=false&serverTimezone=GMT", "root", "gyh2002623");
System.out.println("连接成功");
return connection;
}
public static void close(Connection connection ) {
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(PreparedStatement preparedStatement ) {
try {
if (preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(ResultSet resultSet ) {
try {
if (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
package com.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.bean.Bean;
import com.util.Util;
public class Dao {
static public void showstation(ArrayList<Bean> people) throws ClassNotFoundException, SQLException {
String sql1 ="select * from main";
Connection connection = Util.getConnection();
try {
PreparedStatement ps = connection.prepareStatement(sql1);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
Bean A = new Bean();
A.setZhanming(rs.getString(1));
people.add(A);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
浙公网安备 33010602011771号