infoaction.java~9~

一个基于Struts架构

package wkhTest;

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 java.io.PrintWriter;
import java.sql.*;

public class InfoAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse) throws Exception{
        InfoForm infoForm = (InfoForm) actionForm;

        if(infoForm.getAction().equals("ShowInfo")){
            servletRequest.setAttribute("Info",infoForm);
            return actionMapping.findForward("ShowInfo");
        }
        else  if(infoForm.getAction().equals("GetData_P")){
            PrintWriter out = servletResponse.getWriter();
            String strTemp="";
            String typing = infoForm.getName();
            //连数据库

            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").
                    newInstance();
            String url =
                    "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=portal";

            String user = "sa";
            String password = "";
            Connection conn = DriverManager.getConnection(url, user, password);
            Statement stmt = conn.createStatement(ResultSet.
                                                  TYPE_SCROLL_SENSITIVE,
                                                  ResultSet.CONCUR_UPDATABLE);
            String sql =
                    "select * from P_areacode where id like '%0000' and jp like '" +
                    typing + "%' ";
            if (typing.equals("") || typing.equals(" ")) {
                sql = "select * from P_areacode where id like '%0000' ";
            }
            ResultSet rs = stmt.executeQuery(sql);
            String area = "";
            String no = "";

            while (rs.next()) {
                area = rs.getString("area");
                no = rs.getString("id");
                no = no.substring(0, 2);
            }
             rs.close();
             stmt.close();
             conn.close();

            strTemp+="<div onselect='this.text.value = '"+area+"';$('PID').value = '"+no+"';$('Pold').value = '"+area+"';$('CID').value = '000000';$('city').value = '';$('AID').value = '000000';$('area').value = '';'><span class='informal'>No."+no+"</span>"+area+"</div>";
            out.write(strTemp);

            return null;
        }


        return null;
    }
}