📄 do_1stprocess_add_by_s.jsp
字号:
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<jsp:useBean id="initrial" class="com.db.Train" scope="page"/>
<jsp:useBean id="couldAdd" class="com.db.Common" scope="page"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>添加路线步骤二</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/mm_lodging1.css" type="text/css">
</head>
<%
request.setCharacterEncoding("gb2312");
if(session.getAttribute("isLogin")==null)
{
%>
<jsp:forward page="../login/login.html"/>
<%
}
String train_serial=request.getParameter("train_serial");
session.setAttribute("train_serial",train_serial);
String stations_num=request.getParameter("stations_num");
session.setAttribute("stations_num",stations_num);
int num=Integer.parseInt(stations_num);
String start_station=request.getParameter("start_station");
String end_station=request.getParameter("end_station");
String train_type=request.getParameter("train_type");
String whole_mileage=request.getParameter("whole_mileage");
int whol_milge=Integer.parseInt(whole_mileage);
String hard_seat_extant_num=request.getParameter("hard_seat_extant_num");
int h_s_num=Integer.parseInt(hard_seat_extant_num);
String soft_seat_extant_num=request.getParameter("soft_seat_extant_num");
int s_s_num=Integer.parseInt(soft_seat_extant_num);
String hard_recumbency_extant_num=request.getParameter("hard_recumbency_extant_num");
int h_r_num=Integer.parseInt(hard_recumbency_extant_num);
String soft_recumbency_extant_num=request.getParameter("soft_recumbency_extant_num");
int s_r_num=Integer.parseInt(soft_recumbency_extant_num);
if(couldAdd.getCould("select * from traininf where train_serial='"+train_serial+"'"))
{
initrial.InitrialTrainInf(train_serial,train_type,start_station,end_station,num,whol_milge,h_s_num,s_s_num,h_r_num,s_r_num);
String sql_1="create table "+train_serial+"_stations_inf(train_serial varchar(20) primary key,";
String sql_2="create table "+train_serial+"_start_time(train_serial varchar(20) primary key,";
String sql_3="create table "+train_serial+"_to_time(train_serial varchar(20) primary key,";
String sql_4="create table "+train_serial+"_hard_seat_price(train_serial varchar(20) primary key,";
String sql_5="create table "+train_serial+"_soft_seat_price(train_serial varchar(20) primary key,";
String sql_6="create table "+train_serial+"_hard_recumbency_price(train_serial varchar(20) primary key,";
String sql_7="create table "+train_serial+"_soft_recumbency_price(train_serial varchar(20) primary key,";
for(int i=0;i<num;i++)
{
sql_1=sql_1+""+(i+1)+"th_station_name varchar(20) not null,";
}
for(int i=1;i<num;i++)
{
sql_2=sql_2+""+i+"th_start_time varchar(20) not null,";
sql_3=sql_3+"to_"+(i+1)+"th_time varchar(20) not null,";
sql_4=sql_4+""+i+"th_part_price float not null,";
sql_5=sql_5+""+i+"th_part_price float not null,";
sql_6=sql_6+""+i+"th_part_price float not null,";
sql_7=sql_7+""+i+"th_part_price float not null,";
}
String[] sql={sql_1,sql_2,sql_3,sql_4,sql_5,sql_6,sql_7};
String last_sense="foreign key(train_serial) references traininf(train_serial))";
for(int i=1;i<=7;i++)
{
sql[i-1]=sql[i-1]+last_sense;
initrial.createNewTrain(sql[i-1]);
}
}
else
{
%>
<jsp:forward page="../error/system_admin_error.jsp"/>
<%
}
%>
<body text=#003300 vLink=#002200 leftMargin=0 topMargin=0>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr width="600">
<td><img src="../image/16.gif"></td>
</tr>
</table>
<table cellSpacing=0 cellPadding=0 width=600 align="center" bgcolor="#033D7C">
<TBODY>
<tr width="600" bgcolor="#a4c2c2">
<td height="36" colspan="3" id="navigation" class="navText" align="center"><a href="../system_admin/index.jsp">首页</a>
<a href="../user/admin_by_s_admin.jsp">用户管理</a> <a href="../admin/admin_by_s_admin.jsp">管理员管理</a>
<a href="../admin/add_by_s.jsp">添加管理员</a> <a href="../ticket/add_by_s.jsp">添加火车票</a>
<a href="../train/1stProcess_add_by_s.jsp">添加列车路线</a> <a href="../common/exit.jsp">退出</a> </td>
</tr>
</TBODY>
</table>
<br><br>
<form action="../train/do_2stProcess_add_by_s.jsp" method="post">
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
<font size="2">添加列车路线步骤二</font>
</td>
</tr>
</table>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<%
for(int i=1;i<=num;i++)
{
%>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
<font size="2">站<%=i%>的名称：</font>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<input type="text" name="station_<%=i%>">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<%
}
%>
<tr>
<td width="600" align="right" bgcolor="#EBEBEB">
<input type="submit" value="下一步">
</td>
<td width="600" align="left" bgcolor="#EBEBEB">
<input type="reset" value="取消">
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -