emergencyament.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 EmergencyAment {
    Connection conn = null;
    public EmergencyAment(Connection conn) {
        this.conn = conn;
    }

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        try {
            //the sql of emergency
            String id = Tools.value(request, "id");
            String number = Tools.value(request,"number");
            String scoutSite = Tools.value(request, "scoutSite"); //监测站点
            String scoutAddr = Tools.value(request, "scoutAddr"); //监测区域
            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 scoutTime = Tools.value(request, "scoutTime");
            String scoutMan = Tools.value(request, "scoutMan");
            String symptom = Tools.value(request, "symptom");
            String firstConclusion = Tools.value(request, "firstConclusion");
            String animalDisposal = Tools.value(request, "animalDisposal");
            String checkDisposal = Tools.value(request, "checkDisposal");
            String checkResult = Tools.value(request, "checkResult");
            String dutyMan = Tools.value(request, "dutyMan"); // 负责人
            String scoutDate = Tools.value(request, "scoutDate"); //监测时间
            String remark = Tools.value(request, "remark"); //备注
            //调试代码
            //SQL语句
String sqlfn = "update emergency set scoutSite='"+Tools.formatStr(scoutSite)+"',";
            sqlfn += "scoutAddr='"+Tools.formatStr(scoutAddr)+"',";
            sqlfn += "number='"+Tools.formatStr(number)+"',";
            sqlfn += "x='"+Tools.formatStr(x)+"',";
            sqlfn += "y='"+Tools.formatStr(y)+"',";
            sqlfn += "z='" + Tools.formatStr(z) + "',";
            sqlfn += "scoutMan='" + Tools.formatStr(scoutMan) + "',";
            sqlfn += "scoutDate='" + Tools.formatStr(scoutDate) + "',";
            sqlfn += "scoutTime='" + Tools.formatStr(scoutTime) + "',";
            sqlfn = sqlfn + "',remark='" +
                            Tools.formatStr(remark) +
                            "' where ID='" +
                            id + "'";
            System.out.println("sql语句为(fieldnote):" + sqlfn);
            vv.add(sqlfn);

            //---------------对异常动物种类表进行操作----------------------------
            //获取从表的记录.
            String[] aid = request.getParameterValues("aid");
            System.out.println("记录长度:" + aid.length);
            //sql列表.
            String sql[] = new String[aid.length];
            String[] classAnimal = request.getParameterValues("classAnimal"); //非空
            String[] classNumber = request.getParameterValues("classNumber");
            String[] classCharacter = request.getParameterValues(
                    "classCharacter");
            String[] symptom = request.getParameterValues("symptom");
            String[] deadNumber = request.getParameterValues("deadNumber");
            String[] otherNumber = request.getParameterValues("otherNumber");
            String[] firstConclusion = request.getParameterValues(
                    "firstConclusion");
            String[] sampling = request.getParameterValues("sampling");
            String[] localeDisposal = request.getParameterValues(
                    "localeDisposal");
            String[] animalDisposal = request.getParameterValues(
                    "animalDisposal");

            for (int i = 0; i < classAnimal.length; i++) {
                System.out.println("动物" + i + ": " +
                                   Tools.formatStr(classAnimal[i]));
                sql[i] = "update emergencyanimal set ";
                sql[i] += "classAnimal='" + Tools.formatStr(classAnimal[i]) + "',";
                sql[i] += "classNumber='" + Tools.formatStr(classNumber[i]) + "',";
                sql[i] += "classCharacter='" + Tools.formatStr(classCharacter[i]) + "',";
                sql[i] += "deadNumber='" + Tools.formatStr(deadNumber[i]) + "',";
                sql[i] += "otherNumber='" + Tools.formatStr(otherNumber[i]) + "',";
                sql[i] += " where id = '" + Tools.formatStr(aid[i]) + "'";
                System.out.println("sql语句为(animalnote):" + sql[i]);
                vv.add(sql[i]);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        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);
    }

}