复件 test.jsp

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

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.ArrayList" %>
<%@page import="java.util.Iterator;" %>

<script language="JavaScript">
function send1(){
<% 
	String userid=(String)session.getAttribute("userid");
	if(userid!=null){
%> 
		alert("你还未登陆");
		return false;
<%  }
	else {
%>	
		form.action="print.jsp";
		form.submit();
		return true;
<%	}	
%>
		
}
function send(){
	form.action="print.jsp";
		form.submit();
		return 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++;
					}
				}	
			}
			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")));
					}
			}
			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"));
					}
			}
			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++;
				}
				return result;
    	  }
    	}catch(Exception ee){
    		System.out.println(ee.getMessage()+"???wrong");
    	}
		return null;
    }
    
%>

<% 
		result=getData();
		//out.print("sadffsdfsdf");
%>		
 
<%/*	for(int i=0;i<result.length;i++){
			for(int j=0;j<result[i].length;j++)
				out.print(result[i][j]+"-----");
		}
	*/	
%>



  <table  width="850" border="1" align="center">
    <tr>
      <td width="100"><div align="center">名称</div></td>
      <td width="200"><div align="center">图片</div></td>
      <td width="400"><div align="center">描述</div></td>
      <td width="45"><div align="center">单价</div></td>
      <td width="45">数量</td>
      
    </tr>
<%	
	if(result!=null){	
		for(int i=0;i<result.length;i++){
			out.print("<tr>");
			out.print("<form action=\"print.jsp\" name=\"form\" method=\"post\" onsubmit=\"return send();\" > ");
			for(int j=1;j<result[i].length;j++)
				out.print("<td>"+result[i][j]+"</td>");
				%><td><select name="select">
		 				 <option selected>1</option>
		 				 <option>2</option>
						 <option>3</option>
		 				 <option>4</option>
						 <option>5</option>
						 <option>6</option>
						 <option>7</option>
					     <option>8</option>
					     <option>9</option>
					     <option>10</option>
					     </select>
						</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>");
			out.print("</form>");
		}
	}	
%>
	<tr>
		<td width="100"></td>
		<td width="200">&nbsp;</td>
		<td width="400"></td>
		<td width="45"></td>
		<td width="45" ><div align="center"><select name="select" >
		  <option>0</option>
		  <option selected>1</option>
		  <option>2</option>
		  <option>3</option>
		  <option>4</option>
		  <option>5</option>
		  <option>6</option>
		  <option>7</option>
		  <option>8</option>
		  <option>9</option>
		  <option>10</option>
		</select></div></td>
		
	</tr>
<%
	resultset.close();
%>
  
  
  
  
	</table>
</div>



</body>
</html>