Updating table with integer values using jdbc in servlets
Hi everone, Currently i am working on an Pharmacy management project in MVC2 model i have written an servlet code to fetch,insert,update,delete My SQL table contents from the JSP page but my problem is i could insert the data successfully but i am failing at Update and delete here is my code someone kindly help me to resolve this problem /* * To change this template, choose Tools | Templates * and open the template in the editor.
Http Servlet Response; /** * * @author Dinesh */ public class pharmacy extends Http Servlet I would also suggest adding some "close();" statements here and there. does that method in your servlet actually call what you think it does, and does it passes the if statements you think it does?
It should be noted that tables you are working on should have Primary Key set properly.
You will need the following software to build the project: Derby is an open-source pure-Java Database Management System.Even if you already know how to write Java programs, and have a basic understanding of web applications, the Java 2 Enterprise Edition (J2EE) stack is daunting.Learning to use the Servlet API and Java Server Page technology to generate dynamic content is just the beginning.Copy and past the following example in JDBCExample.java, compile and run as follows − java JDBCExample Connecting to database... ID: 100, Age: 38, First: Zara, Last: Ali ID: 101, Age: 45, First: Mahnaz, Last: Fatma ID: 102, Age: 55, First: Zaid, Last: Khan ID: 103, Age: 50, First: Sumit, Last: Mittal Inserting a new record... ID: 100, Age: 38, First: Zara, Last: Ali ID: 101, Age: 45, First: Mahnaz, Last: Fatma ID: 102, Age: 55, First: Zaid, Last: Khan ID: 103, Age: 50, First: Sumit, Last: Mittal ID: 104, Age: 40, First: John, Last: Paul List the record before deleting...ID: 101, Age: 45, First: Mahnaz, Last: Fatma List result set after deleting one records...