ament.java~10~

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

package scout.operation.out_scout;

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 Bozeng
 * @version 1.0
 */
public class Ament {
    public Ament() {
    }
    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 animalnote where  = " + id;
        System.out.println("sql:"+sql);
        ResultSet rs = qd.getResultSet(sql);
        try {
            while (rs.next()) {
                Object[] obj = new Object[11];//读取两个数据。
                obj[0] = rs.getString("classAnimal");
                obj[1] = rs.getString("classNumber");
                obj[2] = rs.getString("classCharacter");
                obj[3] = rs.getString("symptom");
                obj[4] = rs.getInt("deadNumber");
                obj[5] = rs.getInt("otherNumber");
                obj[6] = rs.getString("firstConclusion");
                obj[7] = rs.getInt("sampling");
                obj[8] = rs.getString("localeDisposal");
                obj[9] = rs.getString("animalDisposal");
                obj[10] = rs.getString("id");

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

    public static void main(String[] args) {
        Ament ament = new Ament();
        Vector v = new Vector();
        v = ament.getResult("1");
    }
}