package jp.ac.kcska.questionsystem.categorymanager.horizon;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import jp.ac.kcska.questionsystem.ExcuteDatabase;
import jp.ac.kcska.questionsystem.Mst_categoryVo;

public class EditCategoryServlet extends HttpServlet{
	private static final long serialVersionUID = 1L;

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		req.setCharacterEncoding("UTF-8");
		resp.setContentType("text/html; charset=UTF-8");
		
		Mst_categoryVo categoryVo = new Mst_categoryVo();
		
		int categoryid = Integer.parseInt(req.getParameter("id"));
		ExcuteDatabase excuteDatabase = new ExcuteDatabase();
		String strSQL = "SELECT * FROM MST_CATEGORY WHERE id = " + categoryid;
		
		try {
			ResultSet resultSet = excuteDatabase.excuteSelect(strSQL);
			while(resultSet.next()){

				int id = resultSet.getInt("id");
				String categoryname = resultSet.getString("categoryname");
				byte valid = resultSet.getByte("valid");
				
				categoryVo.setId(id);
				categoryVo.setCategoryname(categoryname);
				categoryVo.setValid(valid);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		HttpSession session = req.getSession();
		session.setAttribute("categoryVo", categoryVo);
		RequestDispatcher dispatcher = req.getRequestDispatcher("/editcategory.jsp");
		dispatcher.forward(req, resp);
	}
	
	
}
