addswatch.java~5~

野生动物系统的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 AddSwatch {
    Connection conn = null;
    public AddSwatch(Connection conn) {
        this.conn = conn;
    }

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        //the sql of swatchlist
        String swatchNoteID = Tools.value(request, "swatchNoteID");
        String swatchClass = Tools.value(request, "swatchClass");
        String number = Tools.value(request, "number");
        String packClass = Tools.value(request, "packClass");
        String swatchNumber = Tools.formatStr(request.getParameter("swatchNumber"),"0");

        String sql_swatchlist = "insert into swatchlist (swatchNoteID,swatchClass,number,swatchNumber,";
        sql_swatchlist += "packClass) values('" + swatchNoteID + "','" + swatchClass + "','" + number;
        sql_swatchlist += "','" + swatchNumber + "'," + packClass + ")";
        System.out.println("新增样本种类："+ sql_swatchlist);
        vv.add(sql_swatchlist);
        return vv;
    }
    //执行sql语句方法
    public int sqlexe(java.util.Vector vv) {
        TransactionSql ts = new TransactionSql(conn);
        return ts.execTrans(vv);
    }

}