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

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
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;

public class ExcuteCreateUserServlet 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");
		Connection connection = null;
		try {
			String username = req.getParameter("username");
			String password = req.getParameter("password");
			String adminValue = req.getParameter("admin");
			connection = DriverManager.getConnection(
					"jdbc:mysql://localhost/questionsystem", "root", "mysql");
			String sql = "INSERT INTO mst_user (username,password,adminFlag) VALUES (?,?,?)";
			PreparedStatement statement = connection.prepareStatement(sql);
			statement.setString(1, username);
			statement.setString(2, password);
			byte bool = 0;
			switch (adminValue) {

			case "true":
				bool = 1;
				statement.setByte(3, bool);
				break;
			case "false":
				bool = 0;
				statement.setByte(3, bool);
				break;
			default:
				break;
			}
			statement.execute();
			RequestDispatcher dispatcher = req.getRequestDispatcher("/UserManager");
			dispatcher.forward(req, resp);

		} catch (SQLException e) {
			// TODO 自動生成された catch ブロック
			e.printStackTrace();
		}

	}

}