Java swing in NetBeans

Ads
 

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

Ads









Related Tutorials/Questions & Answers:
java swing in netbeans
java swing in netbeans  how can create sub menu in java swing using netbeans?   Hi Friend, Try the following code: import javax.swing.... backwardMenuItem = new JMenuItem("Java"); newmenu.add(backwardMenuItem
Java swing in NetBeans - Swing AWT
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
Advertisements
jdbc and swing problem in netbeans
jdbc and swing problem in netbeans  i reteived the table from database in a jdbc program. next i want to do is place the table as it is in a jpanel.. i am using netbeans IDE can u tel me how to do that one?? urgent
jdbc and swing problem in netbeans
jdbc and swing problem in netbeans  i reteived the table from database in a jdbc program. next i want to do is place the table as it is in a jpanel.. i am using netbeans IDE can u tel me how to do that one?? urgent
java netbeans
java netbeans  i am making project in core java using Netbeans. Regarding my project i want to know that How to fetch the data from ms-access... using netbeans
java netbeans
java netbeans  i am making project in core java using Netbeans. Regarding my project i want to know that How to fetch the data from ms-access... using netbeans
java swing
java swing  view the book details using swing
java swing
java swing  what is java swing   Swing is a principal GUI toolkit for the Java programming language. It is a part of the JFC (Java Foundation Classes), which is an API for providing a graphical user interface for Java
Java swing
Java swing  Write a java swing program to calculate the age from given date of birth
java swing - Swing AWT
java swing  how to add image in JPanel in Swing?  Hi Friend, Try the following code: import java.awt.*; import java.awt.image....: http://www.roseindia.net/java/example/java/swing/ Thanks
java swing.
java swing.  Hi How SetBounds is used in java programs.The values in the setBounds refer to what? ie for example setBounds(30,30,30,30) and in that the four 30's refer to what
JAVA SWING
JAVA SWING  Hi.... Iam doing project in java...and my front end in swing ..our project is like billing software... then what are the topics i want cover? then how to design? pls help me
Java swing
are displayed in the table..I need the source code in java swing...Java swing  If i am login to open my account the textfield,textarea and button are displayed. if i am entering the time of the textfield
Java swing
to the database using java swing...Java swing  I create one table. That table contains task ID and Task Name. When I click the task ID one more table will be open and that table
Java swing
Java swing  how to create simple addition program using java swing?   import java.awt.*; import javax.swing.*; import java.awt.event.*; class SumOfNumbers extends JFrame { SumOfNumbers(){ JLabel lab1=new
Java swing
Java swing  when i enter the time into the textbox and activities into the textarea the datas saved into the database.the java swing code for the above item   import java.sql.*; import java.awt.*; import javax.swing.
java swing
java swing  what is code for diplay on java swing internal frame form MYSQL DB pls send   Here is a code of creating form on jinternalframe and connect to mysql. import java.io.*; import java.sql.*; import java.awt.
Java swing
Java swing  How to combine two java files
java swing
java swing  meaning of out.flush
Java swing - Java Beginners
Java swing  how to set the background picture for a panel in java swing .i m using Netbeans IDE.  Hi Friend, Try the following code: import java.awt.*; import java.awt.image.*; import java.io.*; import
Sitemap Java Swing Tutorial
-to-One Relationship | JPA-QL Queries Java Swing Tutorial Section Java Swing Introduction | Java 2D API | Data Transfer in Java Swing | Internationalization in Java Swing | Localization | What is java swing
Java Swing
Java Swing  I want scroll bar in a frame is it possible? if it is possible means i want coding for that please send me a reply
Java Swing
Java Swing   i have a Label more than that of a frame .... how to extend the frame to view the label which are hidden.. please send me the answer sir/madam
Java Swing
Java Swing  i have a Label more than that of a frame .... how to extend the frame to view the label which are hidden.. please send me the coding sir/madam
Java Swing
Java Swing  i have a Label more than that of a frame .... how to extend the frame to view the label which are hidden.. please send me the coding sir/madam
Java Swing
Java Swing  i have a Label more than that of a frame .... how to extend the frame to view the label which are hidden.. please send me the coding sir/madam
java login form using netbeans
java login form using netbeans  how to connect an access database to a login form using netbeans
Java swing
Java swing  Design an appliaction for with details such as name,age,DOB,address,qualification and finaly when we click the view details button all types details should be displayed in another View in TextView's..I need the sample
Java swing
Java swing  I create 2 text field f1,f2 and 2 button b1,b2.If i enter some text in the text field and click the button b1 the text field f1 text will be shown in the Message dialog box and if i click the button b2 the text field
Java Swing
Java Swing  Write an applet program to transfer the content of the text field into the listbox component on clicking a button code project  ...++"); model.addElement("Java"); model.addElement("Perl"); model.addElement
java swing
java swing  what is code for dislay image on java swinginternalframe form MYSQL DB pls send   Here is a code that displays an image on internal frame. import java.awt.*; import java.io.*; import javax.imageio.

Ads