outscoutament.java~59~

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

package scout.operation.out_scout;

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 Bozeng
 * @version 1.0
 */
public class OutScoutAment {
    Connection conn = null;
    public OutScoutAment(Connection conn) {
        this.conn = conn;
    }

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        try {
            //the sql of fieldnote
            String id = Tools.value(request, "id");
            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 scoutMan = Tools.value(request, "scoutMan"); //监测人
            String scoutdate = Tools.value(request, "scoutdate"); //监测时间
            String habitatcharacter = Tools.value(request, "habitatcharacter"); //生境特征
            String remark = Tools.value(request, "remark"); //备注
            //调试代码
            //SQL语句
            String sqlfn = "update fieldnote set scoutsite='" +
                                   Tools.formatStr(scoutsite);
            sqlfn = sqlfn + "',scoutaddr='" +
                            Tools.formatStr(scoutaddr) + "',x='" +
                            Tools.formatStr(x) + "',y='" + Tools.formatStr(y);
            sqlfn = sqlfn + "',z='" + Tools.formatStr(z) +
                            "',scoutman='" + Tools.formatStr(scoutMan) +
                            "',scoutdate='";
            sqlfn = sqlfn + Tools.formatStr(scoutdate) +
                            "',habitatcharacter='" +
                            Tools.formatStr(habitatcharacter);
            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");
            //测试代码
            System.out.println("动物种类:" + classAnimal);


            for (int i = 0; i < classAnimal.length; i++) {
                System.out.println("动物" + i + ": " +
                                   Tools.formatStr(classAnimal[i]));
                sql[i] = "update animalnote set ";
                sql[i] += "classAnimal = '" + Tools.formatStr(classAnimal[i]) +
                        "'";
                sql[i] += "classNumber = '" + Tools.formatStr(classNumber[i]) +
                        "'";
                sql[i] += "classCharacter = '" +
                        Tools.formatStr(classCharacter[i]) +
                        "'";
                sql[i] += "symptom = '" + Tools.formatStr(symptom[i]) + "'";
                sql[i] += "deadNumber = '" + Tools.formatStr(deadNumber[i]) +
                        "'";
                sql[i] += "otherNumber = '" + Tools.formatStr(otherNumber[i]) +
                        "'";
                sql[i] += "firstConclusion = '" +
                        Tools.formatStr(firstConclusion[i]) +
                        "'";
                sql[i] += "sampling = '" + Tools.formatStr(sampling[i]) + "'";
                sql[i] += "localeDisposal = '" +
                        Tools.formatStr(localeDisposal[i]) +
                        "'";
                sql[i] += "animalDisposal = '" +
                        Tools.formatStr(animalDisposal[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);
    }

}