Видео

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

thank you bro

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

package ATM; import java.awt.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; import javax.swing.table.JTableHeader; public class CustomerDetailsAll extends JFrame { JTable table; DefaultTableModel model; JTextField searchField; JComboBox searchColumnsBox; JButton searchButton,refreshButton,printButton,backButton; Connection conn; public CustomerDetailsAll(){ setLayout(new BorderLayout()); getContentPane().setBackground(new Color(30, 30, 30)); model = new DefaultTableModel(); table = new JTable(model); table.setBackground(new Color(30, 30, 30)); table.setForeground(new Color(250, 250, 250)); table.setFont(new Font("Serif", Font.PLAIN, 18)); table.setRowHeight(30); JTableHeader tableHeader = table.getTableHeader(); tableHeader.setFont(new Font("Serif", Font.BOLD, 18)); tableHeader.setBackground(new Color(30, 30, 30)); tableHeader.setForeground(new Color(250, 250, 250)); JScrollPane scrollPane = new JScrollPane(table); add(scrollPane, BorderLayout.CENTER); JPanel searchPanel = new JPanel(); searchPanel.setBackground(new Color(30, 30, 30)); JLabel searchLabel = new JLabel("Search by:"); searchLabel.setForeground(new Color(250, 250, 250)); searchLabel.setFont(new Font("Serif", Font.BOLD, 18)); searchField = new JTextField(20); searchField.setFont(new Font("Serif", Font.BOLD, 18)); String [] searchColumns = { "formNo", "Full_Name", "Father_Name", "DOB", "Gender", "Email", "Marital", "Address", "District", "Phone_No", "Provincial", "Postal_Code", "City" }; searchColumnsBox = new JComboBox<>(searchColumns); searchColumnsBox.setFont(new Font("Serif", Font.BOLD, 18)); searchColumnsBox.setBackground(new Color(30, 30, 30)); searchColumnsBox.setForeground(new Color(250, 250, 250)); searchButton = new JButton("Search"); styleButtons(searchButton, new Color(0, 123, 255)); refreshButton = new JButton("Refresh"); styleButtons(refreshButton, new Color(40, 167, 69)); printButton = new JButton("Print"); styleButtons(printButton, new Color(220, 53, 69)); backButton = new JButton("Back"); styleButtons(backButton, new Color(255, 193, 7)); searchPanel.add(searchLabel); searchPanel.add(searchField); searchPanel.add(searchColumnsBox); searchPanel.add(searchButton); searchPanel.add(refreshButton); searchPanel.add(printButton); searchPanel.add(backButton); add(searchPanel, BorderLayout.NORTH); conn = new Conn().c; loadTableData(null,null); searchButton.addActionListener(e -> searchAction()); refreshButton.addActionListener(e -> loadTableData(null,null)); printButton.addActionListener(e -> { try { table.print(); }catch (Exception ex) { ex.printStackTrace(); } }); backButton.addActionListener(e -> { setVisible(false); new AdminPanel().setVisible(true); }); setTitle("Customer Details All"); setSize(1200,700); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setVisible(true); } public void styleButtons(JButton button, Color color){ button.setPreferredSize(new Dimension(150,50)); button.setBackground(color); button.setForeground(color.WHITE); button.setFont(new Font("Serif", Font.BOLD, 18)); } private void loadTableData(String column, String value) { try { String query = "SELECT p1.formNo, p1.fullName AS Full_Name, p1.fatherName AS Father_Name, p1.gender AS Gender, " + "p2.email AS Email, p2.marital AS Marital, p2.address AS Address, p2.district AS District, " + "p3.phoneNo AS Phone_No, p3.provincial AS Provincial, p3.postalCode AS Postal_Code, p3.city AS City " + "FROM perdetail1 p1 " + "JOIN perdetail2 p2 ON p1.formNo = p2.formNo " + "JOIN perdetail3 p3 ON p1.formNo = p3.formNo"; if (column != null && value != null && !value.isEmpty()) { String actualColumn = switch (column) { case "formNo" -> "p1.formNo"; case "Full_Name" -> "p1.fullName"; case "Father_Name" -> "p1.fatherName"; case "Gender" -> "p1.gender"; case "Email" -> "p2.email"; // Update to p2 case "Marital" -> "p2.marital"; // Update to p2 case "Address" -> "p2.address"; // Update to p2 case "District" -> "p2.district"; // Update to p2 case "Phone_No" -> "p3.phoneNo"; // Update to p3 case "Provincial" -> "p3.provincial"; case "Postal_Code" -> "p3.postalCode"; case "City" -> "p3.city"; default -> column; }; query += " WHERE " + actualColumn + " LIKE ?"; // Ensure there's a space before WHERE } PreparedStatement ps = conn.prepareStatement(query); if (column != null && value != null && !value.isEmpty()) { ps.setString(1, "%" + value + "%"); // Adjusted for proper LIKE clause } ResultSet rs = ps.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); model.setRowCount(0); model.setColumnCount(0); int cols = rsmd.getColumnCount(); Vector<String> columnNames = new Vector<>(); for (int i = 0; i < cols; i++) { columnNames.add(rsmd.getColumnName(i + 1)); } model.setColumnIdentifiers(columnNames); while (rs.next()) { Vector<String> row = new Vector<>(); for (int i = 0; i < cols; i++) { row.add(rs.getString(i + 1)); } model.addRow(row); } } catch (SQLException ex) { ex.printStackTrace(); } } private void searchAction(){ String searchValue = searchField.getText(); String searchColumn = searchColumnsBox.getSelectedItem().toString(); loadTableData(searchColumn,searchValue); } public static void main(String[] args) { new CustomerDetailsAll(); } }

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

❤

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

goood🤜🤜🤜

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara

import java.util.Scanner; public class VotingSystem { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); // Step 1: Create list of candidates String[] candidates = {"Alice", "Bob", "Charlie"}; int[] votes = new int[candidates.length]; // Step 2: Input number of voters System.out.print("Enter the number of voters: "); int numVoters = scanner.nextInt(); // Step 3: Cast votes for (int i = 0; i < numVoters; i++) { System.out.println(" Voter " + (i + 1) + ", choose your candidate:"); for (int j = 0; j < candidates.length; j++) { System.out.println((j + 1) + ". " + candidates[j]); } int vote = scanner.nextInt(); if (vote > 0 && vote <= candidates.length) { votes[vote - 1]++; } else { System.out.println("Invalid vote."); } } // Step 4: Display vote counts System.out.println(" --- Election Results ---"); int maxVotes = 0; String winner = ""; for (int i = 0; i < candidates.length; i++) { System.out.println(candidates[i] + ": " + votes[i] + " votes"); if (votes[i] > maxVotes) { maxVotes = votes[i]; winner = candidates[i]; } } // Step 5: Announce the winner System.out.println("The winner is: " + winner); scanner.close(); } }

Pseudo Code: 1. Start 2. Create a list of candidates (e.g., "Anura", "Sajith", "Namal") 3. Create an array to store vote counts, initialized to 0 for each candidate 4. Prompt the user to enter the number of voters 5. Read the number of voters and store it in numOfVoters 6. For each voter (loop from 1 to numOfVoters): o Display the list of candidates with numbers o Ask the voter to choose a candidate by entering the candidate's number o Read the voter's input o If the input is valid (i.e., a number between 1 and the number of candidates):  Increment the vote count for the selected candidate o Else:  Display "Invalid vote" 7. Display "Election Results" 8. For each candidate: o Display the candidate’s name and the number of votes they received o Check if the candidate received more votes than the current highest vote count (maxVote)  If yes, update maxVote and set this candidate as the winner 9. Display the name of the candidate with the highest votes (winner) 10. End

Election Voting System You are developing a basic election voting system where users can cast their votes for a predefined list of candidates. Requirements: 1. Input: o Create a list of candidates. o Input the number of voters. o Each voter can vote for one candidate from the list. 2. Processing: o Count the votes for each candidate. o Identify the candidate with the most votes. 3. Output: o Display the vote count for each candidate. o Announce the winner.

Fb page Link - facebook.com/EnglishWithPawara?mibextid=ZbWKwL RUclips Link - www.youtube.com/@StudywithPawara2024 Telegram Group Link - t.me/englishwithpawara