复件 shopping.jsp

电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看

<%@page contentType="text/html;charset=gb2312"language="java"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.ArrayList" %>
<script language="javascript">
	function ok(){
		form1.action="shopping_action.jsp";
		form1.submit();
	}	
	function CheckAll(form){
			for (var i=0;i<form.elements.length;i++){
				var e = form.elements[i];
//		if (e.name != 'chkall')
				e.checked = true// form.chkall.checked;
			}
		}
	function CheckOthers(form){
		for (var i=0;i<form.elements.length;i++){
			var e = form.elements[i];
			if (e.checked==true){
				e.checked = false;
				if(document.getElementById[e.value].value==""){
				
					alert("请输入用户名.");
					return false;
				}
			}
			else{
			e.checked = true;
			}
		}
	}
</script>
<%! 
	String odbcQuery;
	Connection connect;
	Statement statement;
	ResultSet resultset;
	String[][] result={{""}};
	
	/*
     *建立与数据库的连接,返回连接状态
     *
     */
    boolean connectIt(){
    	try {
   			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   		}
   		catch(ClassNotFoundException e1) {
   			System.out.print("驱动程序不存在");
   			return false;
 		}
    	try {
    		connect=DriverManager.getConnection("jdbc:odbc:shopping","","");
            statement=connect.createStatement();
            
        }
        catch(SQLException e2) {
        	////System.out.println(""+e2);
        	return false;
      	}
      	return true;    
    }
	
	//取得商品的总数目
	int getRowNum(){
		try{
			int len=0;
			if(connectIt()){
				if(connectIt()){
					resultset=statement.executeQuery("Select * From commodity");
					while(resultset.next()){
						len++;
					}
				}	
			}
			//resultset.close();
			statement.close();
			return len;	
		}
		catch(SQLException e){
			System.out.print(e);
		}
		return 0;
	}
	
	//获取商品的所有id
	ArrayList getAllId(){
		ArrayList list=new ArrayList();
		try{
			if(connectIt()){
				resultset=statement.executeQuery("Select commodityID From commodity");
					while(resultset.next()){
						System.out.print(list.add(resultset.getString("commodityID")));
					}
			}
			//resultset.close();
			statement.close();
			return list;
		}
		catch(SQLException e1){
			System.out.print(e1);
		}
		return list;
	}
	
	ArrayList getOne(String id){
		ArrayList list=new ArrayList();
		try{
			if(connectIt()){
				resultset=statement.executeQuery("Select * From commodity where commodityID ='"+id+"'");
					while(resultset.next()){
						System.out.print(list.add(resultset.getString("commodityID")));
						list.add(resultset.getString("commodityName"));
						list.add(resultset.getString("commodityPic"));
						list.add(resultset.getString("commodityDesc"));
						list.add(resultset.getString("commodityPrice"));
					}
			}
			resultset.close();
			return list;
		}
		catch(SQLException e1){
			System.out.print(e1);
		}
		return list;
	}
	
	String[][] getData(){
       	try{
          	if(connectIt()){ 
		  		int commodityNum=getRowNum();
				//System.out.print("???"+commodityNum);
				int commodityAttrNum=5;
				
				String[][] result=new String[commodityNum][commodityAttrNum];
				//把学生基本信息传给数组
				
				//获取商品的所有id
				String[] id=new String[commodityNum];
				Object[] object=getAllId().toArray(); 
				for(int i=0;i<object.length;i++){
					System.out.print(id[i]=object[i].toString());
				}
			
				//获取所有商品的所有信息
				int i=0;
				int j=0;
				while(i<commodityNum) {
					object=this.getOne(id[i]).toArray();
    	 			while(j<commodityAttrNum){
    	 				System.out.print(result[i][j]=object[j].toString());
    	 				j++;
    	 			}
					j=0;
					i++;
				}
				//resultset.close();
				statement.close();
				return result;
    	  }
    	}catch(Exception ee){
    		System.out.println(ee.getMessage()+"???wrong");
    	}
		return null;
    }
%>

<% 
		result=getData();
		if(request.getParameter("logged")!=null){
%>
			<script language="javascript">
				alert("你还未登陆");
			</script>
<%	
		}else if(request.getParameter("done")!=null){		
%>		
			<script language="javascript">
				alert("操作成功");
			</script>
<%
		}	
%>		
<%/*	for(int i=0;i<result.length;i++){
			for(int j=0;j<result[i].length;j++)
				out.print(result[i][j]+"-----");
		}
	*/	
%>
<style type="text/css">
<!--
.style1 {font-size: 12px}
-->
</style>




<form action="print.jsp" name="form1" method="post" > 

  <table  width="637" border="1" align="center">
    <tr>
	<td width="19"> </td>
      <td width="80"><div align="center" class="style1">&#21830;&#21697;&#21517;&#31216;</div></td>
      <td width="183"><div align="center" class="style1">图片及商品名称</div></td>
      <td width="233"><div align="center" class="style1">描述</div></td>
      <td width="48"><div align="center" class="style1">单价</div></td>
      <td width="48"><div align="center" class="style1">数量</div></td>
    </tr>
<%	
	if(result!=null){	
		for(int i=0;i<result.length;i++){
			out.print("<tr><td width=5><input type=checkbox name=choices  value=\""+result[i][0]+"\" ></td>");
			for(int j=1;j<result[i].length;j++)
				//if(j==2)out.print("<td align=center>"+result[i][j]+"<br>"+result[i][0]+"</td>");
				out.print("<td class=\"style1\" align=\"center\">"+result[i][j]+"</td>");
				out.print("<td align=\"center\"><input type=\"hidden\" name=\"hidden\" value=\""+result[i][0]+"\">"+
					"<input type=\"text\" name=\""+result[i][0]+"\" size=4 ></td>");
			//out.print("<td width=65><div align=center><input type=\"hidden\" name=\"hidden\" value=\""+result[i][0]+"\">" 
			//+"<input type=submit name=\"button"+i+ "\" value=\"放入购物车\" >");
			//out.print("<td width=65><div align=center><input type=button name=\"button"+i+ "\" value=\"放入购物车\" onClick=\"send("+i+")\">");
			out.print("</tr>");
			
		}
	}	
%>

	  <td colspan="6" align="right">
      <div align="right"><span class="style1"><a href="shopping_look_action.jsp">查看购物车</a> 
	  					<a href="javascript:ok()">放入购物车</a></span>
						<input type="button" name="chkother" value="反选" onclick="CheckOthers(this.form)" title="反向选择歌曲">
	  </div>
	  </td>
		
	</tr>
<%
	//resultset.close();
%>
</table>
</form>

  
  

  

</body>
</html>