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();
  java.sql.Statement  stmt=con.createStatement();
  java.sql.ResultSet rs=stmt.executeQuery("SELECT key,content FROM map");
   
  }
  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;
  }
}