statement的内存问题，在线给分

Question

stmt要你自己释放的，做成ConnectingPool应该更好些

Answer 1

public ResultSet executeQuery(String sql)
    {
        rs=null;
        try
        {
            conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            rs=stmt.executeQuery(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("sql_data.executeQuery:"+ex.getMessage());
}finally{
stmt.close();
conn.close();
}
        return rs ;
    }