Use JDBC ODBC bridge to read from Excel

import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
  public static void main(String[] argv) throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String myDB = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=c:/data.xls;"
        + "DriverID=22;READONLY=false";
    Connection con = DriverManager.getConnection(myDB, "", "");
  }
}

Connect to an Oracle database with JDBC

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {

  public static void main(String[] args) throws Exception {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection(
        "jdbc:oracle:thin:@//server.local:1521/prod", "scott", "tiger");
    conn.setAutoCommit(false);
    Statement stmt = conn.createStatement();
    ResultSet rset = stmt.executeQuery("select * from employee");
    while (rset.next()) {
      System.out.println(rset.getString(1));
    }
    stmt.close();
  }
}

   

Creating connection to the MySQL database

import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "org.gjt.mm.mysql.Driver";
    Class.forName(driverName);

    String serverName = "localhost";
    String mydatabase = "mydatabase";
    String url = "jdbc:mysql :// " + serverName + "/" + mydatabase; 
                                                                    
    String username = "username";
    String password = "password";
    Connection connection = DriverManager.getConnection(url, username, password);
  }
}

Connecting to a SQLServer Database using the NetDirect JDBC driver

import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
  public static void main(String[] argv) throws Exception {
    
    String driverName = "com.jnetdirect.jsql.JSQLDriver"; 
    Class.forName(driverName);
    
    String serverName = "127.0.0.1";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase; 
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
  }
}

Create a connection to MS Access database

import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
  // private static final String URL = "jdbc:odbc:TestDB";

  private static final String USERNAME = "admin";

  private static final String PASSWORD = "welcome";

  private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";

  private static final String URL
 = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Database\\testdb.mdb;}";

  public static void main(String[] args) throws Exception {

    Class.forName(DRIVER);
    Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

    connection.close();
  }
}

Code used in video "Java prog#45.Take value from JTable and set it to jDatechooser in Netbeans Java and Sqlite (mysql)"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#45.Take value from JTable and set it to jDatechooser in Netbeans Java and Sqlite (mysql)"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below

Date add3=rs.getDate("Update_date");
    cmd_date.setDate(add3);

Or if the above code don't work the use the below code 

String add12=rs.getString("Date_Of_Birth");
    ((JTextField)txt_dob.getDateEditor().getUiComponent()).setText(add12);

-------------------------------------------------------------

Java prog#45.Take value from JTable and set it to jDatechooser in Netbeans Java and Sqlite (mysql)

How can I make a JTable cell do different things on single-click
netbeans java tutorial
Values to be displayed in JTextfield when Clicked on JTable Cells.
Click on JTable Model Updates JTextfield
how can i get value from JTable and set it to textfield.
Show data from JTable in Jtextfield

Code used in video "Java prog#41.How to Use JProgressBar in netbeans java"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#41.How to Use JProgressBar in netbeans java"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the ProgressBarActionPerformed method action perform

 private void ProgressBarActionPerformed(java.awt.event.ActionEvent evt) {                                         

        int value =Integer.parseInt(value_int.getText());

        progressbar() ;

        jProgressBar1.setValue(value);

    }  

Code used in video "Java prog#37. Open new jframe and close previous jframe with the easy code in java netbeans"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#37. Open new jframe and close previous jframe with the easy code in java netbeans"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the NewActionPerformed  method action perform

  private void NewActionPerformed(java.awt.event.ActionEvent evt) {                                         

      

        

        close();

        Userino_frame s = new Userino_frame();

         s.setVisible(true);

    } 

Code used in video "Java prog#36.How to find maximum,minimum,average values from a table in mysql/sqlite in netbeans"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#36.How to find maximum,minimum,average values from a table in mysql/sqlite in netbeans"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the OKActionPerformed  method action perform

