how do i use sql like query in my jsp page

Hi Friend,

Try the following code:

<%@ page import="java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:student");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from data where name like 'a%'");
while(rs.next()){
out.println(rs.getString("name")+"<br>");
}
%>

The above code will display all the names from the database that starts with character 'a'.

Thanks

String sql = "select * from EXPERIENCE1 where EXPERIENCE1.RESUMEKEY="'"+RESUMEKEY+'" and EXPERIENCE1.EXPERIENCESEQ='"+EXPERIENCESEQ+'" ";