package strutsdemo.actions;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import strutsdemo.forms.myActionForm;
import org.apache.struts.action.Action;
import java.sql.*;

public class myAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest servletRequest,
                               HttpServletResponse servletResponse) {
  java.sql.Connection con=this.getConn();
  Statement stmt = null;
  java.util.List list=new java.util.ArrayList();
  java.util.Map map=null;

  try {
    stmt = con.createStatement();
    java.sql.ResultSet rs=stmt.executeQuery("SELECT key,content FROM map");
    while(rs.next()){
      map=new java.util.HashMap();
      map.put("key",rs.getString("key"));
       map.put("content",rs.getString("content"));
      list.add(map);

    }
  }
  catch (SQLException ex) {
    ex.printStackTrace();
  }
  servletRequest.setAttribute("data",list);
  return actionMapping.findForward("output");


  }

  private java.sql.Connection getConn(){
   java.sql.Connection con=null;
   try {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con=java.sql.DriverManager.getConnection("dbc:odbc:MSdb");

   }
   catch (Exception ex) {
     ex.printStackTrace();
   }
   return con;
  }
}