fady005
Posts: 115
|
Posted: 04/23/2007, 6:01 AM |
|
Hello,
I want to import usual java libraries to my project but how can I do it without modifying the main jsp source file ?
Thanks for your help...
_________________
Be inventive ! |
|
|
matheus
Posts: 386
|
Posted: 04/23/2007, 6:25 AM |
|
I cannot understand what you want.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 04/23/2007, 6:28 AM |
|
I want to add java.sql to the package list...
_________________
Be inventive ! |
|
|
matheus
Posts: 386
|
Posted: 04/23/2007, 6:31 AM |
|
the better thing, is use java.sql declaration all time you need, and didn't change imports in page.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 04/23/2007, 6:39 AM |
|
You mean if I want to call "Driver" I use "java.sql.Driver" ?
_________________
Be inventive ! |
|
|
matheus
Posts: 386
|
Posted: 04/23/2007, 6:57 AM |
|
Yes, is what I mean.
But, maybe you can use some classes of Codecharge to do database access.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 04/23/2007, 7:02 AM |
|
Quote matheus:But, maybe you can use some classes of Codecharge to do database access.
Can you give me some example ?
_________________
Be inventive ! |
|
|
matheus
Posts: 386
|
Posted: 04/23/2007, 7:11 AM |
|
If you need create a connection, use factory from JDBCConnection, if you need get a Connection getConnection from Command.
Have some others examples:
http://docs.codecharge.com/studio31/html/index.html?htt...s/Overview.html
And try look at DbTools class.
Have DLookup, executeUpdate....
maybe can help you.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 04/23/2007, 7:41 AM |
|
I tried with DbTools, it didn't work but I'm not sure of the syntax : DbTools.executeUpdate(sql,"Connection1");
My sql String is the same as before...
_________________
Be inventive ! |
|
|
matheus
Posts: 386
|
Posted: 04/23/2007, 1:08 PM |
|
What didn't work? Exception?
Have sure that sql is ok, and connection's name 'Connection1'?
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 04/24/2007, 12:46 AM |
|
No it did the same as with "connection.executeUpdate"... Stop responding... Because I added try and catch clauses but no changes...
I verified the sql and it worked... When the "edit" parameter is "New parameter" and the "old" parameter correspond to a cd mat nm of 9... the sql query will be :
UPDATE [m 4 nomenclature] SET [libellé identification]=New parameter WHERE [cd mat nm]=9
In all case the problem is not from the sql statement because when I deactivate it, it still stop responding so the problem is before this...
_________________
Be inventive ! |
|
|