Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here an example of how I was able to get a suggest box to work. I make an RPC call to the database while the user is typing. </p> <p>I agree that you could do something similar in jQuery but why would you when GWT has the widget available? </p> <p>Hope this helps!</p> <p><img src="https://i.stack.imgur.com/r0jPB.png" alt="enter image description here"> </p> <pre><code>vendorSuggestBox = new SuggestBox(new SuggestionOracle()); //client package public class SuggestionOracle extends SuggestOracle { //shared package public boolean isDisplayStringHTML() { return true; } @SuppressWarnings("unchecked") public void requestSuggestions(Request request, Callback callback) { ItemMovementRemoteServiceAsync service=GWT.create(ItemMovementRemoteService.class); service.getVendors(request, new SuggestionCallback(request,callback)); } @SuppressWarnings("unchecked") class SuggestionCallback implements AsyncCallback { private SuggestOracle.Request req; private SuggestOracle.Callback callback; public SuggestionCallback(SuggestOracle.Request _req, SuggestOracle.Callback _callback) { req=_req; callback=_callback; } public void onFailure(Throwable caught) { callback.onSuggestionsReady(req, new SuggestOracle.Response()); } public void onSuccess(Object result) { callback.onSuggestionsReady(req, (SuggestOracle.Response) result); } } public SuggestOracle.Response getVendors(Request req) { //server package Connection db=null; PreparedStatement ps=null; ResultSet rs=null; SuggestOracle.Response resp = new SuggestOracle.Response(); List&lt;Suggestion&gt; suggestions=new ArrayList&lt;Suggestion&gt;(); int count=0; try { db=Database.open("ACM0"); ps=db.prepareStatement( " SELECT VE_CD,upper(VE_NAME) VE_NAME" + " FROM AP.VE_WEB " + " WHERE (VE_NAME NOT LIKE 'AC Moore%') " + " AND (lower(VE_NAME) LIKE ? OR VE_CD LIKE ?)" + " ORDER BY VE_NAME"); ps.setString(1, "%"+req.getQuery().toLowerCase()+"%"); ps.setString(2, "%"+req.getQuery().toLowerCase()+"%"); rs=ps.executeQuery(); while(rs.next() &amp;&amp; count &lt; 25) { suggestions.add(new ASuggestion(rs.getString("VE_NAME").trim()+"-"+rs.getString("VE_CD").trim())); count++; } resp.setSuggestions(suggestions); } catch (Exception ex) { ex.printStackTrace(); } finally { Database.close(db); } return resp; } public class ASuggestion implements IsSerializable, Suggestion { //shared package model object private String s; public ASuggestion(){} public ASuggestion(String s) { this.s=s; } public String getDisplayString() { return s; } public String getReplacementString() { return s; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POGWT AutoSuggest In JSP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USbmoran
    1. USbmoran
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload