Advertisement
HarrJ

B8 Day 25 SELECT WHERE demo

Oct 9th, 2022 (edited)
1,326
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.64 KB | None | 0 0
  1. package mattroseb8wk5;
  2. import java.util.Scanner;
  3. import java.sql.*;
  4.  
  5.  
  6. public class Day25A {
  7.     private final String address = "jdbc:mysql://localhost:3306/mr_batch8_db";
  8.     private final String userName = "root";
  9.     private final String passWord = "";
  10.    
  11.     public static void main(String[] args) {
  12.         Scanner sc = new Scanner(System.in);
  13.         Day25A callMe = new Day25A();
  14.        
  15.         String pName;
  16.        
  17.         System.out.print("Enter product for search: ");
  18.         pName = sc.nextLine();
  19.         callMe.getRows(pName);
  20.     }
  21.    
  22.     public void getRows(String searchVal) {
  23.         searchVal = "%".concat(searchVal).concat("%");
  24.         String sqlQuery = "SELECT * FROM tbl_price_list WHERE fld_pname LIKE ?";
  25.        
  26.         try {
  27.             Connection conn = DriverManager.getConnection(
  28.                     address, userName, passWord);
  29.            
  30.             PreparedStatement stmt = conn.prepareStatement(sqlQuery);
  31.            
  32.             stmt.setString(1, searchVal);
  33.             ResultSet rs = stmt.executeQuery();
  34.            
  35.             while (rs.next()) {      
  36.                 System.out.print(String.format("%3d | ", rs.getInt(1)));
  37.                 System.out.print(String.format("%-30s | ", rs.getString(2)));
  38.                 System.out.print(String.format("%7.2f | ", rs.getDouble(3)));
  39.                 System.out.print(String.format("%-18s | ", rs.getString(4)));
  40.                 System.out.println(String.format("%-35s | ", rs.getString(5)));
  41.             }
  42.            
  43.             conn.close();
  44.         } catch (Exception e) {
  45.             System.out.println(e);
  46.         }
  47.     }
  48. }
  49.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement