Untitled

<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.SQLException"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<html>
    <head>
        <title>Sample jsp</title>
    </head>
    <body>
        <%
            try {
                Class.forName("oracle.jdbc.OracleDriver");
                Connection conn = DriverManager.getConnection("jdbc:oracle:thin@localhost:1521:orcl", "system", "mono");
                PreparedStatement ps = conn.prepareStatement("SELECT * FROM person");
                // ps.setInt(1, qid);
                ResultSet rs = ps.executeQuery();

                System.out.println("IDtNametPhone");
                while (rs.next()) {
                    //int id = rs.getInt(1);
                    String name = rs.getString(2);
                    String phone = rs.getString(3);
        %><%=   name%><%
                                }
                            } catch (Exception e) {
                                e.printStackTrace();
                            }
        %>
    </body>
</html>

<%
        try
        {
            System.out.println("IDtNametPhone"); //Print in background
            out.print("<P>IDtNametPhone"); //Print to actual page
            while (rs.next())
            {
                //int id = rs.getInt(1);
                String name = rs.getString(2);
                String phone = rs.getString(3);
                out.print(name); //Print without closing/opening scriptlet
            }
         }
         catch (Exception e)
         {
            //Might not want to show the user the exact error in production though.
            out.print("Error: " + e.getMessage()); //print error to page
            e.printStackTrace(); //print error to log
         }
    %>