outscout.java

野生动物系统的JAVA源码, 野生动物系统的JAVA源码

package scout.operation.out_scout;

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

    public java.util.Vector getSql(HttpServletRequest request) {
        java.util.Vector vv = new java.util.Vector();
        //the sql of fieldnote
        String scoutsite = Tools.value(request, "scoutsite"); //监测站点
        String scoutaddr = Tools.value(request, "scoutaddr"); //监测区域
        //String x = Tools.formatStr(request.getParameter("x"), "0"); //经度
        String x = Tools.formatStr(request.getParameter("x"), "0"); //经度
        String y = Tools.formatStr(request.getParameter("y"), "0"); //纬度
        String z = Tools.formatStr(request.getParameter("z"), "0"); //海拔
        System.out.println("x,y,z : " + x + y + z);
        String scoutMan = Tools.value(request, "scoutMan"); //监测人
        String scoutdate = Tools.value(request, "scoutdate"); //监测时间
        String habitatcharacter = Tools.value(request, "habitatcharacter"); //生境特征
        String remark = Tools.value(request, "remark"); //备注

        String sql_fieldnote =
                "insert into fieldnote (scoutsite,scoutaddr,x,y,z,scoutMan,";
        sql_fieldnote = sql_fieldnote +
                        "scoutdate,habitatcharacter,remark) values('" +
                        scoutsite + "','" +
                        scoutaddr + "'," + x;
        sql_fieldnote = sql_fieldnote + "," + y + "," + z + ",'" +
                        scoutMan + "','" +
                        scoutdate + "','" + habitatcharacter + "','" + remark +
                        "')";

        System.out.println("增加监测记录主表：" + sql_fieldnote);

        vv.add(sql_fieldnote);
        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;
    }

}