gsinfo.java

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

package scout.operation.gather_swatch;

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

/**
 * <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 GsInfo {
    public GsInfo() {
    }

    /** 返回某id的所有数据信息 */
    public IntGsInfo getIdInfo(String id) {
        IntGsInfo u = new IntGsInfo();
        try {
            ConnDataBase db = new ConnDataBase();
            Connection conn = db.getConnection();
            //QueryData qd = new QueryData(conn);

            //读取GsLogin数据并增加到GsInfo类中。
            String sql = "select * from swatchnote where ID ='" + id + "'";
            System.out.println("sql: " + sql);
            Statement s = conn.createStatement();
            ResultSet rs = s.executeQuery(sql);


            while (rs.next()) {
                u.setNumber(Tools.formatStr(rs.getString("number")));
                u.setAnimalClass(Tools.formatStr(rs.getString("animalClass")));
                u.setWorkMan(Tools.formatStr(rs.getString("workMan")));
                u.setPlace(Tools.formatStr(rs.getString("place")));
                u.setX(rs.getInt("x"));
                u.setY(rs.getInt("y"));
                u.setZ(rs.getInt("z"));
                u.setHabitatCharacter(Tools.formatStr(rs.getString("habitatCharacter")));
                u.setAnimalSource(Tools.formatStr(rs.getString("animalSource")));
                u.setCatchTime(rs.getDate("catchTime"));
                u.setCatchPlace(Tools.formatStr(rs.getString("catchPlace")));
                u.setBreedDate(Tools.formatStr(rs.getString("breedDate")));
                u.setBreedPlace(Tools.formatStr(rs.getString("breedPlace")));
                u.setDrinkSource(Tools.formatStr(rs.getString("drinkSource")));
                u.setOtherAnimal(Tools.formatStr(rs.getString("otherAnimal")));
                u.setWhetherTouch(Tools.formatStr(rs.getString("whetherTouch")));
                u.setImmunityCircs(Tools.formatStr(rs.getString("immunityCircs")));
                u.setOtherImmunity(Tools.formatStr(rs.getString("otherImmunity")));
                u.setAnimalDisposal(Tools.formatStr(rs.getString("animalDisposal")));
                u.setDutyMan(Tools.formatStr(rs.getString("dutyMan")));
            }
            rs.close();
            s.close();
            conn.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return u;
    }

    /** 返回某ID的所有数据信息 */
    public IntGsInfo getIdInfo1(String id) {
        IntGsInfo u = new IntGsInfo();
        try {
            ConnDataBase db = new ConnDataBase();
            Connection conn = db.getConnection();
            Statement s = conn.createStatement();

            //读取数据并增加到UserInfo类中。
            String sql =
                    "select * from swatchnote as a,swatchlist as b where a.ID = b.swatchNoteID " +
                    "and a.ID =" + id;
            System.out.println("sql: " + sql);
            ResultSet rs = s.executeQuery(sql);
            while (rs.next()) {
                u.setAID(rs.getInt("id"));
                u.setSwatchNoteID(rs.getInt("swatchNoteID"));
                u.setSnumber(Tools.formatStr(rs.getString("number")));
                u.setSwatchNumber(rs.getInt("swatchNumber"));
                u.setSwatchClass(Tools.formatStr(rs.getString("swatchClass")));
                u.setPackClass(Tools.formatStr(rs.getString("packClass")));

            }
            rs.close();
            s.close();
            conn.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return u;
    }


    public static void main(String[] args) {
        GsInfo gi = new GsInfo();
        GsLogin u = new GsLogin();
        u = gi.getIdInfo("5");
        System.out.println("ID:" + u.getID());

    }
}