Solved

JTree -> SQL query

Posted on 2004-09-29
17
442 Views
Last Modified: 2006-11-17
Hello,
I have a JTree which represents an SQL where clause:
eg,
AND
   var > 10
   var2 = text
   OR
       var3 > 2
       var4 < 2
etc.

I'm going to stick this tree in a JSplitPane and then Im going to make a dynamic parser as the right component - just the representative SQL statement
eg,
WHERE
{
    var > 10  AND
    var2 = text AND
or whatever!!

I want to know what would be the best JComponent to use to display this SQL statement??
eg, it would be easy to generate XML from the tree and this XML could allow me to specify, font color, bold,  indents (for groups AND, OR) etc.

What do you think??
Thanks
0
Comment
Question by:cathalmchale
  • 9
  • 8
17 Comments
 
LVL 37

Expert Comment

by:zzynx
ID: 12180537
>> it would be easy to generate XML from the tree and this XML could allow me to specify, font color, bold,  indents (for groups AND, OR) etc.
JTextArea I suppose
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12180563
Sorry, I meant JTextPane, since it allows the use of StyledDocument
0
 

Author Comment

by:cathalmchale
ID: 12180652
Ok, would you have any simple examples with similar functionality you could point me towards please?
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 37

Expert Comment

by:zzynx
ID: 12180744
0
 

Author Comment

by:cathalmchale
ID: 12180935
thanks.
i have the following XML generated for other reasons, i want to reuse this:

- <filter-definition>
-    <filter-group logic="AND">
        <filter field="Address" operator="=" value="2" />
        <filter field="customer_name" operator="=" value="john" />
-       <filter-group logic="OR">
           <filter field="EleInPort" operator="=" value="22" />
        </filter-group>
     </filter-group>
  </filter-definition>

I presume this is OK - I can do something like:
if its a <filter-group>
    set text color, style etc
    print string
else
...
And keeping track of indents??  should all be ok i think
0
 

Author Comment

by:cathalmchale
ID: 12180979
>>And keeping track of indents??  should all be ok i think
 the tab-stops at this link I guess!!

cheers
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12180984
>>should all be ok i think
Don't have any experience with it, but I think it, yeah.
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12181012
>> the tab-stops at this link I guess!!
???
0
 

Author Comment

by:cathalmchale
ID: 12188310
Hi again,

im using
StyledDocument sqlDoc = new DefaultStyledDocument();
and I have some Styles set up, so I can use
sqlDoc.insertString(sqlDoc.getLength(), "Some text", style);

but how do I specify the tab position at where I want this text inserted - this position is relative to the recursion number -> each time I recurse ill add 10 to this tab position for example.
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12188379
Just an idea: can't you use "\t" ?
sqlDoc.insertString(sqlDoc.getLength(), "\tSome text", style);


StringBuffer tabs = new StringBuffer("\t");
In your loop: tabs.append("\t");
sqlDoc.insertString(sqlDoc.getLength(), tabs.toString()+"Some text", style);
0
 

Author Comment

by:cathalmchale
ID: 12188389
Also, it seems that you must associate a Style with a document - and initialise everything at the beginning.
I had imagined that each time I wanted to redraw the JTextPane I would do:

StyledDocument sqlDoc = new DefaultStyledDocument();
// could use some Styles initialised as fields in the class
sqlDoc.insertString(sqlDoc.getLength(), "Some text", style);

//then finally to update evrything
jTextPane.setDocument(sqlDocument);

but I can't do this because of the StyledDocument interface - so what do I do, just set-up everything (new doc, add new styles etc.) each time???
0
 

Author Comment

by:cathalmchale
ID: 12188407
>> Just an idea: can't you use "\t" ?

i guess I could try this, but the "tab-stops" idea which was in the link you posted me, perhaps seems like a better idea??  but I am not sure how to dynamically implement this like your dynamic  >>In your loop (RECURSION): tabs.append("\t");
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12188810
>> so what do I do, just set-up everything
No. You can

    // 1) Start with the current input attributes for the JTextPane:
    MutableAttributeSet attrs = jTextPane.getInputAttributes();
    // 2) Change some attributes

    // 3) Retrieve the pane's document object
    StyledDocument doc = jtp.getStyledDocument();
   
    // 4) Apply the new attributes
    doc.setCharacterAttributes(...)

Have a look at the last example at http://javatechniques.com/public/java/docs/basics/jtextpane-font.html

Also interesting: http://javaalmanac.com/egs/javax.swing.text/style_HiliteWords2.html
0
 

Author Comment

by:cathalmchale
ID: 12189902
OK thanks, I have it working beautifully now with 1 small exception !! :)

the "\t" tab is too big, how do i set it to a smaller size??
0
 
LVL 37

Accepted Solution

by:
zzynx earned 250 total points
ID: 12190013
0
 

Author Comment

by:cathalmchale
ID: 12190577
thanks all working well now,
what a lot of hassle ;-)

Cathal,
P.S. shud i post my solution - it may be of help to others, but the code is quite long
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12190661
Thanks for accepting

>> thanks all working well now,
Nice!
>> what a lot of hassle ;-)
:)

>>P.S. shud i post my solution - it may be of help to others, but the code is quite long
You decide

0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How do I remove an object from a 3 40
ejb on wildfly 5 30
Problem to Alipay 10 47
American Express @Work site and Java 4 32
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question