USE In another JFrame

     DataBase db=new DataBase();

    

    public NewJFrame() {

        initComponents();

       // db.OpenConnection();

//       db.Insertrecord("Sabir", "BCA II", "1001", "223333");

//       db.Insertrecord("Prem", "BCA III", "101", "333");

//       db.Insertrecord("Tejas", "BCA I", "1091", "444");

//       db.Insertrecord("Atul", "BCA II", "1021", "555");

     

// db.Updaterecord("1", "Sabir", "BCA III", "1011", "223333");

     ///db.DeleteRecord("1");

     

         ResultSet rs=  db.ReadStudent();

         try{

          while(rs.next()){

              System.out.println("Name:"+rs.getString("Name"));

          }

          }catch(Exception e){

          System.out.print("74 Error :"+e.getMessage());

          }

     

    }

Comments

Post a Comment

Popular posts from this blog

Remove (Clear) and remove Selected element

  ///===========Clear=================         jList1.setListData(new String[]{}); //==============Remove Selected Element =========       // TODO add your handling code here:      int count=0;         DefaultListModel listModel1 = new DefaultListModel();         ListModel<String> tempL=  jList1.getModel();                     //Create New Array and add element          for(int i=0;i<tempL.getSize();i++){             listModel1.add(i, tempL.getElementAt(i));         }                  //===Delete From Array         for(int index : jList1.getSelectedIndices()){                  /// System.out.println(index);           //...
Read more

JSpinner

  🔄 Java Swing JSpinner – Overview & Example JSpinner is a Swing component that allows users to select a number or object value from a sequence by clicking up/down arrows or typing. ✅ Key Features Method / Property Description setModel(SpinnerModel) Set a value model (number, list, date, etc.) getValue() Get current spinner value setValue(Object) Set spinner value addChangeListener(...) Listen to value changes 📦 Types of Spinner Models Spinner Model Description SpinnerNumberModel Integer/double values SpinnerListModel List of strings or objects SpinnerDateModel Dates (with min/max & step size) ✅ Example 1: Spinner with Numbers import javax.swing.*; import java.awt.*; public class NumberSpinnerExample { public static void main(String[] args) { JFrame frame = new JFrame("JSpinner Number Example"); frame.setSize(300, 100); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); ...
Read more

🛢️ MySQL Connection & CRUD Operations in Java

🛢️ MySQL Connection & CRUD Operations in Java In this guide, you will learn how to connect Java applications to a MySQL database and perform basic CRUD (Create, Read, Update, Delete) operations using JDBC (Java Database Connectivity). 🔌 1. Setting up MySQL Connector First, download the MySQL Connector/J (JDBC driver) and add the JAR file to your project’s build path or dependencies. 📡 2. Connecting to MySQL Database import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { private static final String URL = "jdbc:mysql://localhost:3306/testdb"; private static final String USER = "root"; private static final String PASSWORD = "your_password"; public static Connection getConnection() { try { return DriverManager.getConnection(URL, USER, PASSWORD); } catch (SQLException e) { System.out.println("Connection Failed!"); e.printStackTrace(); ...
Read more