outscoutkind.java~25~

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

package scout.operation.out_scout;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Chongqing Kemeida corporation</p>
 *
 * @author Leizhao
 * @version 1.0
 */
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import scout.util.*;
import scout.database.util.*;

public class OutScoutKind {
    Connection conn = null;
    public OutScoutKind(Connection conn) {
        this.conn = conn;
    }

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        //the sql of animalnote
        String fieldNoteID = Tools.value(request, "fieldNoteID");
        String classAnimal = Tools.value(request, "classAnimal");
        String classNumber = Tools.value(request, "classNumber");
        String classCharacter = Tools.value(request, "classCharacter");
        String symptom = Tools.value(request, "symptom");
        String deadNumber = Tools.formatStr(request.getParameter("deadNumber"),"0");
        String otherNumber = Tools.formatStr(request.getParameter("otherNumber"),"0");
        String firstConclusion = Tools.value(request, "firstConclusion");
        String sampling = Tools.value(request, "sampling");
        String localeDisposal = Tools.value(request, "localeDisposal");
        //是否取样,取样时sampling=1
        if(sampling==null){
            sampling = "0";
        }
        String sql_animalnote =
                "insert into animalnote (fieldNoteID,classAnimal,classNumber,classCharacter,symptom,deadNumber,";
        sql_animalnote = sql_animalnote +
                         "otherNumber,firstConclusion,sampling,localeDisposal) values('" +
                         fieldNoteID + "','" + classAnimal + "','" + classNumber;
        sql_animalnote = sql_animalnote + "','" + classCharacter + "','" +
                         symptom + "','" +
                         deadNumber + "','" + otherNumber + "','";
        sql_animalnote = sql_animalnote + firstConclusion + "','" + sampling +
                         "','" +
                         localeDisposal + "')";
        System.out.println("新增异常动物："+ sql_animalnote);
        vv.add(sql_animalnote);
        return vv;
    }
    //执行sql语句方法
    public int sqlexe(java.util.Vector vv) {
        TransactionSql ts = new TransactionSql(conn);
        return ts.execTrans(vv);
    }

}