Sir,
I want to fetch data from a table in sql server database on a jsp page...i make text to be searched input from user through an html page and on jsp page i am getting that data by getParameter() method and passing that variable in sql like query whose syntax is "select * from tablename where columnname like 'f%'" where f is the text received by getparameter(). .
my code is:
//search.html
<body>
<form action="" searchbox.jsp" method="post">
<input type="text" name="searchite m" value=" " size="30" maxlength="30">
<input type="submit" name="search" value="search">
</form>
</body>
//searchbox.jsp
<%@ page import = "java.util. *;" %>
<%@ page import=" java.sql.*;" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
<%! Connection con;
PreparedStateme nt pstmt;
Statement stmt;
ResultSet rs;
%>
</head>
<body>
<% String str;
str=request.get Parameter("sear chitem");
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
con=DriverManag er.getConnectio n("Jdbc:Odbc:ds _name");
Statement st=con.createSt atement();
String st1="'";
String st2="%";
String str2=st1.concat (str);
String str3=str2.conca t(st2);
String str4=str3.conca t(st1);
rs=st.executeQu ery("select * from items where itemname like '" +str4+ "'");
int count=0;
if(rs.next())
{
String s=rs.getString( 1);
count++;
out.println(s);
if(count>0)
{
out.println("su ccess");
}
else
{
out.println("fa il");
}
}
}
catch(Exception ex)
{
}
%>
</body>
</html>
I want to fetch data from a table in sql server database on a jsp page...i make text to be searched input from user through an html page and on jsp page i am getting that data by getParameter() method and passing that variable in sql like query whose syntax is "select * from tablename where columnname like 'f%'" where f is the text received by getparameter(). .
my code is:
//search.html
<body>
<form action="" searchbox.jsp" method="post">
<input type="text" name="searchite m" value=" " size="30" maxlength="30">
<input type="submit" name="search" value="search">
</form>
</body>
//searchbox.jsp
<%@ page import = "java.util. *;" %>
<%@ page import=" java.sql.*;" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
<%! Connection con;
PreparedStateme nt pstmt;
Statement stmt;
ResultSet rs;
%>
</head>
<body>
<% String str;
str=request.get Parameter("sear chitem");
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
con=DriverManag er.getConnectio n("Jdbc:Odbc:ds _name");
Statement st=con.createSt atement();
String st1="'";
String st2="%";
String str2=st1.concat (str);
String str3=str2.conca t(st2);
String str4=str3.conca t(st1);
rs=st.executeQu ery("select * from items where itemname like '" +str4+ "'");
int count=0;
if(rs.next())
{
String s=rs.getString( 1);
count++;
out.println(s);
if(count>0)
{
out.println("su ccess");
}
else
{
out.println("fa il");
}
}
}
catch(Exception ex)
{
}
%>
</body>
</html>