Ready Project |BCA Project | MCA Project | BBA Project | MBA Project |INDIA'S BIGGEST COLLEGE PROJECT STORE




import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import javax.swing.*;

public class Product extends JFrame

{

            Connection cn;

            Statement st;

            ResultSet rs;

            String head[]={"Pid","Pname","Amount"};

            String as[][]= new String[10][10];

            public Product()

            {

                        try

                        {

                                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                                       cn=DriverManager.getConnection("jdbc:odbc:Product","","");

                                    st=cn.createStatement();

                                    rs=st.executeQuery("select * from prod");

                                    int i=0;

                                    while(rs.next())

                                    {

                                                as[i][0]=rs.getString("Pid");

                                                as[i][1]=rs.getString("Pname");

                                                as[i][2]=rs.getString("Amount");

                                                i++;

                                    }

                                    JTable jt=new JTable(as,head);

                                    JScrollPane pane=new JScrollPane(jt);

                                    getContentPane().add(pane);


                        }

                        catch(Exception e)

                        {

                                    System.out.println(e);

                        }


                        setSize(400,400);

                        setVisible(true);

            }

            public static void main(String args[])

            {

                        new Doctor().show();

            }

}

26) write a java program to display sales details of products between two dates in jtable(use database).consider producttable(pid,pname,amt).

Search

Project Categories

Recent Posts

Sign In