DataBase Part1


  import java.sql.Connection; 

  import java.sql.ResultSet;

  import java.sql.DriverManager; 

import java.sql.SQLException;

  

  

public class DataBase {

    

    private static final String URL = "jdbc:mysql://localhost:3306/testdb";

    private static final String USER = "root";

    private static final String PASSWORD = "Sabir123@";

    private static final String DBDRIVER = "com.mysql.cj.jdbc.Driver";

    

    java.sql.Statement stmt=null;

    Connection con;

    

    public void OpenConnection(){

       

        try{

         Class.forName(DBDRIVER);

con = DriverManager.getConnection(URL,USER,PASSWORD);

         System.out.print("Connection Success");

        }catch(Exception e){

            System.out.print("25 Line:"+e.getMessage());

        }

           

    }

    

    

    public void Insertrecord(String Name,String Class,String Roll,String Contact){

        

        String sql="INSERT INTO student (Name, Class, Roll, Contact) VALUES ('"+Name+"', '"+Class+"',"+Roll+","+Contact+");";

        ExcuteStatement(sql);

        

    }

    

     public void Updaterecord(String Id,String Name,String Class,String Roll,String Contact){

        

         String sql="UPDATE student SET Name = '"+Name+"',Class = '"+Class+"',Roll = "+Roll+",Contact = "+Contact+"  WHERE Id = "+Id;

         ExcuteStatement(sql);

    }

     

     public void DeleteRecord(String Id){

         

         String sql="DELETE FROM student where Id="+Id;

         ExcuteStatement(sql);

         

     }

     

     

     public ResultSet ReadStudent(){

          String sql="select * from student;";

                  

                  return this.ReadRecord(sql);

     }

     

         public ResultSet ReadStudentBySearch(String studentName){

         // String sql="select * from student Where Name='"+studentName+"';";

           String sql = "SELECT * FROM student WHERE Name LIKE '%" + studentName + "%';";

   

                  return this.ReadRecord(sql);

     }

     

     

  

     

     //=============

     public void ExcuteStatement(String sql){

              try {

             this.OpenConnection();

                        

     stmt = con.createStatement();

                     stmt.executeUpdate(sql);

            // con.close();

    // stmt.close();

}catch(Exception e) {

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

}

     }

        public ResultSet ReadRecord(String sql){

         ResultSet rs = null;

          try {

             this.OpenConnection();

                        

     stmt = con.createStatement();

                     rs= stmt.executeQuery(sql);

            // con.close();

    // stmt.close();

}catch(Exception e) {

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

}

          

          

     

          

          

         return rs;

     }

     

    

     

}


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