reportformkind.java~1~

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

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 expressInfoID = Tools.value(request, "expressInfoID");
        String classAnimal = Tools.value(request, "classAnimal");
        String classNumber = Tools.value(request, "classNumber");
        String classCharacter = Tools.value(request, "classCharacter");
        String deadNumber = Tools.formatStr(request.getParameter("deadNumber"),"0");
        String otherNumber = Tools.formatStr(request.getParameter("otherNumber"),"0");
        //插入语句
        String sql_ean = "insert into expressanimalnote (expressInfoID,classAnimal";
        sql_ean += ",classNumber,classCharacter,deadNumber,otherNumber) values('";
        sql_ean += expressInfoID + "','" + classAnimal + "','" + classNumber + "','";
        sql_ean += classCharacter + "'," + deadNumber + "," + otherNumber + ",";
        //测试代码
        System.out.println("新增异常动物："+ sql_ean);
        vv.add(sql_ean);
        return vv;
    }
    //执行sql语句方法
    public int sqlexe(java.util.Vector vv) {
        TransactionSql ts = new TransactionSql(conn);
        return ts.execTrans(vv);
    }

}