civiinfo.java~12~

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

package scout.civi_info;

/**
 * <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 CiviInfo {
    Connection conn = null;
    public CiviInfo(Connection conn) {
        this.conn = conn;
    }
public java.util.Vector getSql(HttpServletRequest request) {
    java.util.Vector vv = new java.util.Vector();
    //the sql of civiinfo
    String name = Tools.value(request, "name"); //监测区域
    String tel = Tools.value(request, "tel"); //联系电话
    String animalDisposal = Tools.value(request, "animalDisposal"); //异常动物情况
    String address = Tools.value(request, "address"); //发生地点
    String remark = Tools.value(request, "remark"); //备注

    String sql_civiinfo = "insert into civiinfo (address,tel,animalDisposal,address";
    sql_civiinfo += ",remark) values('" + name + "','" + tel + "','";
    sql_civiinfo += animalDisposal + "','" + address + "','" + remark + "')";

    System.out.println("增加群众举报表：" + sql_civiinfo);

    vv.add(sql_civiinfo);
    return vv;
}

//执行SQL语句方法
public int sqlexe(java.util.Vector vv) {
    scout.database.util.TransactionSql ts = new scout.database.util.
                                            TransactionSql(conn);
    return ts.execTrans(vv);
}

}