querydata.java~3~

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

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);
            //stmt.close();
        } catch (java.sql.SQLException e) {
            System.out.println(
                    "insert or delete data form dabase have occured exception!");
        }
        return res;
    }

    public static void main(String[] args) {
        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){}
    }
}