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:
Post a Comment