HarrJ

B5 Day 24 execute query

Sep 2nd, 2022
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.30 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. // for this, we are using tbl_products2
  4. public class Day24A {
  5.     public static void main(String[] args) {
  6.         getAllRows();
  7.     }
  8.    
  9.     public static void getAllRows() {
  10.         String address = "jdbc:mysql://localhost:3306/db_mr_b5";
  11.         String userName = "root";
  12.         String passWord = "";
  13.        
  14.         String sqlQuery = "SELECT * FROM tbl_products2";
  15.        
  16.         try {
  17.             Connection conn = DriverManager.getConnection(
  18.                     address,userName,passWord);
  19.             PreparedStatement stmt = conn.prepareStatement(sqlQuery);
  20.            
  21.             ResultSet rs = stmt.executeQuery();
  22.            
  23.             while (rs.next()) {                
  24.                 System.out.print(rs.getString(1)+" | ");
  25.                 System.out.print(rs.getString(2)+" | ");
  26.                 System.out.print(rs.getString(3)+" | ");
  27.                 System.out.print(rs.getString(4)+" | ");
  28.                 System.out.print(rs.getString(5)+" | ");
  29.                 System.out.print(rs.getString(6)+" | ");
  30.                 System.out.println();
  31.             }
  32.            
  33.             conn.close();
  34.         } catch (Exception e) {
  35.             System.out.println(e.getMessage());
  36.         }
  37.         System.out.println("getallrows()");
  38.  
  39.     }
  40. }
Advertisement
Add Comment
Please, Sign In to add comment