civiset.java~11~

来自「野生动物系统的JAVA源码, 野生动物系统的JAVA源码」· JAVA~11~ 代码 · 共 64 行

package scout.civi_info;

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 CiviSet {
    public CiviSet() {
    }

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

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

            while (rs.next()) {
                u.setID(rs.getInt("id"));
                u.setName(Tools.formatStr(rs.getString("name")));
                u.setTel(Tools.formatStr(rs.getString("tel")));
                u.setAnimalDisposal(Tools.formatStr(rs.getString("animalDisposal")));
                u.setFoundDate(rs.getDate("foundDate"));
                u.setAddress(Tools.formatStr(rs.getString("address")));
                u.setRemark(Tools.formatStr(rs.getString("remark")));
            }
            rs.close();
            s.close();
            conn.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return u;
    }

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

    }
}