outscoutament.java~56~

野生动物系统的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.value(request, "x"); //经度
            String y = Tools.value(request, "y"); //纬度
            String z = Tools.value(request, "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"); //备注
            //调试代码
            System.out.println("结果是: " + id);
            System.out.println("结果是: " + Tools.formatStr(scoutsite));
            System.out.println("结果是: " + scoutaddr);
            System.out.println("结果是: " + scoutMan);
            System.out.println("结果是: " + scoutdate);
            //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 + "'";
            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 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]) + "'";
                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);
    }

}