Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@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
- }
- %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement