package com.mvc.Beans;

import javax.servlet.http.*;
import java.util.*;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.servlet.*;
import org.springframework.web.servlet.mvc.*;

public class stationQuery 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
		
			String id=arg0.getParameter("id");
			List list=jtl.queryForList("select * from station where id='"+id+"'");
			
		return new ModelAndView("StationModify","list",list);
	}
	
}