package scout.operation.emergency;

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

/**
 * <p>Title:國(guó)家陸生野生動(dòng)物疫源疫病監(jiān)測(cè)信息系統(tǒng) </p>
 *
 * <p>Description:信息快報(bào)表取值 </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Chongqing Kemeida corporation</p>
 *
 * @author Leizhao
 * @version 1.0
 */
public class EmInfo {
    public EmInfo() {
    }

    /** 返回某id的所有數(shù)據(jù)信息 */
    public EmLogin getIdInfo(String id) {
        EmLogin u = new EmLogin();
        try {
            ConnDataBase db = new ConnDataBase();
            Connection conn = db.getConnection();
            //QueryData qd = new QueryData(conn);

            //讀取EmLogin數(shù)據(jù)并增加到EmInfo類中。
            String sql = "select * from emergency 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.setScoutSite(Tools.formatStr(rs.getString("scoutSite")));
                u.setScoutAddr(Tools.formatStr(rs.getString("scoutAddr")));
                u.setScoutMan(Tools.formatStr(rs.getString("scoutMan")));
                u.setScoutDate(rs.getDate("scoutDate"));
                u.setScoutTime(rs.getDate("scoutTime"));
            }
            rs.close();
            s.close();
            conn.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return u;
    }

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

    }
}