package cis452;

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

public class AgentUpdateServlet extends HttpServlet
{
	private static final long serialVersionUID = 1L;
	
	final static String username = "autos";
	final static String password = "autos_pw";
	final static String driverClass = "com.mysql.jdbc.Driver";
	final static String url = "jdbc:mysql://scraggley.cis.umassd.edu/autos?autoReconnect=true";
	
	
	public void init()
	{
		try {
			Class.forName(driverClass);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	

	public void doPost(HttpServletRequest req, HttpServletResponse res)
	{
		String ssn = req.getParameter("ssn");
		String fname = req.getParameter("fname");
		String lname = req.getParameter("lname");
		String city = req.getParameter("city");
		String state = req.getParameter("state");
		String salary = req.getParameter("salary");
		
		String update1 = "update agents set salary = " + salary + " where ssn = '" + ssn + "'";
		String update2 = "update people set fname = '" + fname + "', lname = '" + lname + "', city = '" + city + "', state = '" + state + "' where ssn = '" + ssn + "'";
		
		
		Connection dbConnection = null;
		try {
			dbConnection = DriverManager.getConnection(url, username, password);
			Statement statement = dbConnection.createStatement();
			statement.executeUpdate(update1);
			statement.executeUpdate(update2);
			
			RequestDispatcher dispatcher = req.getRequestDispatcher("../../update/success.html");
			dispatcher.forward(req, res);
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				dbConnection.close();
			} catch (Exception ex) {
			}
		}
	}
}