Sunday, December 23, 2012

Use JDBC ODBC bridge to read from Excel

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

public class Main {
  public static void main(String[] argvthrows 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[] argsthrows 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[] argvthrows 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[] argvthrows 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[] argsthrows Exception {

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

    connection.close();
  }
}

Saturday, November 17, 2012

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());
        }

Friday, October 26, 2012

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);

    }
        
        
    }