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
        {
        String sql="insert into returngoods values('"+id1+"',(select BrandName from stock where id='"+id1+"')"
                + ",(select VendorName from stock where id='"+id1+"')"
                + ",(select Description from stock where id='"+id1+"')"
                + ",(select Quantity from stock where id='"+id1+"')"
                + ",(select Category from stock where id='"+id1+"')"
                + ",(select Size from stock where id='"+id1+"')"
                + ",(select Color from stock where id='"+id1+"')"
                + ",(select PurchaseDate from stock where id='"+id1+"')"
                + ",(select SellingPrice from stock where id='"+id1+"')"
                + ",(select PurchaseCost from stock where id='"+id1+"')"
                + ",(select Product from stock where id='"+id1+"')"
                + ",(select Discount from stock where id='"+id1+"')"
                + ",'"+mop+"','"+rp+"',"+amount+")";
          
      
           int i= stmt.executeUpdate(sql);
            if(i>0)
            {
               JOptionPane.showMessageDialog(null,"Saved!");
            }
            else
            {
                JOptionPane.showMessageDialog(null,"Unsaved!!");
            }
            String sql2="delete from stock where id='"+id1+"'";
            stmt.executeUpdate(sql2);
    }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null,e);
        System.out.println(e);
    }
    table3();
    table();
    set();
}

Popular posts from this blog

Simple Sign up design. Android.

Image
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     app:layout_behavior="@string/appbar_scrolling_view_behavior"     tools:context=".Signup"     tools:showIn="@layout/activity_signup">     <ScrollView         android:layout_width="fill_parent"         android:layout_height="fill_parent"         android:fillViewport="true"         tools:ignore="MissingConstraints">     <LinearLayout         android:layout_width="fill_parent"         android:layout_height="fill_parent"         android:orientation="vertic
Read more

Cart page design in android.

Image
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     app:layout_behavior="@string/appbar_scrolling_view_behavior"     tools:context=".Cart"     tools:showIn="@layout/activity_cart">     <LinearLayout         android:id="@+id/activity_cart_list"         xmlns:android="http://schemas.android.com/apk/res/android"         xmlns:tools="http://schemas.android.com/tools"         android:layout_width="match_parent"         android:layout_height="match_parent"         android:orientation="vertical"         android:weightSu
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);                    } 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",
Read more