Saturday, 9 January 2016

Database using JTable

Write a java program to display the Records of Doctor(DNo,DName,Salary) from the
    database and display it on the screen.(use JTable).

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class Doctor extends JFrame
{
            Connection cn;
            Statement st;
            ResultSet rs;
            String head[]={"Dno","DName","Salary"};
            String as[][]=new String[10][10];
            public Doctor()
            {
                        try
                        {
                                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                       cn=DriverManager.getConnection("jdbc:odbc:Docs","","");
                                    st=cn.createStatement();
                                    rs=st.executeQuery("select * from doc");
                                    int i=0;
                                    while(rs.next())
                                    {
                                                as[i][0]=rs.getString("dno");
                                                as[i][1]=rs.getString("dname");
                                                as[i][2]=rs.getString("sal");
                                                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();
            }
}         


No comments:

Ebook

Ebook
Ebook