import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class studentdb1 extends HttpServlet
{
	public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
	{
	   PrintWriter out=res.getWriter();

	   String srno=req.getParameter("srno");  //rno from student.html file

	   if(srno!=null)
	   {
	     int rollno=Integer.parseInt(srno);
	     try
	     {
		Class.forName("org.postgresql.Driver");
		Connection con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/stud","postgres","");

		PreparedStatement ps=con.prepareStatement("select * from student where srno=?");

		ps.setInt(1,rollno);

	 	ResultSet rs=ps.executeQuery();

		if(rs.next())
		out.println("Student name is "+rs.getString(2)+"Per = "+rs.getFloat(3));
		else
		out.println("Records not found");
	     }

	     catch(Exception e)
	     {
		out.println(e);
	     }

	   }

	}

}