songaction.java

ktv点歌系统前台收银有开包房

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.ktv.action.front;

import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.actions.DispatchAction;

import com.ktv.dao.front.NameService;

import com.ktv.common.Page;
import com.ktv.common.PageUtil;
import com.ktv.dao.IsongDAO;
import com.ktv.entity.Song;

/** 
 * MyEclipse Struts
 * Creation date: 09-11-2007
 * 
 * XDoclet definition:
 * @struts.action path="/jobs" name="jobsForm" input="/form/jobs.jsp" parameter="methods" scope="request"
 */
public class SongAction extends DispatchAction {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	private IsongDAO songDAO;

	public IsongDAO getSongDAO() {
		return songDAO;
	}

	public void setSongDAO(IsongDAO songDAO) {
		this.songDAO = songDAO;
	}


	
	public ActionForward getNumberList(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		
		DynaActionForm daForm = (DynaActionForm)form;
		try{
		//JobsDAO jobsDAO = new JobsDAO();
			String number=daForm.get("number").toString();
			
		Page page = PageUtil.splitPage(daForm, songDAO,number,"songNumber");	
		ArrayList songList= (ArrayList)songDAO.getNumberList(number,
				page.getStartRow(), page.getPageSize());
		request.setAttribute("numbersongList" , songList);
		request.setAttribute("number", number);
		return mapping.findForward("numbersongList");}
		catch(Exception ex){
			ex.printStackTrace();
			return null;
		}
	}
	
	public ActionForward getLanguageList(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		
		DynaActionForm daForm = (DynaActionForm)form;
		try{
		//JobsDAO jobsDAO = new JobsDAO();
		Page page = PageUtil.splitPage(daForm, songDAO);	
		
		ArrayList songList= (ArrayList)songDAO.getList(
				page.getStartRow(), page.getPageSize());
		request.setAttribute("languagesongList" , songList);
		return mapping.findForward("languagesongList");}
		catch(Exception ex){
			ex.printStackTrace();
			return null;
		}
	}
	
	public ActionForward addSelectSong(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		System.out.println("aaaaaaaaaaaaaaaaaaaaaaa");
		HttpSession session=request.getSession();
		session.getAttribute("songlist");
		String songId = request.getParameter("id");
		List<Song> list=new ArrayList<Song>();
		list = (ArrayList<Song>)session.getAttribute("songlist");		
		if(list==null)			list= new ArrayList<Song>();		
		System.out.println(list.size());
		Song  song= new Song();
		song=(Song)songDAO.findById(Integer.valueOf(songId));
		
		list.add(song);
		session.setAttribute("songlist",list);
		session.setAttribute("size", list.size());
		System.out.println(list.size());
		return null;
	}
	
	//字母查询
	public ActionForward getLetterList(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		
		DynaActionForm daForm = (DynaActionForm)form;
		try{
		//JobsDAO jobsDAO = new JobsDAO();
			String songNameLetter=request.getParameter("songNameLetter").toString();
			
		Page page = PageUtil.splitPage(daForm, songDAO,songNameLetter,"songNameLetter");	
		ArrayList songList= (ArrayList)songDAO.getLetterList(songNameLetter,
				page.getStartRow(), page.getPageSize());
		System.out.println("songList.size()"+songList.size());
		request.setAttribute("lettersongList" , songList);
		request.setAttribute("songNameLetter", songNameLetter);
		return mapping.findForward("lettersongList");}
		catch(Exception ex){
			ex.printStackTrace();
			return null;
		}
	}
//	AJAX下拉显示文本内容
	  private List songNameLetter=new ArrayList();
	public ActionForward getNames(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		songNameLetter=songDAO.findSongName();
		System.out.println("进入songaction中");
		String prefix=request.getParameter("songNameLetter").toString();
		System.out.println("prifix=="+prefix);
		System.out.println("songNameLetter=="+songNameLetter.size());
		try{	 

		   NameService service=NameService.getInstance(songNameLetter);
		   List matching=service.findNames(prefix);
			System.out.println("matching="+matching.size());
		   if(matching.size()>0){
		     PrintWriter out=response.getWriter();
		     response.setContentType("text/xml");
		     response.setHeader("Cache_Control","no_cache");
		     out.println("<response>");
		     Iterator iter=matching.iterator();
		     while(iter.hasNext()){
		    	 System.out.println("1111111111");
		     String name=(String)iter.next();
		     out.println("<name>"+name+"</name>");
		     System.out.println("name=="+name);
		     }
		     out.println("</response>");
		     matching=null;
		     service=null;
		     out.close();
		     
		   }else{
		    System.out.println("2222222222222");
		   response.setStatus(HttpServletResponse.SC_NO_CONTENT);
		   }
		}catch(Exception ex){
			ex.printStackTrace();
		}
		   return null;
	}
}