private void OKActionPerformed(java.awt.event.ActionEvent evt) {                                         

        

        try{

            String sql="select min(pressure),max(pressure),avg(pressure) from Userinfo";

            pst=conn.prepareStatement(sql);

            rs =pst.executeQuery();

            String add1=rs.getString("min(pressure)");

            min_pr.setText(add1);

            String add2=rs.getString("max(pressure)");

            max_pr.setText(add2);

            String add3=rs.getString("avg(pressure)");

            avg_pr.setText(add3);

            

    }catch(Exception e)

    {

           JOptionPane.showMessageDialog(null, e);

    }finally {

try{

  rs.close();

      pst.close();

    // conn.close();

  }

  catch(Exception e) {

                   }

      } 

        

        

    }        

Code used in video "Java prog#34. Open new JFrame when clicking/selecting an index from the jcombobox in java "

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#34. Open new JFrame when clicking/selecting an index from the jcombobox in Java "  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the comboselect() method action perform

    public void comboselect(){
 
    if (ComboBox_name.getSelectedItem()=="marry"){
        Userino_frame s = new Userino_frame();
         s.setVisible(true);
 
 
 
    }
    if(ComboBox_name.getSelectedItem()=="julia"){
    LoginJframe l=new LoginJframe();
    l.setVisible(true);
 
 
    }
 
 
 
    } 

Code used in video "Java prog#26.How to print JTable in Java netbeans"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#26.How to print JTable in Java netbeans"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINKThis code below is for the cmd_printActionPerformed  method action perform

MessageFormat header = new MessageFormat("Your Header name ");
        MessageFormat footer = new MessageFormat("Page {0,number,integer}      ");
        try {
            jTable1_pumpdata.print(JTable.PrintMode.FIT_WIDTH, header, footer, true, null, true, null);
            //table.print(JTable.PrintMode.FIT_WIDTH, header, null);
           // jTable1_pumpdata.print(JTable.PrintMode.FIT_WIDTH, header, footer);
        } catch (java.awt.print.PrinterException e) {
            System.err.format("Cannot print %s%n", e.getMessage());
        }

Code used in video "Java prog#24.confermation to detele data (Do you really want to delete ) in NetBeans java GUI"

Here I am providing the downloadable code link of  the java code I have used in the video

 "Java prog#24. confirmation to delete data (Do you really want to delete ) in NetBeans java GUI"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the cmd_deleteActionPerformed method action perform

 private void cmd_deleteActionPerformed(java.awt.event.ActionEvent evt) {                                           

        int p = JOptionPane.showConfirmDialog(null,"Do you really want to delete","Delete",JOptionPane.YES_NO_OPTION );

       if(p==0){

        String sql="delete from Empoyeeinfo where Empoyeeid =?";

        try{

        

            pst=conn.prepareStatement(sql);

            

            pst.setString(1, txt_Empoyeeid.getText());

            

            pst.execute();

            JOptionPane.showMessageDialog(null, "Deleted");

        

        }catch(Exception e){

        

         JOptionPane.showMessageDialog(null, e);

        

        }

        Update_table();

       }

    }   

Code used in video "Java prog#23.How to open any document e.g .pdf, .doc ,.png file from By a jbutton or jmanu NetBeans"

Here I am providing the downloadable code link of  the java code I have used in the video

 "Java prog#23.How to open any document e.g .pdf, .doc ,.png file from By a jbutton or jmanu NetBeans"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the HelpActionPerformed method action perform

  private void HelpActionPerformed(java.awt.event.ActionEvent evt) {                                           

        

              try                                      //try statement

        {

                  Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler "+"C:\\Users\\FilePath\\Frequently Asked Questions.pdf");

                  

                  

        } catch (Exception e)                    //catch any exceptions here

       {

            JOptionPane.showMessageDialog(null,"Error");  //print the error

       }

        

        

        

    } 

Code used in video "Java prog#22. Using Up/Down Arrow Key to Move in a jtable and get the Data in jtextfield netbeans"

Here I am providing the downloadable code link of  the java code I have used in the video

 "Java prog#22. Using Up/Down Arrow Key to Move in a jtable and get the Data in jtextfield netbeans"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the Table_EmployeeKeyReleased method action perform

 private void Table_EmployeeKeyReleased(java.awt.event.KeyEvent evt) {                                           

            if ((evt.getKeyCode() == KeyEvent.VK_UP) ||(evt.getKeyCode() == KeyEvent.VK_DOWN) )

        

        

       // if (evt.getKeyCode()==KeyEvent.VK_DOWN || evt.getKeyCode()==KeyEvent.VK_UP)

        {

        

        try{

         int row =Table_Employee.getSelectedRow();

         String Table_click=(Table_Employee.getModel().getValueAt(row, 0).toString());

         String sql ="select * from Empoyeeinfo where empoyeeid='"+Table_click+"' ";

         pst=conn.prepareStatement(sql);

          rs=pst.executeQuery();

          if(rs.next()){

          

          String add1 =rs.getString("empoyeeid");

          txt_Empoyeeid.setText(add1);

          String add2 =rs.getString("name");

          txt_name.setText(add2);

          String add3 =rs.getString("surname");

          txt_surname.setText(add3);

          String add4 =rs.getString("age");

          combo_age.setSelectedItem(add4);

          }

        

        }catch(Exception e){

        

        JOptionPane.showMessageDialog(null, e);

        }

        } 

        

    }    

Code used in video "Java prog#21.Advanced search a particular data inSQLite (MySql) Database in Netbeans java jtable"

Here I am providing the downloadable code link of  the java code I have used in the video

 "Java prog#21.Advanced search a particular data inSQLite (MySql) Database in Netbeans java jtable"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the txt_searchKeyReleased method action perform

  private void txt_searchKeyReleased(java.awt.event.KeyEvent evt) {                                       

     

                       try{

                 

              String sql ="select * from Empoyeeinfo where name =?" ;

              

           

    pst =conn.prepareStatement(sql);

    pst.setString(1, txt_search.getText());

    rs=pst.executeQuery();

    //pst.execute();

    Table_Employee.setModel(DbUtils.resultSetToTableModel(rs));

       

   

   

              String sql3 ="select * from Empoyeeinfo where name =?" ;

              

              pst=conn.prepareStatement(sql3);

               pst.setString(1, txt_search.getText());

               

               rs=pst.executeQuery();

               if(rs.next()){

               String add1=rs.getString("empoyeeid");

               txt_Empoyeeid.setText(add1);

               String add2=rs.getString("name");

              txt_name.setText(add2);

               String add3=rs.getString("surname");

               txt_surname.setText(add3);

               String add4=rs.getString("age");

               combo_age.setSelectedItem(add4);

      

               }

               

               

  

   

              String sql2 ="select * from Empoyeeinfo where empoyeeid =?" ;

              

              pst=conn.prepareStatement(sql2);

               pst.setString(1, txt_search.getText());

               

               rs=pst.executeQuery();

               if(rs.next()){

               String add1=rs.getString("empoyeeid");

               txt_Empoyeeid.setText(add1);

               String add2=rs.getString("name");

              txt_name.setText(add2);

               String add3=rs.getString("surname");

               txt_surname.setText(add3);

               String add4=rs.getString("age");

              combo_age.setSelectedItem(add4);

               

               }

               

               

    

   

              String sql1 ="select * from Empoyeeinfo where surname =?" ;

              

              pst=conn.prepareStatement(sql1);

               pst.setString(1, txt_search.getText());

               

               rs=pst.executeQuery();

               if(rs.next()){

               String add1=rs.getString("empoyeeid");

               txt_Empoyeeid.setText(add1);

               String add2=rs.getString("name");

              txt_name.setText(add2);

               String add3=rs.getString("surname");

               txt_surname.setText(add3);

               String add4=rs.getString("age");

                combo_age.setSelectedItem(add4);

               

               }

               

               

    }

           catch(Exception e)

    {

           JOptionPane.showMessageDialog(null, e);

    }

        

        

    }