Results 1 to 1 of 1
Thread: cant view table
- 12-14-2008, 01:46 PM #1
Member
- Join Date
- Nov 2008
- Posts
- 2
- Rep Power
- 0
cant view table
hi guys..ive set up my table in database(microsoft access) but i cant seem to view the table.my label n text field are there.
pls help ya
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.table.*;
import javax.swing.event.*;
public class StudentExam
{
JFrame SExam=new JFrame("Student Examination Results");
//Container
private Container ExamContainer=SExam.getContentPane();
//Labels
private JLabel name=new JLabel(" Name :");
private JLabel userid=new JLabel(" User ID :");
private JLabel maintitle=new JLabel("STUDENT EXAMINATION REPORT");
private JLabel empty=new JLabel("");
//panel
private JPanel panel1=new JPanel();
private JPanel panel2=new JPanel();
private JPanel panel3=new JPanel();
private JPanel panel4=new JPanel();
//text field
private JTextField namefield=new JTextField(10);
private JTextField idfield=new JTextField(10);
//button
private JButton backbutton=new JButton("Back to Student Module");
private Connection StudentCon;
private Statement StudentState;
private ResultSet resultSet;
public void FormatStudent()
{
namefield.setEditable(false);
idfield.setEditable(false);
ExamContainer.setLayout(new BorderLayout());
maintitle.setFont(new Font("System",Font.BOLD,20));
panel1.setLayout(new FlowLayout());
panel1.add(maintitle);
panel2.add(name);
panel2.add(namefield);
panel2.add(empty);
panel2.add(userid);
panel2.add(idfield);
panel3.add(backbutton);
ExamContainer.add(panel1,BorderLayout.NORTH);
ExamContainer.add(panel2,BorderLayout.CENTER);
ExamContainer.add(panel3,BorderLayout.SOUTH);
ExamContainer.add(panel4,BorderLayout.WEST);
SExam.setTitle("Student Examination Report");
SExam.setSize(440,400);
SExam.setDefaultCloseOperation(SExam.EXIT_ON_CLOSE );
SExam.setVisible(true);
getGrades();
}
public void getGrades()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
StudentCon=DriverManager.getConnection("jdbc:odbc: StudentManagement","BRYAN","HO");
StudentState=StudentCon.createStatement();
}
catch(ClassNotFoundException confex)
{
System.err.println("Failed to load Driver");
System.exit(1);
}
catch(SQLException sqlex)
{
System.err.println("unable to connect");
System.exit(1);
}
catch(Exception sqlex)
{
System.err.println("ERROR");
}
getExam();
}
private void getExam()
{
try{
String query="SELECT * FROM ExaminationResult";
StudentState=StudentCon.createStatement();
resultSet=StudentState.executeQuery(query);
displayResultSet(resultSet);
StudentState.close();
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
}
}
private void displayResultSet(ResultSet rs) throws SQLException
{
boolean moreRecords=rs.next();
Vector columnHeads=new Vector();
Vector rows=new Vector();
try
{
ResultSetMetaData rsmd=rs.getMetaData();
for(int i=1;i<=rsmd.getColumnCount();++i);
do{
rows.addElement(getNextRow(rs,rsmd));
}while(rs.next());
JTable table=new JTable(rows,columnHeads);
panel4.add(table);
SExam.validate();
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
}
}
private Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)throws SQLException
{
Vector currentRow=new Vector();
for(int i=1;i<=rsmd.getColumnCount();++i)
switch(rsmd.getColumnType(i))
{
case Types.VARCHAR:
currentRow.addElement(rs.getString(i));
break;
case Types.INTEGER:
currentRow.addElement(new Long(rs.getLong(i)));
break;
case Types.SMALLINT:
currentRow.addElement(new Long(rs.getString(i)));
break;
default:
System.out.println("Type was:"+rsmd.getColumnTypeName(i));
}
return currentRow;
}
public static void main(String[]args)
{
StudentExam sex=new StudentExam();
sex.FormatStudent();
}
}
Similar Threads
-
Updating a view using actions in a seperate view
By xcallmejudasx in forum EclipseReplies: 0Last Post: 10-24-2008, 09:24 PM -
Binding a view or query to list\table
By t_ras in forum NetBeansReplies: 0Last Post: 09-08-2008, 06:46 PM -
How to view current threads in a table
By Java Tip in forum javax.swingReplies: 0Last Post: 06-26-2008, 07:35 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks