This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
public static final String INSERT_QUERY = "insert into USER_SUMMARY(user_id,login_time,login_date,LOGIN_STATUS) values(?,?,?,?)"; public static final String SELECT_QUERY = "select * from user_summary";
public static final String FIND_USER= "select user_id from user_summary where login_status = 'Y'";
public static final String DELETE_USER_STATUS = "DELETE user_summary.* FROM user_summary where user_id=?";
The above code runs fine. But, the problem is that the data in the table is not getting deleted. Are there settings we need to make in order to delete/update data in tables. Pls. look at my problem. Thanks in advance.