Passing Unknown Field in URL

hi,

so u have no problem in jsp side. Fine.

now receive the value from query string in servlet program,

on that program check the value with database and define th result based on your condition.

for example, in your table

no| Name

105| Java

106| JSP

aa.jsp?no=107

in your servlet,

String no = request.getParameter("no");

int number = Integer.parseInt(no);

PreparedStatement ps ;

ResulSet rs;

String query = "select * from tablename where no = ?";

ps = java.SQl.Connection.DriverManager.getConnection(" "," "," ");

ps.setInt(1,number);

rs = ps.executeQuery(query);

if(rs.first()) {

System.out.println(rs.getString("Name");

}

else {

System.out.println("Field Not Found ");

}

Bala

art84a at 2007-7-12 18:22:23 >