📄 listadd.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.util.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>增加订单</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<style type="text/css">
<!--
.STYLE3 {font-family: "宋体"; font-size: 18px; }
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
String userid = (String) session.getAttribute("userid");
if (userid == null)
response.sendRedirect("../index.jsp?error=2");
%>
<%
Integer level = (Integer) session.getAttribute("level");
int l = level.intValue();
if (level == null)
response.sendRedirect("../index.jsp?error=2");
if (!(l == 2))
response.sendRedirect("../error.jsp");
%>
<%
String sql = null;
String type = null;
String Listid = null;
String bookid = null;
String classid = null;
String bookname = null;
String classname = null;
Float price = null;
Integer menbers = null;
Integer Lnumber = null;
String Ldate = null;
Integer checked = null;
String message = "";
%>
<%
request.setCharacterEncoding("GB2312");
type = request.getParameter("type");
if (type != null) {
Listid = request.getParameter("Listid");
bookid = request.getParameter("bookid");
classid = request.getParameter("classid");
bookname = request.getParameter("bookname");
classname = request.getParameter("classname");
Ldate = request.getParameter("Ldate");
price = Float.valueOf(request.getParameter("price"));
Lnumber = Integer.valueOf(request.getParameter("Lnumber"));
menbers = Integer.valueOf(request.getParameter("menbers"));
checked = Integer.valueOf(request.getParameter("checked"));
String sql1 = "insert into List (";
String sql2 = "values(";
if (Listid != null) {
sql1 += "listid,";
sql2 += "'" + Listid + "',";
}
if (bookid != null) {
sql1 += "bookid,";
sql2 += "'" + bookid + "',";
}
if (Listid != null) {
sql1 += "classid,";
sql2 += "'" + classid + "',";
}
if (bookname != null) {
sql1 += "bookname,";
sql2 += "'" + bookname + "',";
}
if (classname != null) {
sql1 += "classname,";
sql2 += "'" + classname + "',";
}
if (Ldate != null) {
sql1 += "Ldate,";
sql2 += Ldate + ",";
}
if (Lnumber != null) {
sql1 += "Lnumber,";
sql2 += Lnumber.intValue() + ",";
}
if (price != null) {
sql1 += "price,";
sql2 += price.floatValue() + ",";
}
if (menbers != null) {
sql1 += "menbers,";
sql2 += menbers.intValue() + ",";
}
if (checked != null) {
sql1 += "checked,";
sql2 += checked.intValue() + ",";
}
sql1 = sql1.substring(0, sql1.length() - 1);
sql2 = sql2.substring(0, sql2.length() - 1);
sql1 += ")";
sql2 += ")";
sql = sql1 + sql2;
//out.print(sql);
try {
int i = myRs.executeUpdate(sql);
message = "已完成添加,可以到定单信息页查看新图书!";
} catch (Exception e) {
e.printStackTrace();
message = "出现异常清况,请后退,重新添加";
}
}
%>
<body>
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" height="300" border="0"
background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" height="160" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首页</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListInfo.jsp">定单信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListQuery.jsp">定单号查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListQuery.jsp">按班级查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListQuery.jsp">按图书名查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListDel.jsp">删除已有定单</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListAdd.jsp">增加新的定单</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<form name="form" method="post" action="ListAdd.jsp?type=save">
<table width="100%" border="1">
<tr>
<td width="16%">
<label>
定单编号：
</label>
</td>
<td width="33%">
<label>
<input name="Listid" type="text" id="Listid">
</label>
</td>
<td width="18%">
图书名称：
</td>
<td width="33%">
<label>
<input name="bookname" type="text" id="bookname">
</label>
</td>
</tr>
<tr>
<td width="16%">
<label>
图书编号：
</label>
</td>
<td width="33%">
<label>
<input name="bookid" type="text" id="bookid">
</label>
</td>
<td width="18%">
班级编号：
</td>
<td width="33%">
<label>
<input name="classid" type="text" id="classid">
</label>
</td>
</tr>
<tr>
<td>
班级名称：
</td>
<td>
<label>
<input name="classname" type="text" id="classname">
</label>
</td>
<td>
图书售价：
</td>
<td>
<label>
<input name="price" type="text" id="price">
</label>
</td>
</tr>
<tr>
<td>
班级人数：
</td>
<td>
<label>
<input name="menbers" type="text" id="menbers">
</label>
</td>
<td>
已定货数量：
</td>
<td>
<label>
<input name="Lnumber" type="text" id="Lnumber">
</label>
</td>
</tr>
<tr>
<td>
预定日期：
</td>
<td>
<label>
<input name="Ldate" type="text" id="Ldate">
(XXXX-XX-XX)
</label>
</td>
<td>
是否已全部预定：
</td>
<td>
<input type="text" name="checked">
(是=1/否=0)
</td>
</tr>
<tr>
<td colspan="4">
<center>
<input type="submit" name="Submit" value="增加">
</center>
</td>
</tr>
</table>
<center>
<%=message%>
</center>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -