Posts

Delete Data with help of jtable rows. we can get table row 0-postion field value.

 try         {         int row=clear.getSelectedRow();         String t=(clear.getValueAt(row, 0).toString());          Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/lms","root","root");             String sql="delete from clearpayment where ID='"+t+"'";             PreparedStatement pst=con.prepareStatement(sql);             pst.executeUpdate();             JOptionPane.showMessageDialog(null,"Deleted!!!");         }         catch(Exception e)         {         JOptionPane.showMessageDialog(null,"Click on Table!!!...
Read more

Delete row in Database through java swings.

try     {         int id=Integer.parseInt(jTextField12.getText());          Connection c=new Connection();             java.sql.Connection con=c.connectit();             String sql="DELETE FROM stock WHERE id =?";             PreparedStatement pst=con.prepareStatement(sql);             pst.setInt(1, id);             pst.executeUpdate();             JOptionPane.showMessageDialog(null, "Delete!!");     }     catch(Exception e)     {         JOptionPane.showMessageDialog(null, e);     }     table();     settext1();
Read more

Update data through java swing textfields in database.

    String bname=jTextField11.getText();     int id=Integer.parseInt(jTextField12.getText());     String vname=jTextField13.getText();     String des=jTextArea2.getText();     int quan=Integer.parseInt(jTextField14.getText());     String pcat=jTextField15.getText();      int size=Integer.parseInt(jTextField16.getText());    String col=jTextField6.getText();     String pd=jTextField17.getText();     int sp=Integer.parseInt(jTextField18.getText());     int pc=Integer.parseInt(jTextField19.getText());      String pm=jTextField20.getText();       String dis=jTextField21.getText();       try       {        Connection c=new Connection();             java.sql.Connection con=c.connectit(); ...
Read more

Sum of database field and set on JTable.

try     {       Connection c=new Connection();             java.sql.Connection con=c.connectit();     String sql="select SUM(Quantity) from stock where Category='s'";     PreparedStatement pst=con.prepareStatement(sql);     ResultSet rs=pst.executeQuery(sql); while(rs.next()) {     jLabel6.setText(""+rs.getInt(1)); } con.close(); pst.close();     }     catch(Exception e)     {         JOptionPane.showMessageDialog(null,e);     }
Read more

Datainsert through SubQuery.

 try     {    int id1=Integer.parseInt(jTextField23.getText());       int amount=Integer.parseInt(jTextField25.getText());    String mop=(String)jComboBox4.getSelectedItem();     String rp=(String)jComboBox5.getSelectedItem();           Connection c=new Connection();             java.sql.Connection con=c.connectit();         Statement stmt=con.createStatement();         String s="select * from returngoods where id='"+id1+"'";         ResultSet rs=stmt.executeQuery(s);         if(rs.next())         {             JOptionPane.showMessageDialog(null,"Already Returned!!!");         }         else        ...
Read more

Get Id from TextField And When jButton Click then Bind Data from Database in Jtable

int id=Integer.parseInt(jTextField22.getText()); try     {              Connection c=new Connection();             java.sql.Connection con=c.connectit();     String sql="select id,BrandName,VendorName,Description,Quantity,Category,Size,Color,PurchaseDate,SellingPrice,Product,Discount from stock where id='"+id+"'";     PreparedStatement pst=con.prepareStatement(sql);        ResultSet rs = pst.executeQuery(sql);     stock1.setModel(DbUtils.resultSetToTableModel(rs));    con.close(); pst.close();     }     catch(Exception e)     {         JOptionPane.showMessageDialog(null,e);     }
Read more

Bind data from database in jtable with the help of rs2xml.jar

 try     {       Connection c=new Connection();             java.sql.Connection con=c.connectit();     String sql="select id as ID,BrandName,VendorName,Description,Quantity,Category,Size,Color,PurchaseDate,SellingPrice,Product,Discount from stock";     PreparedStatement pst=con.prepareStatement(sql);     ResultSet rs=pst.executeQuery(sql);     stock.setModel(DbUtils.resultSetToTableModel(rs)); con.close(); pst.close();     }     catch(Exception e)     {         JOptionPane.showMessageDialog(null,e);     }   
Read more

Insert data in database through java swings.

 String brandname=jTextField1.getText();         int no=Integer.parseInt(jTextField2.getText());         String vendorname=jTextField3.getText();         String des=jTextArea1.getText();         int quan=Integer.parseInt(jTextField4.getText());         String productcategory=jTextField10.getText();         String size1=jTextField5.getText();         String col=jTextField36.getText();           String pdate = ((JTextField)jd4.getDateEditor().getUiComponent()).getText();         String sellingprice=jTextField7.getText();         String pcost=jTextField8.getText();         String pmodel=jTextField9.getText();         String discount=(String) jComboBox2.getSelectedItem(); ...
Read more

program to create bar chart in java with database.

 String d1  = ((JTextField)jd1.getDateEditor().getUiComponent()).getText(); //System.out.println(d1); String d2  = ((JTextField)jd2.getDateEditor().getUiComponent()).getText(); //System.out.println(d1);  try         {          Connection con=new Connection();             java.sql.Connection co=con.connectit();             PreparedStatement pst=co.prepareStatement("select SUM(AmountRecieved),SUM(TotalBalance),SUM(TotalBalance)-SUM(AmountRecieved) as DueBalance from sales where Date between '"+d1+"' and '"+d2+"'");             ResultSet rs=pst.executeQuery();             while(rs.next())             {      DefaultCategoryDataset  categoryDataset = new DefaultCategoryDataset();         ...
Read more