gatherswatchament.java~2~

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

package scout.operation.gather_swatch;

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

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        try {
            //the sql of swatchnote
            String id = Tools.value(request, "id");
            String number = Tools.value(request,"number"); //编号
            String place = Tools.value(request,"place"); //地点
            String animalClass = Tools.value(request,"animalClass"); //动物种类
            String workMan = Tools.value(request,"workMan"); //采样人
            String habitatCharacter = Tools.value(request,"habitatCharacter"); //生境
            String catchTime = Tools.value(request, "catchTime"); //监测站点
            String catchPlace = Tools.value(request, "catchPlace"); //监测区域
            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 breedDate = Tools.value(request, "breedDate");
            String breedPlace = Tools.value(request, "breedPlace");
            String drinkSource = Tools.value(request, "drinkSource");
            String otherAnimal = Tools.value(request, "otherAnimal");
            String whetherTouch = Tools.value(request, "whetherTouch");
            String immunityCircs = Tools.value(request, "immunityCircs");
            String otherImmunity = Tools.value(request, "otherImmunity");
            String dutyMan = Tools.value(request, "dutyMan"); // 负责人
            String animalDisposal = Tools.value(request, "animalDisposal"); //监测时间

            //调试代码
            //SQL语句
            String sqlsn = "update swatchnote set number='"+Tools.formatStr(number)+"',";
            sqlsn += "place='"+Tools.formatStr(place)+"',";
            sqlsn += "animalClass='"+Tools.formatStr(animalClass)+"',";
            sqlsn += "x='"+Tools.formatStr(x)+"',";
            sqlsn += "y='"+Tools.formatStr(y)+"',";
            sqlsn += "z='" + Tools.formatStr(z) + "',";
            sqlsn += "workMan='" + Tools.formatStr(workMan) + "',";
            sqlsn += "habitatCharacter='" + Tools.formatStr(habitatCharacter) + "',";
            sqlsn += "catchTime='" + Tools.formatStr(catchTime) + "',";
            sqlsn += "catchPlace='" + Tools.formatStr(catchPlace) + "',";
            sqlsn += "breedDate='" + Tools.formatStr(breedDate) + "',";
            sqlsn += "animalDisposal='" + Tools.formatStr(animalDisposal) + "',";
            sqlsn += "breedPlace='" + Tools.formatStr(breedPlace) + "',";
            sqlsn += "drinkSource='" + Tools.formatStr(drinkSource) + "',";
            sqlsn += "dutyMan='" + Tools.formatStr(dutyMan) + "',";
            sqlsn += "otherAnimal='" + Tools.formatStr(otherAnimal) + "',";
            sqlsn += "whetherTouch='" + Tools.formatStr(whetherTouch) + "',";
            sqlsn += "immunityCircs='" + Tools.formatStr(immunityCircs) + "',";
            sqlsn += "otherImmunity='" + Tools.formatStr(otherImmunity) + "' where ID='" + id + "'";
            System.out.println("sql语句为(swatchnote):" + sqlsn);
            vv.add(sqlsn);

            //---------------对样本种类表进行操作----------------------------
            //获取从表的记录.
            String[] aid = request.getParameterValues("aid");
            System.out.println("记录长度:" + aid.length);
            //sql列表.
            String sql[] = new String[aid.length];
            String[] snumber = request.getParameterValues("snumber"); //非空
            String[] swatchClass = request.getParameterValues(
                    "swatchClass");
            String[] swatchNumber = request.getParameterValues("swatchNumber");
            String[] packClass = request.getParameterValues("packClass");

            for (int i = 0; i < snumber.length; i++) {
                System.out.println("样本" + i + ": " +
                                   Tools.formatStr(snumber[i]));
                sql[i] = "update swatchlist set ";
                sql[i] += "number='" + Tools.formatStr(snumber[i]) + "',";
                sql[i] += "swatchClass='" + Tools.formatStr(swatchClass[i]) + "',";
                sql[i] += "swatchNumber='" + Tools.formatStr(swatchNumber[i]) + "',";
                sql[i] += "packClass='" + Tools.formatStr(packClass[i]) + "' ";
                sql[i] += " where id = '" + Tools.formatStr(aid[i]) + "'";
                System.out.println("sql语句为(swatchlist):" + 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);
    }

}