package com.mvc.Beans;

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

import java.util.*;

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

import com.mvc.form.*;

public class stationAdd extends SimpleFormController{
	public JdbcTemplate jtl;

	public JdbcTemplate getJtl() {
		return jtl;
	}

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

	@Override
	protected ModelAndView onSubmit(HttpServletRequest request,
			HttpServletResponse response, Object command, BindException errors)
			throws Exception {
				stationForm station=(stationForm) command;             // TODO Auto-generated method stub
				
				String sid=station.getSid();
				String sname=station.getSname();
				String division=station.getDivision();
				String linename=station.getLinename();
				String company=station.getCompany();
				
				jtl.update("Insert into station(sid,sname,division,linename,company) values('"+sid+"','"+sname+"','"
						+division+"','"+linename+"','"+company+"')");
				
				Map msg = new HashMap();
				msg.put("msg", "增加記錄成功!");
				
		return new ModelAndView("index", msg);

	}

	@Override
	protected Object formBackingObject(HttpServletRequest request)  //設置字符
			throws Exception {
		request.setCharacterEncoding("GBK");							// TODO Auto-generated method stub
		return super.formBackingObject(request);
	}
	
	
	 	
}