amentemergency.java

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

package scout.operation.emergency;

import java.util.*;
import scout.util.*;
import scout.database.util.*;
import java.sql.*;

/**
 * <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 AmentEmergency {
    public AmentEmergency() {
    }
    Connection con = null;
    /** 返回所有数据 */
    public Vector getResult(String id) {
        Vector v = new Vector();
        ConnDataBase db = new ConnDataBase();
        this.con = db.getConnection();
        QueryData qd = new QueryData(con);
        String sql = "select * from emergencyanimal where emergencyID =" + id;
        System.out.println("sql:"+sql);
        ResultSet rs = qd.getResultSet(sql);
        try {
            while (rs.next()) {
                Object[] obj = new Object[6];//读取两个数据。
                obj[0] = rs.getString("classAnimal");
                obj[1] = rs.getString("classNumber");
                obj[2] = rs.getString("classCharacter");
                obj[3] = rs.getInt("otherNumber");
                obj[4] = rs.getInt("deadNumber");
                obj[5] = rs.getString("id");

                //查找与之对应的权限名称。
                System.out.println("obj[0]: " + obj[0]);
                System.out.println("obj[5]: " + obj[5]);
                v.add(obj);
            }
            rs.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return v;
    }

    public static void main(String[] args) {
        AmentEmergency ae = new AmentEmergency();
        Vector v = new Vector();
        v = ae.getResult("4");
    }
}