showhighwyaction.java

地方划时代反函数的地方划时代反函数的地方划时代反函数的地方划时代反函数的

package HighWay.Action;

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 org.apache.struts.action.Action;
import Tool.High_Road.HighRoadTool;
import Tool.DBA.GetConn;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ShowHighWyAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest servletRequest,
                               HttpServletResponse servletResponse) {
    try {
      String strSQL = "";
      String highwayinfo = "";
      String high_way_name = servletRequest.getParameter("high_way_name");
      high_way_name = new String(high_way_name.getBytes("iso-8859-1"), "GB2312");
      strSQL = "select * from(select * from highway_jam where ROADNAME='" +
          high_way_name + "' order by id desc) where rownum<=1";

      GetConn gc = new GetConn();
      Connection conn = gc.getConnection();
      PreparedStatement pstmt = conn.prepareStatement(strSQL);
      ResultSet rs = pstmt.executeQuery(strSQL);

      while (rs.next()) {
        highwayinfo = (String) rs.getString("accinfo");
      }
      servletRequest.getSession().setAttribute("highwayinfo", highwayinfo);
      return actionMapping.findForward("high_road_result");
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return null;
  }
}