emergency.java~4~

野生动物系统的JAVA源码, 野生动物系统的JAVA源码

package scout.operation.emergency;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import scout.util.*;
import scout.database.util.*;

/**
 * <p>Title: </p>
 *
 * <p>Description:信息快报 </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Chongqing Kemeida corporation</p>
 *
 * @author Leizhao
 * @version 1.0
 */

public class emergency {
     Connection conn = null;
    public emergency(Connection conn) {
        this.conn = conn;
    }
    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        //the sql of emergency
        String ID = Tools.value(request, "ID"); //编号
        String scoutDate = Tools.value(request, "scoutDate"); //报告时间
        //String x = Tools.formatStr(request.getParameter("x"), "0"); //经度
        String x = Tools.formatStr(request.getParameter("x"), "0"); //经度
        String y = Tools.formatStr(request.getParameter("y"), "0"); //纬度
        String z = Tools.formatStr(request.getParameter("z"), "0"); //海拔
        System.out.println("x,y,z : " + x + y + z);
        String scoutSite = Tools.value(request, "scoutSite"); //监测单位
        String scoutAddr = Tools.value(request, "scoutAddr"); //发现地点
        String scoutTime = Tools.value(request, "scoutTime"); //发现时间
        String symptom = Tools.value(request, "symptom"); //症状描述
        String firstConclusion = Tools.value(request, "firstConclusion"); //初检结论
        String animalDisposal = Tools.value(request, "animalDisposal"); //异常动物情况
        String localeDisposal = Tools.value(request, "localeDisposal"); //现场处理情况
        String checkDisposal = Tools.value(request, "checkDisposal"); //报检情况
        String checkResult = Tools.value(request, "checkResult"); //现场检验结果
        String scoutMan = Tools.value(request, "scoutMan"); //监测人
        String dutyMan = Tools.value(request, "dutyMan"); //负责人

        String sql_emergency = "insert into emergency (ID,scoutDate,x,y,z,scoutSite";
        sql_emergency += ",scoutAddr,scoutTime,symptom,firstConclusion,animalDisposal,";
        sql_emergency += "checkDisposal,checkResult,scoutMan";
        sql_emergency += ",dutyMan) values('" + ID + "','" + scoutDate + "'," + x;
        sql_emergency += "," + y + "," + z + ",'" + scoutSite + "','" + scoutAddr + "','";
        sql_emergency += scoutTime + "','" + symptom + "','" + firstConclusion + "','";
        sql_emergency += animalDisposal + "','" + checkDisposal;
        sql_emergency += "','" + checkResult + "','" + scoutMan + "','" + dutyMan + "')";

        System.out.println("增加信息快报主表：" + sql_emergency);

        vv.add(sql_emergency);
        return vv;
    }

    //执行SQL语句方法
    public int sqlexe(java.util.Vector vv) {
        scout.database.util.TransactionSql ts = new scout.database.util.
                                                TransactionSql(conn);
        return ts.execTrans(vv);
    }
}