Netbeans IDE ...

[Amahdy]

Hey all;
I have many problems with this new IDE (for me) and I'm loking for your help to know how to solve them :

1- How to edit, a protected code-part (clored with light blue-green in the IDE) ?? I have an error in it and I haven't any tools to edit , delete or comment it , I also have tried to open the source file, remove its readonly propriete and try to edit it without any changes , what should I do in this case ?

2- How to fill java DB tables ?? I have created them, connected to them , made all thing but still can't just only fill them .. should I do that programaticaly ? I just want to activate those items (like textbox, listcombobox , ..etc) in my jform to be active with the database .

3- I have followed an article on how to creat an ODBC connection by jumbing from JDBC to ODBC , the code seems correct and I made all I thing : created a new connection control, opened the db url all thing but after writing it the IDE underlined too many statments with red , I pressed ctrl+enter then it inform me to put the sql exeption but here I got a problem in the protected code and I can't solve it as said before .

4- If any one have a sample to show me how to accomplish this , I don't matter java DB, mdb or anything; I just want to make a correct connection with a simple table and as explained before I want like making a button that when pressed display in each textbox the corresponding field value, and other that delete and all simple db tasks , also I need to put in a combolistbox all the pointed field values ... shall I execute sql for all controls or may I have a faster method to do this links ?

5- Thanks very much for any help here .

[Amahdy]

Please any help in any topic of those above will be greatly appreciated :-?
I need to solve any of them and where to have articles about this .. Thanks.

[nspils]

Re: editing matisse GUI code (light blue in the IDE) - yes, of sorts - see here:
http://wiki.netbeans.org/wiki/view/F...gGuardedBlocks

Re: database connectivity, see:
http://wiki.netbeans.org/wiki/view/N...seConnectivity
and
http://www.netbeans.org/kb/50/using-...ns/dbconn.html

For info on the GUI interface to database interaction - in the Visual Web Pack, see:
http://www.netbeans.org/kb/55/vwp-da...omponents.html

[Amahdy]

Thanks very much nsplis, u r perfect in giving me the best articles
And here is the solutions for my problems for anybody else :
1- as nspils posted read the few lines here ; http://wiki.netbeans.org/wiki/view/...ngGuardedBlocks

2- I must fill it programatically, like executing sql : "Insert Into ... "

3- I made a big mistake that I ignored the try{} and ctach{} or finally{} , here it's not like c++ , if u r sure that there wont be any errors , it's heighly strongly recommended to put them . before that the IDE tell me an error that need to put the sql exeption and after putting it , it gives me an error in the matisse GUI code, and a big unwanted story .

4- well the simplest method to make the mentioned bridge for connecting from JDBC to ODBC is :

String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + DBFilePath + ";DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection( database ,"",""); 
//ONLY !! really very easy !! now u have the connection in the object "con"

5- Thank u very much again nspils .

Sciencerly.

[nspils]

You're welcome, Amahdy. Glad to see I helped guide you to a place where you learned some stuff!