Posts

java.sql.SQLException: Column Index out of range, 2 > 1

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));                              }    ...
Read more

Get Datebase in Excel sheet.

 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 ind...
Read more

Searching through KeyReleased with data Diffrence and count month.

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.prep...
Read more

jTextField15KeyReleased in Netbeans getMonth name and difference between two date with mysql

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....
Read more

Add String with random number and set on JTextField.

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

JTable Example.

/*  * 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");    ...
Read more

Open Excel File Through java

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

Count No_Of_Month in Between Two Month in java

 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) - startCalen...
Read more

Jtable with database manually in netbeans.

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= ...
Read more

Change Jtable cell color right click on JTable go to customize code and paste this code.

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){                    ...
Read more

Set Date on jDateChooser and retrieve record from database.

 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);                    } cat...
Read more

get record based on date.

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);         }
Read more

Searching through Key Released in netbeans

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();  ...
Read more

jComboBox1PopupMenuWillBecomeInvisible Event in Netbeans and set value on JTextField

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);  ...
Read more

join the table set on jtable with rs2xml.jar

  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);  ...
Read more