⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 main.jsp

📁 网上书店网站源代码
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE8 {color: #0000FF}
.style3 {font-size: 36px}
.style4 {	font-family: "华文琥珀";
	color: #FF0000;
}
.style7 {font-size: 12px}
.style2 {font-size: 14px}
.style81 {font-family: "华文彩云";
	font-size: 18px;
}
.STYLE85 {
	font-family: "华文彩云";
	font-size: 18px;
	color: #0000FF;
	font-weight: bold;
}
.STYLE86 {color: #FF0000}
.STYLE87 {
	color: #FF0000;
	font-size: 24px;
	font-weight: bold;
}
.STYLE93 {color: #000000}
.STYLE94 {font-size: 16px; font-weight: bold;}
-->
</style>
</head>

<body>
<script language="javascript">
function openScript(url,name,width,height){
var win=window.open(url,name,'width='+width+',height='+height+',resizeable=1,srollbars=yes,menubar=no,status=yes');
}</script>
<%! String u_name=new String();
    String name=new String();
    String author=new String();
	String bookclass=new String();
	String press=new String();
	String price=new String();
	String choice=new String();
	String search_txt=new String(); 
	int i;
	String ToPage;
%>
<% 
       u_name=request.getParameter("name");
       ToPage=request.getParameter("ToPage");
       int PageSize=10;//设置每张网页显示7条记录
       int ShowPage=1;//设置欲显示的页数
	   int RowCount=0;//ResultSet记录笔数
	   int PageCount=0;//ResultSet记录的分页
       String search_txt="";
	   String select="";
		System.out.println("正在连接数据库");
		String sql="";
		try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:book");
		Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		%>
<table width="1007" height="816" border="0" align="center" cellspacing="0" bordercolor="#666666">
  <tr>
    <td height="102" colspan="2" background="images/1.jpg" bgcolor="#00FF00"><div align="center" class="STYLE1 STYLE2 style1">
        <div align="center" class="style3 style4">欢迎来到KingStar网上书店</div></td>
  </tr>
  <tr bgcolor="#999999">
    <td height="36" colspan="2" bgcolor="#CC99CC"><table width="1021" height="20" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td bgcolor="#3399FF"><div align="center"><a href="login.jsp">首页</a></div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/newbooks">新书上市</a> </div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/hotsales">畅销推荐</a> </div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/giftbook/">礼品图书</a> </div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/browser">分类浏览</a></div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/infos">在线阅读</a> </div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/bookpl">图书热评</a> </div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="../注册页面/张明星/tssl">购物车管理</a></div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="/gbook">顾客留言</a></div></td>
        <td bgcolor="#3399FF"><div align="center"><a href="manager.jsp">管理员入口</a></div>
              <div align="center"></div></td>
      </tr>
    </table>
      <table width="1032" border="0">
        <tr>
          <td width="120" bgcolor="#3399FF"><div align="center"><span class="STYLE8">在线购书</span></div></td>
          <td width="150" bgcolor="#3399FF"><div align="center"><span class="STYLE8"><a href="myCar.jsp">我的购物车</a></span></div></td>
          <td width="120" bgcolor="#3399FF"><div align="center"><span class="STYLE8"><a href="login.jsp">登陆/注册</a></span></div></td>
          <td width="624" bgcolor="#3399FF">&nbsp;</td>
        </tr>
      </table>    </td>
  </tr>
  <tr>
    <td width="235" height="72" bgcolor="#FF66FF">
      <p><span class="STYLE85">你好!<%=u_name %></span></p>
      <p class="style2"><a href="show_user.jsp">个人信息</a> <% session.setAttribute("u_name",u_name); %></p>
    </td>
    <td width="768" bgcolor="#99CC99">
    <form id="form2" name="form2" method="post" action="booktdb.jsp">
      <label> <span class="STYLE86">图书搜索：</span>
      <select name="select" size="1" id="select">
        <option>书籍名称</option>
        <option>书籍作者</option>
        <option>书籍价格</option>
        <option>出版社</option>
      </select>
      </label>
      <input name="search_txt" type="text" id="search_txt" size="40" />
      <a href="main1.jsp">高级搜索 </a>
    </form>   </td>
  </tr>
  <% 
  if(request.getParameter("select")!=null&&!request.getParameter("select").equals(""))
		{
		select=new String(request.getParameter("select").trim().getBytes("8859_1"));
		}
		System.out.println("a");
		if(request.getParameter("search_txt")!=null&&!request.getParameter("search_txt").equals(""))
		{
		search_txt=new String(request.getParameter("search_txt").trim().getBytes("8859_1"));
		}
		if(search_txt!=null&&!search_txt.equals(""))
		{
		System.out.println("b");
		if(select==null)
		{
		sql="select b_name,b_author,b_class,b_press,b_price from b_book where b_name like '%"+search_txt+"%'";   
		sql=sql+" or b_author like'%"+search_txt+"%'"; 
		sql=sql +" or b_press like'%"+search_txt+"%'";
		sql=sql+" or b_price like'%"+search_txt+"%'";  
		sql=sql+"order by b_no"; 
		}
		else{
		System.out.println("c");
		sql="select b_name,b_author,b_class,b_press,b_price from b_book where";
		sql=sql+"b_name like'%"+search_txt+"%'";
		sql=sql+"b_author like'%"+search_txt+"%'";
		sql=sql+"b_press like'%"+search_txt+"%'";
		sql=sql+"b_price like'%"+search_txt+"%'";
		System.out.println("e");
		sql=sql+"order by b_no";
		}
		}
		else
		{
		System.out.println("f");
		sql="select b_name,b_author,b_class,b_press,b_price from b_book order by b_no";
		}
		ResultSet rs=st.executeQuery(sql);
		rs.last();
		System.out.println("g");
		RowCount=rs.getRow();//取得rs记录笔数
		PageCount=((RowCount% PageSize)==0?
		(RowCount/PageSize):(RowCount/PageSize)+1);
		//计算显示的页数
		//判断是否可正确取得ToPage参数
		//可取得则表示JSP网页应显示特定分页记录的语句 
		if(ToPage!=null)
		{
		//取得指定显示的分页数
	    ShowPage=Integer.parseInt(ToPage);
		//先面的if语句将判断用户输入的页数是否正确
		if(ShowPage>PageCount)
		{
		//判断指定页数是否大于总页数,是则设置显示最后一页
		ShowPage=PageCount;	
		}
		else if(ShowPage<=0)
		{
		//若指定页数<0则设置显示第一页的记录
		ShowPage=1;
		}
		}
		rs.absolute((ShowPage-1)*PageSize+1);
		//计算欲显示页的第一笔记录位置
		%>
  
  <tr bgcolor="#999999">
    <td height="553" bgcolor="#000000"><table width="99%" height="400" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="30"><font style="color: #CC9933; font-size: 14px"><strong>图书分类</strong></font></td>
      </tr>
      <tr>
        <td height="20"><a href="main2.jsp">·<font style="font-size: 13px">建筑科技类</font></a></td>
      </tr>
      <tr>
        <td height="20"><a href="main2.jsp">·<font style="font-size: 13px">法律类</font></a></td>
      </tr>
      <tr>
        <td height="20"><a href="main2.jsp">·<font style="font-size: 13px">计算机类</font></a></td>
      </tr>
      <tr>
        <td height="20"><a href="main2.jsp">·<font style="font-size: 13px">医学类</font></a></td>
      </tr>
      <tr>
        <td height="20"><a href="main2.jsp">·<font style="font-size: 13px">经管类</font></a></td>
      </tr>
      <tr>
        <td height="20"><p><a href="main2.jsp">·<font style="font-size: 13px">文学类</font></a></p>          </td>
      </tr>
      <tr>
        <td height="30"><font style="color: #CC9933; font-size: 14px"><strong>大众书店</strong></font></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=管理"><font style="font-size: 13px">经管书店</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=文学"><font style="font-size: 13px">文学书店</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=外语"><font style="font-size: 13px">外语书店</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=社科"><font style="font-size: 13px">社科书店</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=生活"><font style="font-size: 13px">生活书店</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=艺术"><font style="font-size: 13px">艺术书店</font></a></span></td>
      </tr>
      <tr>
        <td height="30"><font style="color: #CC9933; font-size: 14px"><strong>特色书店</strong></font></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=礼品书"><font style="font-size: 13px">礼品书</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=行业工具书"><font style="font-size: 13px">套装工具书</font></a></span></td>
      </tr>
      <tr>
        <td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=图书&amp;nsort_name=培训光盘"><font style="font-size: 13px">管理培训</font></a></span></td>
      </tr>
      <tr>
        <td height="10"><div align="left">
          <p>&nbsp;</p>
          <p>&nbsp;</p>
        </div></td>
      </tr>
    </table></td>
    <td height="553" rowspan="3" bgcolor="#00FFFF"><table width="790" height="48" border="0">
      <tr>
        <td width="776"><div align="center">
          <p class="STYLE87">书籍信息</p>
          <table width="790" border="0">
            <tr>
              <td colspan="7">
			  <span class="STYLE93">
			  <%
			  if(search_txt!=null&&!search_txt.equals(""))
	  {
	  %>
              <span class="STYLE94">以下是包含关键字<%=search_txt%>的所有信息
              <%
	  }
	  else
	  {
	  %>
     以下是所有信息
       <%
	  }
	  %>
              </span></span>
              <p align="left" class="STYLE8">共:<%=RowCount%>
条 共<%=PageCount%>页 当前页为第<%=ShowPage%>页</p>              </td>
            </tr>

            <tr>
              <td width="126"><div align="center" class="STYLE86 STYLE86">书籍名称</div></td>
              <td width="125"><div align="center" class="STYLE86 STYLE86">书籍作者</div></td>
              <td width="124"><div align="center" class="STYLE86 STYLE86">所属分类</div></td>
              <td width="118"><div align="center" class="STYLE86 STYLE86">出版社</div></td>
              <td width="109"><div align="center" class="STYLE86 STYLE86">单价</div></td>
              <td colspan="2"><div align="center" class="STYLE86 STYLE86">选择</div></td>
            </tr>
             <%
 while(i<PageSize&&!rs.isAfterLast()) 
 {
 %>
            <tr>
              <td><span class="STYLE8 STYLE86"><%=rs.getString("b_name")%></span></td>
              <td><span class="STYLE8 STYLE86"><%=rs.getString("b_author")%></span></td>
              <td><span class="STYLE8 STYLE86"><%=rs.getString("b_class")%></span></td>
              <td><span class="STYLE8 STYLE86"><%=rs.getString("b_press")%></span></td>
              <td><span class="STYLE8 STYLE86"><%=rs.getFloat("b_price")%></span></td>
              <td width="66"><div align="center"><span class="STYLE8 STYLE86"><a href="#" onclick="openScript('addcar.jsp','pur',300,250)">购买</a></span></div></td>
              <td width="98"><span class="STYLE8 STYLE86"><a href="11">详细资料</a></span></td>
              <% i++;
               rs.next();
              }%>
            </tr>
            <%
            rs.close();
            %>
            <tr>
              <td colspan="7"><table width="790" border="0">
                <tr>
                <td>&nbsp;</td>
                <% 
			      if(ShowPage!=1)
					  {
					  %>
                  <td><a href=main.jsp?Topage=<%=1%>>第一页</a></td>
                  <td><a href=main.jsp?ToPage=<%=ShowPage-1%>>上一页</a> </td>
                       <%
			            }
						 if(ShowPage!=PageCount)
						{
						%>
                  <td><a href=main.jsp?ToPage=<%=ShowPage+1%>>下一页</a></td>
                  <td><a href=main.jsp?ToPage=<%=PageCount%>>最后页</a></td>
                </tr>
                 <%
						}
						}
						catch(Exception e){}
						%>
              </table></td>
              </tr>
          </table>
        </div></td>
      </tr>
    </table>    
      <table width="790" border="0">
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
      </table>
    <p>&nbsp;</p></td>
  </tr>

  <tr bgcolor="#999999">
    <td height="39" colspan="2"><img src="images/bb1.jpg" width="168" height="46" /><img src="images/bb2.jpg" width="166" height="45" /><img src="images/bb3.jpg" width="171" height="45" /><img src="images/bb4.jpg" width="168" height="45" /><img src="images/wing_20.jpg" width="172" height="46" /><img src="images/bb.jpg" width="177" height="45" /></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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