hi..
i'm new to jsp,mysql and dreamweaver.i really need help.can anyone give me code on how to insert data into mysql.using dreamweaver mx n jsp.this for my final project.i'm making website.please help.thank you

currently i used jdbc:odbc:myodbc for driver.
please help me.

I use the driver:

mm.mysql-2.0.8-bin.jar

Think the apache tomcat site has links to download this file.

Theres sample code in the tomcat documentation for connecting to databases with jdbc:

http://jakarta.apache.org/tomcat/tom...les-howto.html

As for using dreamweaver, youll still have to hand code the java/jsp, Im pretty sure there is no database integration for JSP in the way there is for cold fusion.

Ellios -

Perhaps the database integration for JSP isn't quite so good in Dreamweaver as it is for ColdFusion, but it is quite good. I'm using Dreamewaver MX 2004 with MySQL on WinXP w/JRun4 and it works like a bomb. You need the most recent MyODBC driver, and then it just runs. Couldn't be faster/easier.

Let me know if you're still having trouble with this.

--tgr

Thaddeus G. Reeves
Internet Dissemination
Church of Scientology Int'l

Ive only got MX, think this was from around 2000, perhaps the integration is better now, or maybe I havent tried hard enough

Most SQL is in Java Beans anyway, so would not be that much help to me.

Would like to get my hands on 2004, if for no other reason than is supports SFTP, at the moment I have to use an FTP SFTP bridge to connect to my server.

Integration is definitely better - I don't think it's you. I find it great as a coding environment though. Being previously an ASP person, it does well at masking my inexperience in JSP.

--tgr