package com.myapp.struts;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;
import org.apache.struts.validator.DynaValidatorForm;
public class Register extends org.apache.struts.action.Action {
private final static String SUCCESS = "success";
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
Connection con=null;
PreparedStatement ps=null;
String status=null;
try{
DynaValidatorForm registerForm = (DynaValidatorForm)form;
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/gobind","root","root");
System.out.println("connected");
ps=con.prepareStatement("insert into employee values(?,?,?,?,?,?)");
System.out.println("connected1");
ps.setString(1,(String)registerForm.get("id"));
ps.setString(2,(String)registerForm.get("name"));
System.out.println("connected3");
ps.setString(3,(String)registerForm.get("address"));
ps.setString(6,(String)registerForm.get("email"));
ps.setString(4,(String)registerForm.get("doj"));
ps.setInt(5,Integer.parseInt((String)registerForm.get("age")));
System.out.println("connected2");
if(ps.executeUpdate()==0)
status="fail";
else
status="ok";
}
catch (ClassNotFoundException ce) {
ce.printStackTrace();
}
catch(SQLException se)
{
se.printStackTrace();
}
finally
{
try
{
if(ps!=null)
ps.close();
}
catch (SQLException se) {
}
try
{
if(con!=null)
con.close();
}
catch(SQLException se)
{}
}
return mapping.findForward(status);
} // execute()
}