Guest User

Untitled

a guest
May 20th, 2020
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.78 KB | None | 0 0
  1.   public void performTask(HttpServletRequest request, HttpServletResponse response) throws IOException, ClassNotFoundException, SQLException {
  2.         response.setContentType("text/html; charset=Cp1251");
  3.         PrintWriter out = response.getWriter();
  4.         Class.forName("org.postgresql.Driver");
  5.         Connection connection = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/my_postgres_db", "postgres_user", "ytn88vfys");
  6.  
  7.         Statement st = connection.createStatement();
  8.         ResultSet rs = st.executeQuery("SELECT * FROM pacient");
  9.         int columns = rs.getMetaData().getColumnCount();
  10.  
  11.         while (rs.next()) {
  12.             for (int i = 1; i <= columns; i++) {
  13.                 out.print(rs.getString(i) + "\n");
  14.             }
  15.         }
  16.  
  17.     }
Advertisement
Add Comment
Please, Sign In to add comment