📄 edit.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1=""; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL2; //要执行的sql语句
String strSQL3; //要执行的sql语句
String shangpinName=request.getParameter("shangpinName");
int shangpinType=0;
String gongyingshang=null;
String xinghao=null;
float price=0;
String huiyuanzhekou=null;
shangpinName=new String(shangpinName.getBytes("8859_1"));
String optionQ=null;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL3="select * from airline_shangpinxinxi with(READCOMMITTED) where shangpinName='"+shangpinName+"'";//判断是否有用户存在
rs=db.executeQuery(strSQL3);
rs.next();
if(rs!=null)
{
shangpinType=rs.getInt(2);
gongyingshang=rs.getString(4);
xinghao=rs.getString(5);
price=rs.getFloat(6);
huiyuanzhekou=rs.getString(7);
switch(shangpinType)
{
case 0:
optionQ="<option value='0' checked>食品</option>";
optionQ=optionQ+"<option value='1'>书籍</option>";
optionQ=optionQ+"<option value='2'>影视</option>";
break;
case 1:
optionQ="<option value='1' checked>书籍</option>";
optionQ=optionQ+"<option value='0'>食品</option>";
optionQ=optionQ+"<option value='2'>影视</option>";
break;
case 2:
optionQ="<option value='2' checked>影视</option>";
optionQ=optionQ+"<option value='1'>书籍</option>";
optionQ=optionQ+"<option value='0'>食品</option>";
break;
}
}
}
catch(Exception e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con!=null) con.close();
}
catch(Exception e){}
}
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>网上商城</TITLE>
<LINK HREF="../../../../css/style.css" REL="stylesheet" TYPE="text/css">
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="confirmM.jsp">
<TABLE WIDTH="780" BORDER="0" ALIGN="CENTER">
<TR>
<TD COLSPAN="2"><CENTER>
<P CLASS="TITLE2">修改商品信息</P>
</CENTER></TD>
</TR>
<TR>
<TD COLSPAN="2"> </TD>
</TR>
<TR>
<TD COLSPAN="2" CLASS="TEXT">注意:带 <strong>** </strong>部分必须填写，谢谢合作。</TD>
</TR>
<TR>
<TD WIDTH="185" CLASS="RIGHT"><strong>**</strong> 商品类别：</TD>
<TD WIDTH="585" CLASS="TEXT"><SELECT NAME="shangpinType">
<%=optionQ%>
</SELECT></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><strong>**</strong> 商品名称：</TD>
<TD CLASS="TEXT"><INPUT NAME="shangpinName" TYPE="hidden" SIZE="30" value="<%=shangpinName%>"><%=shangpinName%></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><strong>**</strong> 供应商：</TD>
<TD CLASS="TEXT"><INPUT NAME="gongyingshang" TYPE="text" SIZE="30" value="<%=gongyingshang%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">生产批号／型号：</TD>
<TD CLASS="TEXT"><INPUT NAME="xinghao" TYPE="text" SIZE="30" value="<%=xinghao%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><strong>**</strong> 价格：</TD>
<TD CLASS="TEXT"><INPUT NAME="price" TYPE="text" SIZE="20" value="<%=price%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><strong>**</strong> 折扣： </TD>
<TD CLASS="TEXT"><INPUT NAME="huiyuanzhekou" TYPE="text" SIZE="5" value="<%=huiyuanzhekou%>"></TD>
</TR>
<TR>
<TD COLSPAN="2"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR>
<TD COLSPAN="2"><CENTER>
<INPUT TYPE="submit" NAME="Submit" VALUE="提交">
<INPUT NAME="reset" TYPE="RESET" ID="reset" VALUE="取消">
</CENTER></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -