Reply me
View Answers
August 12, 2008 at 3:55 PM
hai frnd.........
again u didnt give me complete details....such as table name....
the datatypes of each column....
the name of the text box in the previous page where the user typed the name to be searched......
here is my code for u....
make necessary changes.....
this is the second page where the result will be displayed.....
I'm considering the text box where the user types the name to be searched as "name"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">;
<%@page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c"%>
<html>
<head>
<title>SEARCH</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<meta name="GENERATOR" content="Rational Application Developer">
</head>
<body>
<form>
<%@ page import="java.sql.*" %>
<%! Connection con;
ResultSet rst;
Statement st;
String url="jdbc:db2://url/database:"; //WRITE THE URL TO THE DATABASE
%>
<%
try
{
Class.forName("com.ibm.db2.jcc.DB2Driver");//THIS IS IBM DB@TYPE 4 DRIVER
con=DriverManager.getConnection(url,"username","password");//WRITE THE USER NAME AND PASSWORD
System.out.println("After Establishing connection");
}
catch(ClassNotFoundException e)
{
System.out.println("ERROR!1: "+e);
}
%>
<table width="100%" border="1">
<tbody>
<tr>
<td height="267" valign="top" colspan="3"><b><br>
<br>
<br>
<center>
<table border="1" width="358">
<tbody>
<tr>
<td width="100">vend_id.</td>
<td width="124">vend_name</td>
<td width="127">vend_address</td>
<td width="127">vend_panno</td>
<td width="127">vend_phone</td>
<td width="127">vend_creditday</td>
<td width="127">vend_tinno</td>
</tr>
<%
try
{
st=con.createStatement();
System.out.println("Before Select");
rst=st.executeQuery("select * from tablename where vend_name='"+request.getParameter("name")+"' order by 2");//CHANGE THE TABLENAME TO YOUR TABLE"S NAME.
System.out.println("After select");
while(rst.next())
{
System.out.println("inside while");
%>
<tr>
<td width="100"><%=rst.getInt(1) %></td>
<td width="124"><%=rst.getString(2) %></td>
<td width="127"><%=rst.getString(3) %></td>
<td width="127"><%=rst.getInt(4) %></td>
<td width="127"><%=rst.getInt(5) %></td>
<td width="127"><%=rst.getString(6) %></td>
<td width="127"><%=rst.getInt(5) %></td>
</tr>
<%
}
System.out.println("After reading values");
}
catch(Exception e)
{
System.out.println("ERROR!!2 :"+e);
}
%>
</tbody>
</table>
</center>
</td>
</tr>
</tbody>
</table>
</form>
</body>
</html>
here i'm considering vend_id,vend_mobile ,vend_panno,vend_phone and vend_tanno as integer type and all others as string type.....
here i'm ordering the result by alphabetic order of the name....the second column.......
i think this would work for u........
thanks and regards
prashu
[email protected]
again u didnt give me complete details....such as table name....
the datatypes of each column....
the name of the text box in the previous page where the user typed the name to be searched......
here is my code for u....
make necessary changes.....
this is the second page where the result will be displayed.....
I'm considering the text box where the user types the name to be searched as "name"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">;
<%@page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c"%>
<html>
<head>
<title>SEARCH</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<meta name="GENERATOR" content="Rational Application Developer">
</head>
<body>
<form>
<%@ page import="java.sql.*" %>
<%! Connection con;
ResultSet rst;
Statement st;
String url="jdbc:db2://url/database:"; //WRITE THE URL TO THE DATABASE
%>
<%
try
{
Class.forName("com.ibm.db2.jcc.DB2Driver");//THIS IS IBM DB@TYPE 4 DRIVER
con=DriverManager.getConnection(url,"username","password");//WRITE THE USER NAME AND PASSWORD
System.out.println("After Establishing connection");
}
catch(ClassNotFoundException e)
{
System.out.println("ERROR!1: "+e);
}
%>
<table width="100%" border="1">
<tbody>
<tr>
<td height="267" valign="top" colspan="3"><b><br>
<br>
<br>
<center>
<table border="1" width="358">
<tbody>
<tr>
<td width="100">vend_id.</td>
<td width="124">vend_name</td>
<td width="127">vend_address</td>
<td width="127">vend_panno</td>
<td width="127">vend_phone</td>
<td width="127">vend_creditday</td>
<td width="127">vend_tinno</td>
</tr>
<%
try
{
st=con.createStatement();
System.out.println("Before Select");
rst=st.executeQuery("select * from tablename where vend_name='"+request.getParameter("name")+"' order by 2");//CHANGE THE TABLENAME TO YOUR TABLE"S NAME.
System.out.println("After select");
while(rst.next())
{
System.out.println("inside while");
%>
<tr>
<td width="100"><%=rst.getInt(1) %></td>
<td width="124"><%=rst.getString(2) %></td>
<td width="127"><%=rst.getString(3) %></td>
<td width="127"><%=rst.getInt(4) %></td>
<td width="127"><%=rst.getInt(5) %></td>
<td width="127"><%=rst.getString(6) %></td>
<td width="127"><%=rst.getInt(5) %></td>
</tr>
<%
}
System.out.println("After reading values");
}
catch(Exception e)
{
System.out.println("ERROR!!2 :"+e);
}
%>
</tbody>
</table>
</center>
</td>
</tr>
</tbody>
</table>
</form>
</body>
</html>
here i'm considering vend_id,vend_mobile ,vend_panno,vend_phone and vend_tanno as integer type and all others as string type.....
here i'm ordering the result by alphabetic order of the name....the second column.......
i think this would work for u........
thanks and regards
prashu
[email protected]
Related Tutorials/Questions & Answers:
Reply me - Java Beginners
Reply me Hi Friends, Quest:- Tell em what is the difference between java and php, dotnet Quest:- what is the similar point of php and java... Please tell me its very urgent
Reply me Hi Friends, Quest:- Tell em what is the difference between java and php, dotnet Quest:- what is the similar point of php and java... Please tell me its very urgent
Advertisements
Reply me soon.........
Reply me soon......... Any body plzz help.....how to get d checked details from previous page to current page and den insert into table
Reply me soon......... Any body plzz help.....how to get d checked details from previous page to current page and den insert into table
Reply Me - Java Beginners
=13c222b87273340cf002bfba4ab9d045. please reply me fast its urgent...Reply Me Hi All, I want to using query string in my page please write the query string in java script and send me and I have a some link
=13c222b87273340cf002bfba4ab9d045. please reply me fast its urgent...Reply Me Hi All, I want to using query string in my page please write the query string in java script and send me and I have a some link
Reply me - Java Beginners
Reply me If u r not understood my just posted question plz let me know Hi Ragini, Please specify your requirements in detail. It would be good for me to provide you the solution if problem is clear. And also
Reply me If u r not understood my just posted question plz let me know Hi Ragini, Please specify your requirements in detail. It would be good for me to provide you the solution if problem is clear. And also
Reply Me - Java Beginners
question then reply me...Reply Me Hi,.. I have a some fields in one form like security and some more fields this fields maintain the table if user click security
question then reply me...Reply Me Hi,.. I have a some fields in one form like security and some more fields this fields maintain the table if user click security
Reply Me - Struts
Reply Me Hi Friends, I am new in struts please help me How to arrange the folder using oracle 10g database where store web.xml file,jsp file,connection file....etc please let me know its very urgent
Reply Me Hi Friends, I am new in struts please help me How to arrange the folder using oracle 10g database where store web.xml file,jsp file,connection file....etc please let me know its very urgent
Reply me - Java Beginners
Reply me Hi, There are one form product_master these fields are prod_id,prod_name,prod_opstock,prod_excise,prod_vat,reorder_level,reorder_qty... in the place of vend_name Please write this code and send me its very urgent
Reply me Hi, There are one form product_master these fields are prod_id,prod_name,prod_opstock,prod_excise,prod_vat,reorder_level,reorder_qty... in the place of vend_name Please write this code and send me its very urgent
Reply me - Java Beginners
Reply me Hi, I am using this code for session but i am... then adll data would be displaying. so please tell me what is incorrect my code and i want to use session in each page then please tell me that how can i
Reply me Hi, I am using this code for session but i am... then adll data would be displaying. so please tell me what is incorrect my code and i want to use session in each page then please tell me that how can i
Reply Me - Java Beginners
Reply Me Hi Amardeep I am sending database table name,code and db file please insert this data in this table its very urgent.... My... "code too large for try statement" please help me its very urgent
Reply Me Hi Amardeep I am sending database table name,code and db file please insert this data in this table its very urgent.... My... "code too large for try statement" please help me its very urgent
Reply Me - Java Beginners
Reply Me Hi, Please Help Me using jsp technologies I have a form click the link and open the popup window main page have already a html... understood my problem then please send me..... Hi friend, Please
Reply Me Hi, Please Help Me using jsp technologies I have a form click the link and open the popup window main page have already a html... understood my problem then please send me..... Hi friend, Please
Reply Me - Java Beginners
Reply Me Hi deepak, your sending web application is good (alphabetical searching dropdown menu) Steps:- 1:-searching is good... will be not displayed. please help me how it is open selection of the user its very urgent
Reply Me Hi deepak, your sending web application is good (alphabetical searching dropdown menu) Steps:- 1:-searching is good... will be not displayed. please help me how it is open selection of the user its very urgent
Reply me - Java Beginners
Reply me HI I m sending structure of table vend_id,vend_name,vend_address,vend_mobile,vend_panno,vend_phone,vend_creditday,vend_tinno... frnd......... again u didnt give me complete details....such as table name
Reply me HI I m sending structure of table vend_id,vend_name,vend_address,vend_mobile,vend_panno,vend_phone,vend_creditday,vend_tinno... frnd......... again u didnt give me complete details....such as table name
Reply me - Java Beginners
Reply me Hi, Hi Ragini please specify main problem. where are problem in your code. Thanks
Reply me Hi, Hi Ragini please specify main problem. where are problem in your code. Thanks
Reply me - Java Beginners
Reply me Hi, this code is .java file but i am working in jsp... in the database... if u understood my question then then please send me code oterwise tell me its urgent package services; import java.sql.Connection; import
Reply me Hi, this code is .java file but i am working in jsp... in the database... if u understood my question then then please send me code oterwise tell me its urgent package services; import java.sql.Connection; import
Reply Me - Java Beginners
Reply Me Hi I am sending some code please check it and solve this code is only insert into the data base please insert data in the database table and reply me fast...I got two error 1 is catch is without try 2 is try
Reply Me Hi I am sending some code please check it and solve this code is only insert into the data base please insert data in the database table and reply me fast...I got two error 1 is catch is without try 2 is try
Reply Me - Java Beginners
Reply Me Hi, I m working in jsp please any information provide the jsp code.not servlet or any other. I m writing a problem clearly...,if u not understood then please tell me Thanks
Reply Me Hi, I m working in jsp please any information provide the jsp code.not servlet or any other. I m writing a problem clearly...,if u not understood then please tell me Thanks
Reply Me - Java Beginners
Reply Me Hi, For table I have a two table first is sales transaction and second is sales_line sales_transaction fields are comp_id,vend.... * JSP * Servlets * Struts 1 * Struts 2 or JSF? Please tell me
Reply Me Hi, For table I have a two table first is sales transaction and second is sales_line sales_transaction fields are comp_id,vend.... * JSP * Servlets * Struts 1 * Struts 2 or JSF? Please tell me
Reply Me - Java Beginners
Reply Me Hi Rajnikant, I know MVC Architecture but how can use this i don't know... please tell me what is the use of this ....and also solve my previous problem.... Thanks Hello Ragini MVC
Reply Me Hi Rajnikant, I know MVC Architecture but how can use this i don't know... please tell me what is the use of this ....and also solve my previous problem.... Thanks Hello Ragini MVC
Reply Me - Struts
Reply Me Hi Friends, Please write the code using form element...because i got error in textbox null value Hi Soniya Would you please explain, in which technology are you creating page? I promise
Reply Me Hi Friends, Please write the code using form element...because i got error in textbox null value Hi Soniya Would you please explain, in which technology are you creating page? I promise
reply me - Java Beginners
reply me Hi, user enter vend_id in text box ten open the addform.jsp In the addform.jsp have two button Update and delete addform.jsp is display with fetching data in all text box I m sending code before 5
reply me Hi, user enter vend_id in text box ten open the addform.jsp In the addform.jsp have two button Update and delete addform.jsp is display with fetching data in all text box I m sending code before 5
Reply Me - Java Beginners
Reply Me Hi, Details structure Using jsp code I m sending table structure and again sending our problem Steps:- 1:-If user input in name text box like a,then display record related to a not b and c(means
Reply Me Hi, Details structure Using jsp code I m sending table structure and again sending our problem Steps:- 1:-If user input in name text box like a,then display record related to a not b and c(means
hi see and give me reply as soon as possible
hi see and give me reply as soon as possible Hi Friend, I got path,but it will again ask path error first i was gave index.jsp.It... be send reply soon. Thanks & Regards, N.Ramesh
hi see and give me reply as soon as possible Hi Friend, I got path,but it will again ask path error first i was gave index.jsp.It... be send reply soon. Thanks & Regards, N.Ramesh
reply me its urgent - Java Beginners
reply me its urgent Hi friends I am facing problem in my application in this type please help me i am using database mysql5.0 version...'@'localhost' (using password: YES)" please tell me what is the error....its
reply me its urgent Hi friends I am facing problem in my application in this type please help me i am using database mysql5.0 version...'@'localhost' (using password: YES)" please tell me what is the error....its
Plz Plz reply Me - JSP-Servlet
Plz Plz reply Me Respected Sir/madam, I am R.Ragavendran.. Actually I got your coding.. But This code is not enabling the user to click and change the image.. I request you to remember the code which you have provided for me
Plz Plz reply Me Respected Sir/madam, I am R.Ragavendran.. Actually I got your coding.. But This code is not enabling the user to click and change the image.. I request you to remember the code which you have provided for me
GUI Interface .Reply me with in hour..Its Urgent - Java Beginners
GUI Interface .Reply me with in hour..Its Urgent Hi ... Now i am doing project for Voting finger print Authentication .. Can any pls assit me.. I... Existing project... Help me
GUI Interface .Reply me with in hour..Its Urgent Hi ... Now i am doing project for Voting finger print Authentication .. Can any pls assit me.. I... Existing project... Help me
Plz reply me sir Its urgent - JSP-Servlet
Plz reply me sir Its urgent Respected Sir/madam, I am R.Ragavendran..Actuaaly,I request you to remember the code which you have provided for me using radio buttons.. You have used the following syntax for checking whether
Plz reply me sir Its urgent Respected Sir/madam, I am R.Ragavendran..Actuaaly,I request you to remember the code which you have provided for me using radio buttons.. You have used the following syntax for checking whether
how to pass string array from action class to jsp page? pls reply me.
how to pass string array from action class to jsp page? pls reply me. how to pass string array from action class to jsp page? pls reply me. You can use session.setAttribute() and session.getAttribute() methods
how to pass string array from action class to jsp page? pls reply me. how to pass string array from action class to jsp page? pls reply me. You can use session.setAttribute() and session.getAttribute() methods
reply must
reply must is it critical to do a software job based on games(java) i know core java & advanced java basics only please give me answer
reply must is it critical to do a software job based on games(java) i know core java & advanced java basics only please give me answer
reply to the mail
reply to the mail Hi! which jar file needed to be added? Thanks Question not clearADS_TO_REPLACE_1
reply to the mail Hi! which jar file needed to be added? Thanks Question not clearADS_TO_REPLACE_1
reply - Java Beginners
reply Hi friends I have a 255 fields i want to insert data in the table please let me know how to insert data in the database please reply me its very urgent
reply Hi friends I have a 255 fields i want to insert data in the table please let me know how to insert data in the database please reply me its very urgent
Reply - Struts
Reply Thanks For Nice responce Technologies::--JSP please write the code and send me....when click "add new button" then get the null value...its urgent... Hi can u explain in details about your project
Reply Thanks For Nice responce Technologies::--JSP please write the code and send me....when click "add new button" then get the null value...its urgent... Hi can u explain in details about your project
Reply - Struts
Reply I am sending some coding please chk and let me know if(act==3) { W=0; while(W< (txtcnt4-1)) { out.println("1st Details... debug... if you understtod my problem then write the code and send me...its very
Reply I am sending some coding please chk and let me know if(act==3) { W=0; while(W< (txtcnt4-1)) { out.println("1st Details... debug... if you understtod my problem then write the code and send me...its very
Reply - Struts
Reply Hello Friends, please write the code in struts and send me I want to display "Welcome to Struts" please send me code its very urgent... and which file need to be run and compile struts without using database
Reply Hello Friends, please write the code in struts and send me I want to display "Welcome to Struts" please send me code its very urgent... and which file need to be run and compile struts without using database
ModuleNotFoundError: No module named 'reply'
ModuleNotFoundError: No module named 'reply' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'reply' How to remove the ModuleNotFoundError: No module named 'reply'
ModuleNotFoundError: No module named 'reply' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'reply' How to remove the ModuleNotFoundError: No module named 'reply'
Reply - JSP-Servlet
... Thanks for your fast reply.. Thanks/Regards, R.Ragavendran.. ... the phone and mobile number validation..... and it worked fine for me
... Thanks for your fast reply.. Thanks/Regards, R.Ragavendran.. ... the phone and mobile number validation..... and it worked fine for me
Reply - Java Beginners
Reply Hi amardeep Thanks for reply i know my code is very large....i am sending database table file please chk sequence and let me know USERCODE NUMBER(10) POSTDATE DATE FORMID VARCHAR2(20) LOCATIONID VARCHAR2(20
Reply Hi amardeep Thanks for reply i know my code is very large....i am sending database table file please chk sequence and let me know USERCODE NUMBER(10) POSTDATE DATE FORMID VARCHAR2(20) LOCATIONID VARCHAR2(20
PLease reply its urgent
PLease reply its urgent Write a java function that has the signature ΓΆβ?¬Ε?Public static int clock Inter sections(int hours, int minutes)ΓΆβ?¬Β? That takes a number of hours and minutes (up to several days), and returns
PLease reply its urgent Write a java function that has the signature ΓΆβ?¬Ε?Public static int clock Inter sections(int hours, int minutes)ΓΆβ?¬Β? That takes a number of hours and minutes (up to several days), and returns
reply - Java Beginners
reply Hi Friends, action *.do please tell me... tell me what is main role of *.do please tell me its urgent..... HI ragini, Please tell me, what you want to do? if you are using simple
reply Hi Friends, action *.do please tell me... tell me what is main role of *.do please tell me its urgent..... HI ragini, Please tell me, what you want to do? if you are using simple
hi plzz reply
hi plzz reply in our program of Java where we r using the concept of abstraction Plz reply i m trying to learn java ... means in language of coding we r not using abstraction this will be used only for making ideas
hi plzz reply in our program of Java where we r using the concept of abstraction Plz reply i m trying to learn java ... means in language of coding we r not using abstraction this will be used only for making ideas
Reply - Java Beginners
Reply Hi Friends, Thanking for ur continue response I know your giving idea but can u send me the code of this problem just example for 20 data
Reply Hi Friends, Thanking for ur continue response I know your giving idea but can u send me the code of this problem just example for 20 data
Reply - Java Beginners
Reply Hi friend I want to use eclipse in my system then send me url of this I have a jdk1.4, tomcat 4.1 so please tell me which version is support give detail how to install
Reply Hi friend I want to use eclipse in my system then send me url of this I have a jdk1.4, tomcat 4.1 so please tell me which version is support give detail how to install
rEPLY - Java Beginners
rEPLY hi, This is session code i am calling admin_home1.jsp then data will be not displaying its urgent requirement please send me correction Thanks Hi friend, To display the session
rEPLY hi, This is session code i am calling admin_home1.jsp then data will be not displaying its urgent requirement please send me correction Thanks Hi friend, To display the session
fast Reply - Java Beginners
fast Reply Hi Friend I want to passing value one page to another page without using session varible....please help me write the code and send me Hi friend, For solving the problem visit to : http
fast Reply Hi Friend I want to passing value one page to another page without using session varible....please help me write the code and send me Hi friend, For solving the problem visit to : http
Version of com.klinkerapps>wearable-reply dependency
List of Version of com.klinkerapps>wearable-reply dependency
List of Version of com.klinkerapps>wearable-reply dependency
reply urgently - Java Beginners
Using abstract class and Interface when to use abstract class and when to use interface? give me answer with real time scenario? Hello,When to Use InterfacesTwo Important Differences Between Interfaces and Abstract
Using abstract class and Interface when to use abstract class and when to use interface? give me answer with real time scenario? Hello,When to Use InterfacesTwo Important Differences Between Interfaces and Abstract
Reply - JSP-Servlet
Reply Dear prashu sir, Actually i dont know where to start the image selection process.. I am really struggling to get through it.. If you get the codings please send it to me at that moment itself.. Because i am
Reply Dear prashu sir, Actually i dont know where to start the image selection process.. I am really struggling to get through it.. If you get the codings please send it to me at that moment itself.. Because i am
reply - Java Beginners
reply Hi, I am chk insert query please chk and let me know what is incorrect here i am using insert query please chk this StrSqlColm="Insert into FAFORM24GJMASTER("; StrSqlColm="USERCODE,POSTDATE
reply Hi, I am chk insert query please chk and let me know what is incorrect here i am using insert query please chk this StrSqlColm="Insert into FAFORM24GJMASTER("; StrSqlColm="USERCODE,POSTDATE
Ads