Home Tutorialhelp Allcomments Jsp Prepared Statement Query

 
 

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 

Advertisements Advertisements
 

 

 

DMCA.com