📄 detail.jsp

📁 毕业设计代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
    ResultSet rs=null;
    String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
    String url="jdbc:odbc:airline";    //数据源的url
    String user1="";  //连接数据库的用户名
    String pass1="";  //连接数据库的口令
    String strSQL;  //要执行的sql语句
	String id=request.getParameter("id");
	int shangpinType=0;
	String shangpinName=null;
	String gongyingshang=null;
	String xinghao=null;
	float price=0;
	String huiyuanzhekou=null;
	String leixing=null;
	
	int i=0;
	if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{ 
		strSQL="select * from airline_shangpinxinxi where id="+id;//遍历数据，所有主题的信息
		
        rs=db.executeQuery(strSQL);
		rs.next();
		shangpinType=rs.getInt(2);
		shangpinName=rs.getString(3);
		gongyingshang=rs.getString(4);
		xinghao=rs.getString(5);
		price=rs.getFloat(6);
		huiyuanzhekou=rs.getString(7);
		switch(shangpinType)
		{
			case 0:
				leixing="食品";
				break;
			case 1:
				leixing="书籍";
				break;
			case 2:
				leixing="影视";
				break;
		}
		

	}
    catch(SQLException e2){
         out.println("数据库异常！");
         out.println(e2.toString());
    }
	finally{
		try{
			if(rs!=null) rs.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>
    <TABLE WIDTH="620" BORDER="0" CELLSPACING="2" CELLPADDING="0">
		<TR>
			<TD COLSPAN="2" CLASS="TITLE2">商品详细资料</TD>
		</TR>
        <TR>
            <TD COLSPAN="2" CLASS="RIGHT"></TD>
        </TR>
        <TR>
            <TD WIDTH="118" CLASS="RIGHT">商品名称：</TD>
            <TD WIDTH="496" CLASS="TEXT"><%=shangpinName%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">商品类别：</TD>
            <TD CLASS="TEXT"><%=leixing%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">供应商：</TD>
            <TD CLASS="TEXT"><%=gongyingshang%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">生产批号／型号：</TD>
            <TD CLASS="TEXT"><%=xinghao%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">价格：</TD>
            <TD CLASS="TEXT"><%=price%>元人民币</TD>
        </TR>
        <TR>
            <TD HEIGHT="39" COLSPAN="2" ALIGN="RIGHT">
				<A HREF="list.jsp"><IMG SRC="../../../image/shopreturn.gif" ALT="返回" WIDTH="88" HEIGHT="28" BORDER="0"></A>&nbsp;&nbsp;&nbsp;&nbsp;
				<A HREF="order.jsp"><IMG SRC="../../../image/buy.gif" ALT="我要购买" WIDTH="88" HEIGHT="28" BORDER="0"></A>
			</TD>
        </TR>
		<TR>
			<TD COLSPAN="2"><HR COLOR="#999999" SIZE="1"></TD>
		</TR>
    </TABLE>
</BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -