civiinfo.java~7~

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

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,remark) values('" +
  name + "','" + tel + "'," + 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);
}

//查询ID最大值方法
public String getMaxid() throws SQLException {
    QueryData qd = new QueryData(conn);
    String theMaxId = "";
    //the sql of fieldnote maxid
    String sql_getid = "select max(id) as maxId from fieldnote";
    ResultSet res = qd.getResultSet(sql_getid);
    if (res.next())
        theMaxId = res.getString("maxId");
    return theMaxId;
}

}