package com.mvc.Beans;

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

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

public class stationMod 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
		
		arg0.setCharacterEncoding("GBK");
		String id=arg0.getParameter("id");
		String sid=arg0.getParameter("sid");
		String sname=arg0.getParameter("sname");
		String division=arg0.getParameter("division");
		String linename=arg0.getParameter("linename");
		String company=arg0.getParameter("company");
		
		jtl.update("update station set sid='"+sid+"',sname='"+sname+"',division='"+division+"',linename='"+
				linename+"',company='"+company+"' where id='"+id+"'");
		
		Map msg = new HashMap();
		msg.put("msg", "更改成功！"); 
		
		return new ModelAndView("ModifiSuccee",msg);
	}

}