addanimal.java

来自「野生动物系统的JAVA源码, 野生动物系统的JAVA源码」· Java 代码 · 共 53 行

package scout.operation.emergency;

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

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        //the sql of emergencyanimal
        String emergencyID = Tools.value(request, "emergencyID");
        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_emergencyanimal = "insert into emergencyanimal (emergencyID,classAnimal,classNumber,classCharacter,deadNumber,";
        sql_emergencyanimal += "otherNumber) values('" + emergencyID + "','" + classAnimal + "','" + classNumber;
        sql_emergencyanimal += "','" + classCharacter + "'," + deadNumber + "," + otherNumber + ")";
        System.out.println("新增异常动物："+ sql_emergencyanimal);
        vv.add(sql_emergencyanimal);
        return vv;
    }
    //执行sql语句方法
    public int sqlexe(java.util.Vector vv) {
        TransactionSql ts = new TransactionSql(conn);
        return ts.execTrans(vv);
    }

}