reportformkind.java~2~

来自「野生动物系统的JAVA源码, 野生动物系统的JAVA源码」· JAVA~2~ 代码 · 共 67 行

package scout.operation.report_form;

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

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        //the sql of expressanimalnote
        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.formatStr(request.getParameter("sampling"),"0");
        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);
    }

}