Guest User

Untitled

a guest
Aug 8th, 2018
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
  2. pageEncoding="ISO-8859-1"%>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  4. <html>
  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  7. <title>Insert title here</title>
  8. </head>
  9. <body>
  10. <%@page import="java.sql.*" %>
  11. <%
  12. try
  13. {
  14. Class.forName("oracle.jdbc.driver.OracleDriver");
  15. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system", "system");
  16. PreparedStatement ps=con.prepareStatement("select * from studinfo");
  17. ResultSet rs=ps.executeQuery();
  18. while(rs.next())
  19. out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
  20. con.close();
  21. }
  22. catch(Exception e)
  23. {
  24. e.printStackTrace();
  25. }
  26. %>
  27.  
  28. </body>
  29. </html>
Add Comment
Please, Sign In to add comment