dsearchinfo.java

利用Struts的MVC写的WEB开发程序

/****************************
****************************/
package dlayer;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import bean.FoodTableBean;
import bean.InfoBean;

public class DSearchInfo extends DConnet{
	
	private ResultSet  rsFT =  null;
	
	private Connection con = null;
	
	private Statement stmt = null;
	
	public void DSearchInfo(){
		
	}

	public ArrayList searchInfo(FoodTableBean foodTableBean) throws SQLException{
		
		con = super.Connect();
		
		stmt = con.createStatement();
		
		StringBuffer sqlStrBufFT = new StringBuffer();
	
		StringBuffer sqlStrBufFM =  new StringBuffer();
		
		StringBuffer sqlStrBufNM =  new StringBuffer();
		
		ArrayList resultList = new ArrayList();

		//resultList = null;
		
		String userID = "";

		userID = foodTableBean.getUserId();
		
		if(userID != null){
		//if(!userID.equals("null")) {
			
//			sqlStrBufFT.append("select * from FOOD_TABLE");
			
			sqlStrBufFT.append("SELECT T1.DNUMBER AS NDNUMBER, T1.DDATE AS NDDATE,  ")
			           .append("T1.USER_ID(SELECT T2.USER_NAME  FROM USER_MENU T2  WHERE T2.USER_ID =  T1.USER_ID) AS USERNAME, ")
			           .append("T1.FOOD_ID(SELECT  T3.FOOD_NAME   FROM  FOOD_MENU T3   WHERE  T3.FOOD_ID = T1.FOOD_ID) AS FOODNAME, ")
			           .append("(SELECT  T3.FOOD_PRICE  FROM  FOOD_MENU T3  WHERE T3.FOOD_ID = T1.FOOD_ID) AS FOODPRICE ")
			           .append(" FROM FOOD_TABLE AS T1  WHERE  (((T1.USER_ID)='")
					   .append(userID)
					   .append("'))");
			
		
			rsFT = stmt.executeQuery(sqlStrBufFT.toString());

			while(rsFT.next()){
			
				InfoBean infoBean = new InfoBean();

				infoBean.setFoodName(userID);
				
				infoBean.setFoodNumber(rsFT.getString("NDNUMBER"));
				
				infoBean.setFoodName(rsFT.getString("FOODNAME"));
				
				infoBean.setFoodPrice(rsFT.getString("FOODPRICE"));
				
				infoBean.setDateSh(rsFT.getString("NDDATE"));
			
				infoBean.setUserName(rsFT.getString("USERNAME"));
			
				resultList.add(infoBean);
				
			}
		
			
		}else{
			
			sqlStrBufFT.append("SELECT T1.DNUMBER AS NDNUMBER, T1.DDATE AS NDDATE,  ")
					   .append("T1.USER_ID (SELECT T2.USER_NAME  FROM USER_MENU T2  WHERE T2.USER_ID =  T1.USER_ID) AS USERNAME, ")
	                   .append("T1.FOOD_ID(SELECT  T3.FOOD_NAME   FROM  FOOD_MENU T3   WHERE  T3.FOOD_ID = T1.FOOD_ID) AS FOODNAME, ")
	                   .append("(SELECT  T3.FOOD_PRICE  FROM  FOOD_MENU T3  WHERE T3.FOOD_ID = T1.FOOD_ID) AS FOODPRICE ")
	                   .append(" FROM FOOD_TABLE AS T1 ");
	

			 rsFT = stmt.executeQuery(sqlStrBufFT.toString());

			 while(rsFT.next()){
	
				 InfoBean infoBean = new InfoBean();

//				 infoBean.setFoodName(rsFT.getString("USERID"));
		
				 infoBean.setFoodNumber(rsFT.getString("NDNUMBER"));
		
				 infoBean.setFoodName(rsFT.getString("FOODNAME"));
		
				 infoBean.setFoodPrice(rsFT.getString("FOODPRICE"));
		
				 infoBean.setDateSh(rsFT.getString("NDDATE"));
	
				 infoBean.setUserName(rsFT.getString("USERNAME"));
	
				 resultList.add(infoBean);
			
			 }
		
		}
		
		return resultList;
	
	}
	
}