Comments

 
User Comments for the tutorial:

Insert data in mysql database through jsp using prepared statement



Advertisement

Comments

please help me with this
I got error when trying out this codes; its said An error occurred at line: 75 in the jsp file: /prepared_statement_query.jsp String literal is not properly closed by a double-quote 72: (connectionURL, "root", "root"); 73: 74:  

entering data in mysql
it is perfect. tell me how to enter data using html 

i run this code it got stuck in exception
this code got stuck in the execption --> unable to connect. i changed the password also.. 

Question
Sir, can u tell me how to store a radiobutton result in Access Database using JSP. Please help me. Thanking you M.Anil.  

No database insertion
I ran a try and catch to make sure that I was connected to the database and it worked. However, when I run this jsp file to insert into the database, it does NOT work. Everything was step by step; especially my password into the database. Got any  

Solution
place line 75 and 76 on the same line . its getting mixed up thinks they are two seperate lines 

getting error
i m getting error unable to connect to database  

Simple debug
You need to put line 76 on line 75. The string cannot be on two different lines. I did not find any other problems with this code, but I modified it right off the bat. 

insert into mysql
how to insert date??? 

Question
How to convert with float without String ? 

How or where could I see the sourse Database?
How or where i could see the source of the database we create if we run the codes above,,?>?? 

how to insert the value from jsp to database
more useful,detailed explanation,thanks a lot 

Code is not working.........
The program wrritten above is containg errors. It throwing NullPointerException........ 

Related Tutorial and Articles
JDBC Questions

prepared statement in for loop - JDBC
prepared statement in for loop  Hi all, I am reding data from a jsp page and inserting into a table. For this i am using prepared statement...(); System.out.println("rows updated:"+no.toString()); } Please help me out 

Java Beginners

prepared statement
prepared statement  plese give me a code that have preparedstatement interface and uses a select query having condition date="s"; where s is the date, but this date parameter passed as the string 

Hibernate Questions

HQL Statement: Please help me
HQL Statement: Please help me  Select ProductFamily.* from... = Product.productGroupVersionId and Product.lobId = ? Can you please help me equallent HQL statement 

JDBC Questions

checking index in prepared statement
= con.prepareStatement(query); then after query has been prepared, can we check the index... links: http://www.roseindia.net/jdbc/prepared-statement-insert.shtml http...checking index in prepared statement  If we write as follows: String 

SQL Question

Please help me understand this query
Please help me understand this query  Hi, Could someone please help me understand the following query. Im finding difficulty relating it :-( Pls Help! select * from cbpartner where CBPartner.IsSummary='N' and salesrep_id 

JSP Servlet Questions

please help me.
please help me.  Please send me the validation of this below link. the link is http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html Thanks Trinath 

JSP Servlet Questions

please help me.
please help me.  How to move the edits.jsp in below link? http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html 

JSP Servlet Questions

please help me.
please help me.  I have a jsp page under that i add a list box under i get the countries through my database. so how can i do 

JSP Servlet Questions

Please help me.
Please help me.  Hi i am trinath in below there is a url.In that url there is a code of edit a jsp page.I understand that code but only one thing i...://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search 

JSP Interview Questions

please help me
please help me  Dear sir, I have a problem. How to write JSP coding... before. This name list should get from the database. Please help me. By the way, I'm using access database and jsp code. Thank you