package com.mvc.Beans;

import java.util.List;

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

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;
import com.mvc.form.*;

public class busView implements Controller {
	
	public JdbcTemplate jtl;

	public JdbcTemplate getJtl() {
		return jtl;
	}
	
	public void setJtl(JdbcTemplate jtl) {
		this.jtl = jtl;
	}


	public ModelAndView handleRequest(HttpServletRequest arg0,
			HttpServletResponse arg1) throws Exception {
		// TODO Auto-generated method stub
		
		List<busForm> list=jtl.queryForList("select * from bus");
		return new ModelAndView("busList","list",list);
	}

}