Hi Guys, I'm kinda new to JDBC ...i haven't been able to resolve this problem ..ie.. Consider a html page that takes an employee name ...which through form method =get action= \servletJdbcVlidation post the parameter to the servlet. There in the servlet i have the code like follows... package authenticate; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.sql.*; import ...
Hello all, If there are 100 records in the table then what would the query be? Table1 ====== Empname ------- Alan Joy Samantha Nicole Manish Asit .... ... All the empname's has to be displayed in a single line using a select query so that no iteration ie resultset.next() is used in the code. Rgds, Seetesh
Hello Ranchers.. I'm using JSP and Oracle for the project.. now in one of the table there are 1000 records.. when a user click the search button.. All the records are displaying in the page.. for that displaying purpose i used .. in this iframes i put the frameborder="0" and scrolling="auto".. So if the record is more that 10 it ...
Hello, I am trying: 1) to print the cv_id that not exists in the database 2) to delete the cv_id records if exists in db No. (2) is working but (1) not working String query="select cv_id from cv where cv_id=?"; PreparedStatement ps=cnn.prepareStatement(query); for(i=0;i
Hello, I am storing articles in oracleXE db as clob. I want that after 10 lines or 250 words I may be able to show some pictures and videos related to this article. I tried a lot by using the split() method by splitting the 250 words but result set shows all data and at the end pictures/videos appears. Any suggestions ...
Hello, There are many dept record in my db and each dept may have one or more than one record. I am trying to fetch one dept and then to get this dept records that may be one or many. Please check this link that shows the wrong output whereas the expected output is at this Link Here is my all ...