📄 list.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 shangpinName=null;
float price=0;
int i=0;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL="select * from airline_shangpinxinxi";//遍历数据，所有主题的信息
rs=db.executeQuery(strSQL);
%>
<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="">
<input type="hidden" value="" name="shangpinName">
<TABLE WIDTH="780" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="2">
<TR>
<TD COLSPAN="7" CLASS="TITLE2">商品列表</TD>
</TR>
<TR>
<TD COLSPAN="7"> </TD>
</TR>
<TR VALIGN="MIDDLE">
<TD COLSPAN="2" CLASS="RIGHT"> </TD>
<TD COLSPAN="5" CLASS="RIGHT"><A HREF="new.jsp" TARGET="mainFrame">新增</A></TD>
</TR>
<TR CLASS="HD3">
<TD WIDTH="103" HEIGHT="18">序号</TD>
<TD WIDTH="223">商品名</TD>
<TD WIDTH="113">价格（RMB）</TD>
<TD WIDTH="105"> </TD>
<TD WIDTH="108"> </TD>
</TR>
<%
while(rs.next()){
i++;
shangpinName=rs.getString(3);
price=rs.getFloat(6);
%>
<TR CLASS="ODDTR">
<TD><%=i%></TD>
<TD><%=shangpinName%></TD>
<TD><%=price%></TD>
<TD><A HREF="JavaScript:linkSyokomoku('edit.jsp','<%=shangpinName%>');" TARGET="mainFrame">修改</A></TD>
<TD><A HREF="JavaScript:linkSyokomoku('delconfirm.jsp','<%=shangpinName%>');" TARGET="mainFrame">删除</A></TD>
</TR>
<%
}
%>
<TR>
<TD COLSPAN="5" ALIGN="CENTER">
</TD>
</TR>
<TR>
<TD COLSPAN="7"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR>
<TD COLSPAN="5"><CENTER>
<P CLASS="TEXT">共N条商品记录 第N页／共N页 首页 前页 后页 末页
</P>
</CENTER></TD>
</TR>
</TABLE>
<%
}
catch(SQLException e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
}
catch(Exception e){}
}
%>
</FORM>
</BODY>
</HTML>
<script language="javascript">
<!--
function linkSyokomoku(url,shangpinName)
{
var frm=document.form1;
frm.shangpinName.value=shangpinName;
frm.method = "post";
frm.action = url;
frm.target = "mainFrame";
frm.submit();
}
-->
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -