File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Integer auto_increment Primary key not showing up Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Integer auto_increment Primary key not showing up" Watch "Integer auto_increment Primary key not showing up" New topic
Author

Integer auto_increment Primary key not showing up

Kyupa Supa
Ranch Hand

Joined: Jun 23, 2012
Posts: 30
......................


It doesn't search by ID

is is StudentsManager.java:



The list -students is keeping the students from DB (it works, I used it in other place too)


...............................
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12675
    
    5
What exactly are you expecting to happen?

Why have you made no provision for null values for the "year" and "id" parameters?

Bill

Java Resources at www.wbrogden.com
Kyupa Supa
Ranch Hand

Joined: Jun 23, 2012
Posts: 30
William Brogden wrote:What exactly are you expecting to happen?

Why have you made no provision for null values for the "year" and "id" parameters?

Bill


I wanted to display all students with the same id, but I realized I should not make it auto increment, because I need some of the IDs to be common, for linking the table with another. I wanted to search a student by "ID", "name" or "year". I testes with JavaScript in the previous page that user entered one of the 3 elements. But I'll leave the ID aside now, so that user searches only by "year" or "name".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Integer auto_increment Primary key not showing up
 
Similar Threads
JSP with Jdbc
Login Code Error
Cannot connect to mysql through netbeans
servlet is not working properly
Retrive a single data from database and display that in jsp text box.