?? stockregionsave.jsp
字號:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GB2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("gb2312");%>
<%
String loginname=(String)session.getAttribute("loginname");
String ok=(String)session.getAttribute("ok");
String loginpower=(String)session.getAttribute("loginpower");
if(ok==null&&loginname==null)
{
session.setAttribute("errors","對不起您還沒有登陸，請先登陸!");
response.sendRedirect("../../errors/errorpage.jsp");
}else if(!loginpower.equals("admin")){
session.setAttribute("errors","對不起您沒有對商品位置的管理權限!");
response.sendRedirect("../../errors/errorpage.jsp");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv='Expires' content='-10'>
<meta http-equiv='Pragma' content='No-cache'>
<meta http-equiv='Cache-Control', 'private'>
<title>商品所在庫中位置信息窗口</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
<link href="<%=request.getContextPath()%>/cssjs/comcss.css" rel="stylesheet" type="text/css">
<script language="javascript" src="<%=request.getContextPath()%>/cssjs/comjs.js"></script>
</head>
<body>
<table width="478" height="202" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr>
<td width="129" height="25" align="center" class="style5">*標識項必須選擇</td>
<td width="339" align="center">
<span class="style5">
<%
String success=(String)session.getAttribute("success");
if(success!=null){
%>
<script language="javascript">
alert("商品位置信息添加成功！");
location.href="<%=request.getContextPath()%>/viewpage/datainput/stockregionsave.jsp";
</script>
<%
session.removeAttribute("success");
}
%>
</span>
</td>
</tr>
<tr>
<td height="175" colspan="2"><form action="/Logistic/stockregionsave" method="post" name="stockregion" id="stockregion">
<table width="289" height="147" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr align="center">
<td colspan="3" class="style9">格式：庫中位置－排號－座號</td>
</tr>
<tr>
<td width="85" height="26" align="right" class="code">庫中位置:</td>
<td width="106"><select name="location" class="style9" id="location">
<option value="">庫中位置</option>
<%
String sqllocation="select *from goodslocationtable";
Statement statlocation=dblink.getStmtread();
ResultSet rslocation=statlocation.executeQuery(sqllocation);
while(rslocation.next()){
String locationname=rslocation.getString("LocationName");
out.print("<option value="+locationname);
out.print(">"+locationname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
<td width="96"> </td>
</tr>
<tr>
<td height="28" align="right" class="code">庫中排號:</td>
<td><select name="rows" class="style9" id="rows">
<option value="">庫中排號</option>
<%
String sqlrows="select *from goodsrowstable";
Statement statrows=dblink.getStmtread();
ResultSet rsrows=statrows.executeQuery(sqlrows);
while(rsrows.next()){
String rowsname=rsrows.getString("RowsName");
out.print("<option value="+rowsname);
out.print(">"+rowsname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
<td> </td>
</tr>
<tr>
<td height="29" align="right" class="code">庫中座號:</td>
<td><select name="seats" class="style9" id="seats">
<option value="">庫中座號</option>
<%
String sqlseats="select *from goodsseatstable";
Statement statseats=dblink.getStmtread();
ResultSet rsseats=statseats.executeQuery(sqlseats);
while(rsseats.next()){
String seatsname=rsseats.getString("SeatsName");
out.print("<option value="+seatsname);
out.print(">"+seatsname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
<td> </td>
</tr>
<tr align="center">
<td colspan="3"><input name="Submit" type="submit" class="buttonstyle" value="提交數據" onClick="return stockregion_check()">
<input name="cancel" type="submit" class="buttonstyle" id="cancel" value="重置數據"></td>
</tr>
</table>
</form></td>
</tr>
</table>
<p class="code"> </p>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -