Android Development Tech Blogs.

java.sql.SQLException: Column Index out of range, 2 > 1 try          {               Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");          PreparedStatement pst2=(PreparedStatement) con.prepareStatement("select Starting_Date from group1 where Group_Number='"+jComboBox2.getSelectedItem().toString()+"'");             ResultSet rs2=pst2.executeQuery();             while(rs2.next())             {                     startCalendar.setTime(rs2.getDate(2));                              }              pst2.close();             rs2.close();          }          catch(Exception e)          {              System.out.println(e);          } Answer Is-: try          {               Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.get

 try         {             Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");             String sql="select Group_Number,MemberName,Payment,Date,Withdraw from insatllment";             PreparedStatement pst=(PreparedStatement) con.prepareStatement(sql);             ResultSet rs=pst.executeQuery();           HSSFRow rowhead = sheet.createRow((short)0); rowhead.createCell((short) 0).setCellValue("Group_Number"); rowhead.createCell((short) 1).setCellValue("MemberName"); rowhead.createCell((short) 2).setCellValue("Payment"); rowhead.createCell((short) 3).setCellValue("Date"); rowhead.createCell((short) 4).setCellValue("Withdraw"); int index=1; while(rs.next()) { HSSFRow row = sheet.createRow((short)index); row.createCell((short) 0).setCellValue(rs.getString(1).toSt

private void jTextField15KeyReleased(java.awt.event.KeyEvent evt) {                                                      DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");         try         {            Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select i.MemberName as Name,g.Group_Number as GroupName,g.Starting_Date,g.Ending_Date,g.Cost as Amount,i.Payment as Installment,i.date,i.Withdraw from insatllment i inner join group1 g on i.Group_Number=g.Group_Number\n" + "where i.MemberName='"+jTextField15.getText()+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);    DefaultTableModel tm33 = (DefaultTableModel)sark.getModel();    // System.out.println("Naveen");        tm33.setRowCount(0);     ResultSet rs = pst.executeQuery

private void jTextField15KeyReleased(java.awt.event.KeyEvent evt) {                                               try         {            Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select i.MemberName as Name,g.Group_Number as GroupName,g.Starting_Date,g.Ending_Date,g.Cost as Amount,i.Payment as Installment,i.date,i.Withdraw from insatllment i inner join group1 g on i.Group_Number=g.Group_Number\n" + "where i.MemberName='"+jTextField15.getText()+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);    DefaultTableModel tm33 = (DefaultTableModel)sark.getModel();    // System.out.println("Naveen");        tm33.setRowCount(0);     ResultSet rs = pst.executeQuery(sql);      int i=0;   while(rs.next())   { Vector v2 = new Vector(); Calendar sta

public String rec() {         Random r=new Random();         int ran=r.nextInt(9999);         String newStr = "P-" + ran ;         jTextField2.setText(newStr);         return newStr; }

/*  * To change this license header, choose License Headers in Project Properties.  * To change this template file, choose Tools | Templates  * and open the template in the editor.  */ package Demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Calendar; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import net.proteanit.sql.DbUtils; /**  *  * @author NAVJYOTI  */ public class Jtablee extends javax.swing.JFrame {     /**      * Creates new form Jtablee      */     public Jtablee() {         initComponents();         set();     }     private int getsize() { int count=0; try {Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root"); Statement stmt=con.createStat

Desktop.getDesktop().open(new File("h://Member.xls"));

 try         {            Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select * from group1 where Group_Number='"+jTextField14.getText()+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);     DefaultTableModel tm33 = (DefaultTableModel) maintable.getModel();         tm33.setRowCount(0);     ResultSet rs = pst.executeQuery(sql);      int i=0;   while(rs.next())   { Vector v2 = new Vector(); Calendar startCalendar = Calendar.getInstance(); startCalendar.setTime(rs.getDate(2)); Calendar endCalendar = Calendar.getInstance(); endCalendar.setTime(rs.getDate(3)); int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR); int diffMonth = diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH); System.out.println(

package Demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import net.proteanit.sql.DbUtils; /**  *  * @author NAVJYOTI  */ public class Jtablee extends javax.swing.JFrame {     /**      * Creates new form Jtablee      */     public Jtablee() {         initComponents();         set();     }     private int getsize() { int count=0; try {Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root"); Statement stmt=con.createStatement(); String query="select * from group1"; ResultSet rs= stmt.executeQuery(query); while(rs.next()) { count++; } return count; } catch(Exception e) {

member1.setDefaultRenderer(Object.class, new TableCellRenderer(){     private DefaultTableCellRenderer DEFAULT_RENDERER =  new DefaultTableCellRenderer();             @Override             public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) {                 Component c = DEFAULT_RENDERER.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);                 if(isSelected){                     //c.setBackground(Color.YELLOW);                 }else{                 if (row%2 == 0){                     c.setBackground(Color.WHITE);                 }                 else {                     c.setBackground(Color.LIGHT_GRAY);                 }     }        if(table.getColumnModel().getColumn(column).getIdentifier().equals("Withdraw")){//Here `Status` is column name     if(value.toString().equals("OK")){//Here `OK` is the value of row       

 d5  = ((JTextField)jDateChooser1.getDateEditor().getUiComponent()).getText();         SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); Calendar c = Calendar.getInstance();         try {             c.setTime(sdf.parse(d5));         } catch (ParseException ex) {             Logger.getLogger(Commity.class.getName()).log(Level.SEVERE, null, ex);         } c.add(Calendar.MONTH, 1);  // number of days to add d5 = sdf.format(c.getTime()); System.out.println(""+d5);         try {             java.util.Date date = new SimpleDateFormat("yyyy-MM-d").parse(String.valueOf(d5));             jDateChooser1.setDate(date);                    } catch (ParseException ex) {             Logger.getLogger(Commity.class.getName()).log(Level.SEVERE, null, ex);         }         try         {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity",

String d1  = ((JTextField)jDateChooser1.getDateEditor().getUiComponent()).getText();         try         {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select MemberName,Group_Number,Payment from insatllment where Date='"+d1+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);     ResultSet rs = pst.executeQuery(sql);   countdate.setModel(DbUtils.resultSetToTableModel(rs)); con.close(); pst.close();         }         catch(Exception e)         {             JOptionPane.showMessageDialog(null, e);         }

private void jTextField9KeyReleased(java.awt.event.KeyEvent evt) {                                                    try         {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select m.ID,m.MemberName,m.ContactNo,m.Amount,g.Group_Number,g.Starting_Date,g.Ending_Date,g.Cost,g.Installment,g.No_of_Members from member m\n" + "inner join group1 g on m.Group_Number=g.Group_Number where m.MemberName='"+jTextField9.getText()+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);     ResultSet rs = pst.executeQuery(sql);    member.setModel(DbUtils.resultSetToTableModel(rs)); con.close(); pst.close();         }         catch(Exception e)         {             JOptionPane.showMessageDialog(null, e);         }     }    

private void jComboBox1PopupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) {                                                               String no=(String)jComboBox1.getSelectedItem();           try         {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select Cost from group1 where Group_Number='"+no+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);    //pst.setString(1, no);     ResultSet rs = pst.executeQuery(sql);      while(rs.next())   {    double cost=rs.getDouble(1);  jTextField8.setText(""+cost);   } con.close(); pst.close();         }         catch(Exception e)         {             System.out.println(e);             JOptionPane.showMessageDialog(null, e);         }     }      

  try         {            Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");     String sql="select m.MemberName,m.ContactNo,m.Amount,g.Group_Number,g.Starting_Date,g.Ending_Date,g.Cost,g.Installment,g.No_of_Members from member m\n" + " inner join group1 g on m.Group_Number=g.Group_Number";     java.sql.PreparedStatement pst=con.prepareStatement(sql);        ResultSet rs = pst.executeQuery(sql);    member.setModel(DbUtils.resultSetToTableModel(rs));    con.close(); pst.close();         }         catch(Exception e)         {             JOptionPane.showMessageDialog(null, e);         }