querydata.java

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

package scout.database.util;

/**
 * <p>Title: </p>
 *
 * <p>Description:this class connect database of my sql,and return the object of connection </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Chongqing Kemeida corporation</p>
 *
 * @author Bozeng
 * @version 1.0
 */
import java.sql.*;
import java.util.*;


public class QueryData {
    Connection conn = null;
    /**
     * init parameter
     * @param conn Connection
     */
    public QueryData(Connection conn) {
        this.conn = conn;
    }

    /**
     * this method is for insert or delete data from database
     * @param sqlStr String
     * @return int
     */
    public ResultSet getResultSet(String sqlStr) {
        ResultSet res = null;
        try {
            Statement stmt = conn.createStatement();
            res = stmt.executeQuery(sqlStr);
        } catch (java.sql.SQLException e) {
            System.out.println();
        }
        return res;
    }

    public static void main(String[] args) throws Exception  {
        ConnDataBase cdb = new ConnDataBase();
        QueryData qd = new QueryData(cdb.getConnection());
        ResultSet res = qd.getResultSet("select * from login_info");
        try {
            if (res.next()) {
                System.out.println(res.getString(1));
            }
        } catch (Exception e) {}
    }
}