📄 admin_mod_item_update.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<title>Modify Item Page</title>
</head>
<body bgcolor="#C0C0C0" topmargin="0" background="http:\\localhost:8000\music\Background.bmp" >
<table border="0" width="100%">
<tr>
<td width="100%">
<table border="0" width="97%" height="19">
<tr>
<td width="18%" height="13" valign="middle" align="right">
<font face="Arial" size="5" color="#800000"><b><i>eMusicWorld-----> The World of Music</i></b></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<form name="form" method="get" action="http://localhost:8000/music/admin_mod.jsp" >
<script language="javascript">
function year()
{
document.write("<option value=\"- - - -\">- - - -</option>");
for (i=1900;i<2000;i++)
{
document.write("<option value="+i+">"+i+"</option>");
}
}
function date()
{
document.write("<option value=\"- - \">- - </option>");
for (i=01;i<=31;i++)
{
document.write("<option value="+i+">"+i+"</option>");
}
}
function verify()
{
var ctr=0;
var txtTitle=form.txtTitle.value;
var txtRate=form.txtRate.value;
var txtDesc=form.txtDesc.value;
var txtSinger=form.txtSinger.value;
var txtQty=form.txtQty.value;
var txtType=form.txtType.value;
if((txtTitle.length==0)||(txtRate.length==0)||(txtDesc.length==0)||(txtSinger.length==0)||(txtQty.length==0))
{
alert("Please enter all the values.");
ctr=1;
}
if(ctr!=1)
form.submit();
}
</script>
<table border="0" width="100%">
<tr>
<td width="100%"><table border="0" width="100%" height="19">
<tr>
<td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/home_page.htm">Home</a></b></font></td>
<td width="10%" height="13" valign="middle" align="center"></td>
<td width="19%" height="13" valign="middle" align="center"></td>
<td width="13%" height="13" valign="middle" align="center"></td>
<td width="13%" height="13" valign="middle" align="center"></td>
<td width="11%" height="13" valign="middle" align="center"></td>
<td width="10%" height="13" valign="middle" align="center"></td>
<td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/logout.jsp">Logout</b></font></td>
<td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_home_page_old.htm">Help</a></b></font></td>
</tr>
</table>
</td>
</tr>
</table>
<table border="1" width="100%" height="353">
<tr>
<td width="15%" height="347" valign="top">
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_del_user.jsp">Delete User</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/ItemContext/ItemAlias">Add Item</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_mod_item.jsp">Modify Item</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b>Sales Reports<br>---<a HREF="http://localhost:8000/music/daily_sales_report.jsp">Choose a Date</a><br>---<a HREF="http:\\localhost:8000\weekly_sales_report.jsp">Previous
Week</a><br>---<a HREF="http://localhost:8000/music/monthly_sales_report.jsp">Previous Month</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_wishlist.jsp">View Wishlist</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_messages.jsp">View Messages</a></b></font></p>
</td>
<td width="85%" height="347" valign="top">
<p align="center"> <b><u><font color="#800000" face="Arial" size="2">Modify
Item in the Inventory</font></u></b>
</p>
<%! String title, itemdesc, singer, type;%>
<%! int qty;%>
<%! float rate;%>
<%! String itemcode;%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%@ page language = "java" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
itemcode=request.getParameter("lstItemCode");
connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
Statement state;
state = connect.createStatement();
String strQuery1 = "select * from Item_Master where Item_Code='" + itemcode +"'";
ResultSet result1 = state.executeQuery(strQuery1);
int ctr1=0;
while(result1.next())
{
title=result1.getString("Title");
rate=result1.getFloat("Rate");
itemdesc=result1.getString("Item_Desc");
singer=result1.getString("Singer");
qty=result1.getInt("Qty_on_hand");
type=result1.getString("Type");
}
connect.close();
}
catch(Exception e)
{
out.println("Exception: "+e);
}
%>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Item Code:
<input type="text" name="itemcode" size="20" value=<%=itemcode%>></font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Title:
<input type="text" name="txtTitle" size="20" value=<%=title%>></font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Price ($):
<input type="text" name="txtRate" size="20" value=<%=rate%>></font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Description:
<input type="text" name="txtDesc" size="20" value=<%=itemdesc%>></font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Singer:
<input type="text" name="txtSinger" size="20" value=<%=singer%>></font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Qty:
<input type="text" name="txtQty" size="20" value=<%=qty%>></font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 3"><font face="Arial" size="2" color="#800000">Type:
<input type="text" name="txtType" size="20" value=<%=type%>> </font></p>
</font></p>
<p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 10"> </p>
<p align="center" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 10"><input type="button" value="Submit" name="Submit" OnClick="verify()"></p>
</form>
</td>
</tr>
<tr>
<td width="15%" height="347" valign="top">
</td>
<td width="85%" height="347" valign="top">
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -