Java swing in NetBeans

thanks a lot sir for everything you answered for my last questions now sir i just have another 3 questions that is

Q 1.
i will specify a swing code for JTable using NETBEANS so would you tell me is it correct code for JTable and is there other way of specifying it.

code:
String c=Combo.getSelectedItem().toString();
String sql;
if(c.equals("PAID"))
{
sql="SELECT * FROM Fees_Struc, Student, Fees_Pay WHERE Fees_Struc.Hostel=Student.Hostel And Student.Roll=Fees_Pay.Roll And Fees_Pay.Status=?";
}
else
{
sql="SELECT * FROM Fees_Struc, Student, Fees_Pay WHERE Fees_Struc.Hostel=Student.Hostel And Student.Roll=Fees_Pay.Roll And Fees_Pay.Status=?";
}

try
{
int row=0,columns=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Stu","admin","admin");
try
{
PreparedStatement stm=con.prepareStatement(sql);
stm.setString(1, c);
ResultSet res=stm.executeQuery();
while(res.next())
{
row=res.getRow();

}
PreparedStatement stm1=con.prepareStatement(sql);
stm1.setString(1, c);
res=stm1.executeQuery();
ResultSetMetaData md = res.getMetaData();
columns = md.getColumnCount();
Object r[][]=new Object[row][columns] ;
int rindex=0;
while(res.next())
{
r[rindex][0]=res.getInt("Roll");
r[rindex][1]=res.getString("Name");
r[rindex][2]=res.getString("Add");
r[rindex][3]=res.getInt("Age");
r[rindex][4]=res.getString("Course");
r[rindex][5]=res.getString("Class");
r[rindex][6]=res.getString("Sex");
r[rindex][7]=res.getString("Hostel");
r[rindex][8]=res.getInt("Year");
r[rindex][9]=res.getString("Month");
r[rindex][10]=res.getInt("Paid");
r[rindex][11]=res.getInt("Bal");
r[rindex][12]=res.getString("Status");
rindex++;
}
jTable1.setModel(new javax.swing.table.DefaultTableModel(r, new String [] {"Roll No", "Name","Address","Age","Course","Class","Sex","Hostel","Year","Month","Paid","Bal","Status" }
));

res.close();
stm.close();
stm1.close();
con.close();
}

catch(SQLException ex)
{
javax.swing.JOptionPane.showMessageDialog(null,"Cannot display","Blank",javax.swing.JOptionPane.ERROR_MESSAGE);
}
}
catch(Exception e)
{
javax.swing.JOptionPane.showMessageDialog(null,"Cannot display","Blank",javax.swing.JOptionPane.ERROR_MESSAGE);
}
}

Q 2.
i want to transfer it to excel for printing so can u plz specify code for this above table.

Q 3.

i want to have another table like this is it possible: if it is can u give me code in NetBeans

Table Header Table Fields
_____________________________________________________
| ROll NO | Data from Database |
|______________|______________________________________|
| Name | Data from Database |
|______________|______________________________________|
| Address | Data from Database |
|______________|______________________________________|
| Age | Data from Database |
|______________|______________________________________|
| Course | Data from Database |
|______________|______________________________________|

sorry for specifying like this.....

View Answers

March 18, 2010 at 3:33 PM

Hi Friend,

1)Try the following :

import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;

public class JTableDatabase {
public static void main(String[] args) {
Vector columnNames = new Vector();
Vector data = new Vector();
JPanel p=new JPanel();
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
String sql = "Select * from data";
Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery( sql );
ResultSetMetaData md = rs.getMetaData();
int columns = md.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement( md.getColumnName(i) );
}
while (rs.next()) {
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++) {
row.addElement( rs.getObject(i) );
}
data.addElement( row );
}
rs.close();
stmt.close();
}
catch(Exception e) {
System.out.println( e );
}
JTable table = new JTable(data, columnNames);
TableColumn col;
for (int i = 0; i < table.getColumnCount(); i++) {
col = table.getColumnModel().getColumn(i);
col.setMaxWidth(250);
}
JScrollPane scrollPane = new JScrollPane( table );
p.add( scrollPane );
JFrame f=new JFrame();
f.add(p);
f.setSize(600,400);
f.setVisible(true);
}
}

March 18, 2010 at 4:32 PM

continue..

2)Try the following:

import javax.swing.*;
import java.awt.*;
import java.io.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;

class Form extends JFrame{
ResultSet rs;
Form(){
String data[][] = {{"",""}};
String col[] = {"Name","Address"};
final DefaultTableModel model = new DefaultTableModel(data,col);
final JTable table = new JTable(model);
JScrollPane pane=new JScrollPane(table);
JButton button=new JButton("Export");
JPanel panel=new JPanel();
JPanel panel1=new JPanel();
JPanel panel2=new JPanel();
final HSSFWorkbook wb = new HSSFWorkbook();
final HSSFSheet sheet = wb.createSheet("Excel Sheet");
try{
Connection con = null;
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";, "root", "root");
Statement st = con.createStatement();
rs= st.executeQuery("Select * from data");
while(rs.next()){
model.insertRow(table.getRowCount(),new Object[]{rs.getString("name"),rs.getString("address")});
}
model.removeRow(0);
panel1.add(pane);
panel2.add(button);
panel.add(panel1);
panel.add(panel2);
add(panel);
button.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
try{
HSSFRow rowhead = sheet.createRow((short)0);
rowhead.createCell((short) 0).setCellValue("Name");
rowhead.createCell((short) 1).setCellValue("Address");
int index=1;
int count=table.getRowCount();
for(int i=0;i<count;i++){
Object obj1 = GetData(table, i, 0);
Object obj2 = GetData(table, i, 1);

HSSFRow row = sheet.createRow((short)index);
row.createCell((short) 0).setCellValue(obj1.toString());
row.createCell((short) 1).setCellValue(obj2.toString());
index++;
}
FileOutputStream fileOut = new FileOutputStream("c:\\Hello.xls");
wb.write(fileOut);
fileOut.close();
Runtime rt = Runtime.getRuntime();
rt.exec("cmd.exe /C start C:\\Hello.xls");
}
catch(Exception ex){}
}
});
}
catch(Exception e){}

}
public Object GetData(JTable table, int row_index, int col_index){
return table.getModel().getValueAt(row_index, col_index);
}
}
class JTableToExcel{
public static void main(String arg[]) {
try
{
Form frame=new Form();
frame.setSize(450,200);
frame.setVisible(true);
}
catch(Exception e)
{}
}
}

Please clarify your third problem.

Thanks