This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi am trying to compare two columns(serial_no) in two different tables Table1 and Table2, If there is a match I want to update 10 variables to table1 if no match then simply copy the serial_no to table1, I wrote a join for the first part now I don;t have any idea about how to copy if there is no match....Please can anyone look into my code and help me out....here is my code
You have SQL / Business logic and presentation code all in one servlet ? I would advise the following
1. Treat the servlet as a controller for the flow of code.
2. Create new service classes that will handle your business logic. Call them from the controller.
3. Move the data access logic to DAOs
4. Move the presentation logic to JSPs
I don;t have any idea about how to copy if there is no match