超速违法代码计算

四个步骤：

1.	配置 Servlet ，使其能响应请求。
2.	编写 响应请求的类：ActionServlet.java
3.	编写接口 OverspeedDao.java
4.	编写 MyBatis 的映射文件：overspeedMapper.xml

配置 servlet

web.xml

  <servlet>
    <description>This is the description of my J2EE component</description>
    <display-name>This is the display name of my J2EE component</display-name>
    <servlet-name>OverspeedServlet</servlet-name>
    <servlet-class>overspeed.ActionServlet</servlet-class>
  </servlet>
  
  <servlet-mapping>
    <servlet-name>OverspeedServlet</servlet-name>
    <url-pattern>/OverspeedServlet</url-pattern>
  </servlet-mapping>

srcoverspeedActionServlet.java 

package overspeed;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import net.sf.json.JSONObject;

import com.sytz.db.TzkkDb;
import com.sytz.util.CZY;
import com.sytz.util.SYS;

public class ActionServlet extends HttpServlet {
    

    static OverspeedDao overspeedDao = new OverspeedDao();
    static Bean bean = new Bean();
    

    /*
     * 违法列表
     */
    private static List<Bean> violationNumberList ;
    
    
    
    TzkkDb tzkkdb=new TzkkDb();
    /**
     * Constructor of the object.
     */
    public ActionServlet() {
        super();
    }

    /**
     * Destruction of the servlet. <br>
     */
    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }

    /**
     * The doGet method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to get.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    @SuppressWarnings("unused")
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        
        JSONObject json = new JSONObject();
        json.accumulate("Method", "GET");
        out.println( json.toString() );
        
        out.flush();
        out.close();
    }

    /**
     * The doPost method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to post.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        

        HttpSession session = request.getSession();
//        String overspeedLevel = request.getParameter("overspeedLevel"); // 超速级别
        String overspeedNumber = request.getParameter("overspeedNumber"); // 超速编号
//        String overspeedDescription = request.getParameter("overspeedDescription"); // 超速描述
        String vehicleType = request.getParameter("vehicleType"); // 车辆类型 CLLX
        
        
//        if( overspeedLevel.equals("1") ){
//            overspeedDescription = "20%以下";
//            overspeedNumber = "01";
//        }else if(overspeedLevel.equals("2") ){
//            overspeedDescription = "20%以上50%以下";
//            overspeedNumber = "02";
//        }else if(overspeedLevel.equals("3") ){
//            overspeedDescription = "50%以上100%以下";
//            overspeedNumber = "03,05"; // 也可能是 “50%以上”
//        }else {
//            overspeedDescription = "100%以上";
//            overspeedNumber = "04,05"; // 也可能是 “50%以上”
//        };
        
        bean.setOverspeedNumber(overspeedNumber);
//        bean.setOverspeedDescription( overspeedDescription );
        
        
        String violationNumber = "" ;
        
//        bean.setOverspeedLevel( overspeedLevel );
        bean.setVehicleType( vehicleType );
        
        // 访问数据库
        violationNumberList = overspeedDao.selectList( bean );
        
        
        System.out.println( vehicleType );        
        System.out.println( overspeedNumber );        
        // 循环列表
        for( Bean b : violationNumberList ) {
            violationNumber = b.getViolationNumber();    
            System.out.println( violationNumber );
        }

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        
        JSONObject json = new JSONObject();

        json.accumulate("success", true);
        json.accumulate("Method", "POST");
        json.accumulate("vehicleType", vehicleType );
        json.accumulate("overspeedNumber", overspeedNumber );
        json.accumulate("violationNumber", violationNumber );
        out.println( json.toString() );
        
        out.flush();
        out.close();
        
    }

    /**
     * Initialization of the servlet. <br>
     *
     * @throws ServletException if an error occurs
     */
    public void init() throws ServletException {
        // Put your code here
    }

}

OverspeedDao.java

package overspeed;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import system.utils.MyBatisUtils;

public class OverspeedDao {

    
    
    /*
     * 读取 1 条记录
     */
    @SuppressWarnings("unchecked")
    public List<Bean> selectList(Bean bean){   

        // 开 Session
        SqlSession session = MyBatisUtils.openSession();
        List<Bean> list = null ;
        
        try {
            // 读取 1 条记录
            list = session.selectList( "overspeedMapper.selectList", bean );
        } catch ( Exception e) {
            e.printStackTrace();
        }finally {
            // 关闭 session
            session.close();
        }
        
        return list ;
        
    }
    

}

overspeedMapper.xml

<?xml version="1.0" encoding="UTF-8" ?> 
    <!DOCTYPE mapper 
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="overspeedMapper">

    <!-- + selectList + - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  -->
            <select id="selectList" parameterType="overspeed.Bean"
        resultType="overspeed.Bean" useCache="false">        
        
    <![CDATA[
    
        SELECT 
            T1.WFXWDM as violationNumber
        FROM BOCOITMS.ITMS_DICT_CLLX t
            LEFT JOIN BOCOITMS.ITMS_VES_WFCSMAPPING t1 ON t.CLDL = T1.CLDL
        WHERE t.CLLX = #{vehicleType}
            AND T1.CSBLDM in ( ${overspeedNumber} )
            AND ROWNUM = 1
    ]]>
        
    </select>    
    
    

</mapper>