Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mattroseb8wk5;
- import java.util.Scanner;
- import java.sql.*;
- public class Day25A {
- private final String address = "jdbc:mysql://localhost:3306/mr_batch8_db";
- private final String userName = "root";
- private final String passWord = "";
- public static void main(String[] args) {
- Scanner sc = new Scanner(System.in);
- Day25A callMe = new Day25A();
- String pName;
- System.out.print("Enter product for search: ");
- pName = sc.nextLine();
- callMe.getRows(pName);
- }
- public void getRows(String searchVal) {
- searchVal = "%".concat(searchVal).concat("%");
- String sqlQuery = "SELECT * FROM tbl_price_list WHERE fld_pname LIKE ?";
- try {
- Connection conn = DriverManager.getConnection(
- address, userName, passWord);
- PreparedStatement stmt = conn.prepareStatement(sqlQuery);
- stmt.setString(1, searchVal);
- ResultSet rs = stmt.executeQuery();
- while (rs.next()) {
- System.out.print(String.format("%3d | ", rs.getInt(1)));
- System.out.print(String.format("%-30s | ", rs.getString(2)));
- System.out.print(String.format("%7.2f | ", rs.getDouble(3)));
- System.out.print(String.format("%-18s | ", rs.getString(4)));
- System.out.println(String.format("%-35s | ", rs.getString(5)));
- }
- conn.close();
- } catch (Exception e) {
- System.out.println(e);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement