gatherswatch.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 GatherSwatch {
     Connection conn = null;
    public GatherSwatch(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 number = Tools.value(request, "number"); //编号
        String animalClass = Tools.value(request, "animalClass"); //动物种类
        String place = Tools.value(request, "place"); //采样地点
        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 habitatCharacter = Tools.value(request, "habitatCharacter"); //生境特征
        String workMan = Tools.value(request, "workMan"); //采样人
        String whetherFlit = Tools.value(request, "whetherFlit"); //是否迁徙
        String catchTime = Tools.value(request, "catchTime"); //抓捕时间
        String catchPlace = Tools.value(request, "catchPlace"); //抓捕地点
        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 animalDisposal = Tools.value(request, "animalDisposal"); //采样动物处理情况
        String dutyMan = Tools.value(request, "dutyMan"); //负责人

        String sql_swatchnote = "insert into swatchnote (number,animalClass,place,x,y,z,habitatCharacter";
        sql_swatchnote += ",workMan,whetherFlit,catchTime,catchPlace,breedDate,breedPlace,drinkSource,otherAnimal,";
        sql_swatchnote += "whetherTouch,immunityCircs,otherImmunity,animalDisposal";
        sql_swatchnote += ",dutyMan) values('" + number + "','" + animalClass + "','" + place + "'," + x;
        sql_swatchnote += "," + y + "," + z + ",'" + habitatCharacter + "','" + workMan + "','";
        sql_swatchnote += whetherFlit + "','" + catchTime + "','" + catchPlace + "','" + breedDate + "','";
        sql_swatchnote += breedPlace + "','" + drinkSource + "','" + otherAnimal + "','" + whetherTouch;
        sql_swatchnote += "','" + immunityCircs + "','" + otherImmunity + "','" + animalDisposal + "','" + dutyMan + "')";

        System.out.println("增加样本采集记录表：" + sql_swatchnote);

        vv.add(sql_swatchnote);
        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);
    }

    public String getMaxid() throws SQLException {
     QueryData qd = new QueryData(conn);
     String theMaxId = "";
     //the sql of emergency maxid
     String sql_getid = "select max(id) as maxId from emergency";
     ResultSet res = qd.getResultSet(sql_getid);
     if (res.next())
         theMaxId = res.getString("maxId");
     return theMaxId;
 }


}