Hello , I have the following Code. I am able to fetch the Data from the Database. But i need to implement pagination for the same. Can someone please help me out with this ? I have tried out many things from the internet.. but i can't really understand what i should be doing .
CODE :
package javaapplication1;
import com.itextpdf.text.Document; import com.itextpdf.text.DocumentException; import com.itextpdf.text.pdf.PdfContentByte; import com.itextpdf.text.pdf.PdfTemplate; import com.itextpdf.text.pdf.PdfWriter; import java.awt.Color; import java.awt.Component; import java.awt.Dimension; import java.awt.Font; import java.awt.Graphics2D; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.table.DefaultTableModel; import javax.swing.JTable; import javax.swing.table.TableCellRenderer; import javax.swing.table.TableColumn; import net.proteanit.sql.DbUtils;
public final class menuframe extends javax.swing.JFrame { static final String JDBC_DRIVER ="com.mysql.jdbc.Driver"; static final String DB_URL="jdbc:mysql://localhost/user"; static final String USER = "root"; static final String PASS="techsoft";
Connection con=null; ResultSet rs=null; PreparedStatement ps =null;
public menuframe() throws SQLException {
initComponents();
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(DB_URL, USER, PASS);
}
catch(ClassNotFoundException | SQLException e){}
Update_Table();
}
private void Update_Table() throws SQLException { String sql="SELECT * FROM details"; ps=con.prepareStatement(sql); rs=ps.executeQuery(); table1.setModel(DbUtils.resultSetToTableModel(rs));
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jScrollPane3 = new javax.swing.JScrollPane();
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
jLabel11 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jTextField3 = new javax.swing.JTextField();
jTextField4 = new javax.swing.JTextField();
jTextField5 = new javax.swing.JTextField();
jTextField6 = new javax.swing.JTextField();
jTextField7 = new javax.swing.JTextField();
jTextField8 = new javax.swing.JTextField();
jTextField9 = new javax.swing.JTextField();
jTextField10 = new javax.swing.JTextField();
Clear_btn = new javax.swing.JButton();
Pdf_export = new javax.swing.JButton();
jTextField2 = new javax.swing.JTextField();
jScrollBar = new javax.swing.JScrollPane();
table1 = new javax.swing.JTable()
{
public Component prepareRenderer(TableCellRenderer renderer, int row, int column) {
Component comp = super.prepareRenderer(renderer, row, column);
comp.setBackground(row % 2 == 0 ? Color.white : Color.cyan);
int rendererWidth = comp.getPreferredSize().width;
TableColumn tableColumn = getColumnModel().getColumn(column);
tableColumn.setPreferredWidth(Math.max(rendererWidth +
getIntercellSpacing().width,
tableColumn.getPreferredWidth()));
return comp;
}
}
;
Add_to_table = new javax.swing.JButton();
Excel_Export = new javax.swing.JButton();
jLabel12 = new javax.swing.JLabel();
jMenuBar1 = new javax.swing.JMenuBar();
jMenu1 = new javax.swing.JMenu();
jMenuItem1 = new javax.swing.JMenuItem();
jSeparator1 = new javax.swing.JPopupMenu.Separator();
jMenuItem2 = new javax.swing.JMenuItem();
jSeparator2 = new javax.swing.JPopupMenu.Separator();
jMenuItem3 = new javax.swing.JMenuItem();
jMenu2 = new javax.swing.JMenu();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Main Menu");
setAlwaysOnTop(true);
setFocusTraversalPolicyProvider(true);
setLocationByPlatform(true);
setMaximizedBounds(new java.awt.Rectangle(20, 40, 50, 100));
setMinimumSize(new java.awt.Dimension(500, 500));
setResizable(false);
getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jScrollPane3.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
jScrollPane3.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
jScrollPane3.setViewportBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
jScrollPane3.setAutoscrolls(true);
jScrollPane3.setMinimumSize(new java.awt.Dimension(1500, 1500));
jScrollPane3.setPreferredSize(new java.awt.Dimension(1370, 768));
jPanel1.setBackground(java.awt.SystemColor.textHighlight);
jPanel1.setBorder(javax.swing.BorderFactory.createMatteBorder(2, 2, 2, 2, new java.awt.Color(0, 0, 0)));
jPanel1.setMinimumSize(new java.awt.Dimension(920, 680));
jPanel1.setOpaque(false);
jPanel1.setPreferredSize(new java.awt.Dimension(1366, 780));
jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel1.setBackground(new java.awt.Color(255, 255, 255));
jLabel1.setFont(new java.awt.Font("Comic Sans MS", 2, 18)); // NOI18N
jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel1.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jPanel1.add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 0, 351, 40));
jLabel2.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel2.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel2.setForeground(new java.awt.Color(255, 255, 255));
jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel2.setText("First Name");
jLabel2.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, new java.awt.Color(255, 255, 255), java.awt.Color.white, java.awt.Color.white));
jLabel2.setOpaque(true);
jLabel2.setPreferredSize(new java.awt.Dimension(85, 30));
jPanel1.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 50, 150, 40));
jLabel3.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel3.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel3.setForeground(new java.awt.Color(255, 255, 255));
jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel3.setText("Last Name");
jLabel3.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel3.setOpaque(true);
jPanel1.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(720, 50, 150, 40));
jLabel4.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel4.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel4.setForeground(new java.awt.Color(255, 255, 255));
jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel4.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\circular82.png")); // NOI18N
jLabel4.setText("Age");
jLabel4.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel4.setOpaque(true);
jPanel1.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 170, 150, 40));
jLabel5.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel5.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel5.setForeground(new java.awt.Color(255, 255, 255));
jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel5.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\birthday13.png")); // NOI18N
jLabel5.setText("D.O.B");
jLabel5.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel5.setOpaque(true);
jPanel1.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(720, 110, 150, 40));
jLabel6.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel6.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel6.setForeground(new java.awt.Color(255, 255, 255));
jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel6.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\woman1.png")); // NOI18N
jLabel6.setText("Gender");
jLabel6.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel6.setOpaque(true);
jPanel1.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 110, 150, 40));
jLabel7.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel7.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel7.setForeground(new java.awt.Color(255, 255, 255));
jLabel7.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel7.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\pin66.png")); // NOI18N
jLabel7.setText("Country");
jLabel7.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel7.setOpaque(true);
jPanel1.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(720, 170, 150, 40));
jLabel8.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel8.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel8.setForeground(new java.awt.Color(255, 255, 255));
jLabel8.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel8.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\city22.png")); // NOI18N
jLabel8.setText("City");
jLabel8.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel8.setOpaque(true);
jPanel1.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 230, 150, 40));
jLabel9.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel9.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel9.setForeground(new java.awt.Color(255, 255, 255));
jLabel9.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel9.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\envelope43.png")); // NOI18N
jLabel9.setText("Email");
jLabel9.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel9.setOpaque(true);
jPanel1.add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(720, 230, 150, 40));
jLabel10.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel10.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel10.setForeground(new java.awt.Color(255, 255, 255));
jLabel10.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel10.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\telephone120.png")); // NOI18N
jLabel10.setText("Ph. No");
jLabel10.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel10.setOpaque(true);
jPanel1.add(jLabel10, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 290, 150, 40));
jLabel11.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.disabledShadow"));
jLabel11.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
jLabel11.setForeground(new java.awt.Color(255, 255, 255));
jLabel11.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel11.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Desktop\\comment13.png")); // NOI18N
jLabel11.setText("Comments");
jLabel11.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
jLabel11.setOpaque(true);
jPanel1.add(jLabel11, new org.netbeans.lib.awtextra.AbsoluteConstraints(720, 290, 150, 40));
jTextField1.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField1.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 50, 166, 40));
jTextField1.getAccessibleContext().setAccessibleName("");
jTextField3.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField3.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField3, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 170, 166, 40));
jTextField4.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField4.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField4, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 230, 166, 40));
jTextField5.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField5.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField5, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 290, 166, 40));
jTextField6.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField6.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField6, new org.netbeans.lib.awtextra.AbsoluteConstraints(930, 290, 160, 40));
jTextField7.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField7.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField7, new org.netbeans.lib.awtextra.AbsoluteConstraints(930, 50, 160, 40));
jTextField8.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField8.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField8, new org.netbeans.lib.awtextra.AbsoluteConstraints(930, 110, 160, 40));
jTextField9.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField9.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField9, new org.netbeans.lib.awtextra.AbsoluteConstraints(930, 170, 160, 40));
jTextField10.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField10.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField10, new org.netbeans.lib.awtextra.AbsoluteConstraints(930, 230, 160, 40));
Clear_btn.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
Clear_btn.setText("Clear");
Clear_btn.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Clear_btnActionPerformed(evt);
}
});
jPanel1.add(Clear_btn, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 370, 120, 40));
Pdf_export.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
Pdf_export.setText("Export to PDF");
Pdf_export.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Pdf_exportActionPerformed(evt);
}
});
jPanel1.add(Pdf_export, new org.netbeans.lib.awtextra.AbsoluteConstraints(650, 660, 150, 40));
jTextField2.setFont(new java.awt.Font("Verdana", 0, 14)); // NOI18N
jTextField2.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
jPanel1.add(jTextField2, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 110, 166, 40));
jScrollBar.setViewportBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
table1.setAutoCreateRowSorter(true);
table1.getTableHeader().setFont(new Font("SansSerif",Font.BOLD,12));
table1.getTableHeader().setForeground(Color.blue);
table1.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.LOWERED, new java.awt.Color(0, 0, 0), new java.awt.Color(0, 0, 0), java.awt.Color.black, java.awt.Color.black));
table1.setFont(new java.awt.Font("Comic Sans MS", 1, 12)); // NOI18N
table1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"First Name", "Last Name", "D.O.B", "Ph.No", "City", "Country", "Email"
}
));
table1.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF);
table1.setColumnSelectionAllowed(true);
table1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
table1.setDropMode(javax.swing.DropMode.ON);
table1.setEditingRow(3);
table1.setFillsViewportHeight(true);
table1.setGridColor(new java.awt.Color(255, 0, 0));
table1.setIntercellSpacing(new Dimension()
);
table1.setRowHeight(23);
table1.setRowMargin(5);
table1.getTableHeader().setReorderingAllowed(false);
jScrollBar.setViewportView(table1);
table1.getColumnModel().getSelectionModel().setSelectionMode(javax.swing.ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
if (table1.getColumnModel().getColumnCount() > 0) {
table1.getColumnModel().getColumn(2).setHeaderValue("D.O.B");
table1.getColumnModel().getColumn(3).setHeaderValue("Ph.No");
table1.getColumnModel().getColumn(4).setResizable(false);
table1.getColumnModel().getColumn(4).setHeaderValue("City");
table1.getColumnModel().getColumn(5).setHeaderValue("Country");
table1.getColumnModel().getColumn(6).setHeaderValue("Email");
}
jPanel1.add(jScrollBar, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 440, 310, 190));
Add_to_table.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
Add_to_table.setText("Add to Table");
Add_to_table.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Add_to_tableActionPerformed(evt);
}
});
jPanel1.add(Add_to_table, new org.netbeans.lib.awtextra.AbsoluteConstraints(480, 370, 140, 40));
Excel_Export.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N
Excel_Export.setText("Export to Excel");
Excel_Export.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Excel_ExportActionPerformed(evt);
}
});
jPanel1.add(Excel_Export, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 660, 160, 40));
jLabel12.setFont(new java.awt.Font("Comic Sans MS", 2, 18)); // NOI18N
jLabel12.setIcon(new javax.swing.ImageIcon("C:\\Users\\Rajeev sharma\\Downloads\\night_falling-wallpaper-1920x1080.jpg")); // NOI18N
jLabel12.setText("jLabel12");
jLabel12.setAlignmentY(0.0F);
jLabel12.setMinimumSize(new java.awt.Dimension(400, 600));
jLabel12.setOpaque(true);
jLabel12.setPreferredSize(new java.awt.Dimension(1500, 800));
jPanel1.add(jLabel12, new org.netbeans.lib.awtextra.AbsoluteConstraints(-500, -10, 1880, 900));
jScrollPane3.setViewportView(jPanel1);
getContentPane().add(jScrollPane3, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1500, 749));
jMenu1.setText("Reports");
jMenu1.setFont(new java.awt.Font("Segoe Print", 2, 18)); // NOI18N
jMenuItem1.setBackground(javax.swing.UIManager.getDefaults().getColor("MenuBar.shadow"));
jMenuItem1.setFont(new java.awt.Font("Comic Sans MS", 2, 16)); // NOI18N
jMenuItem1.setText("Detail Report");
jMenuItem1.setOpaque(true);
jMenuItem1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
jMenuItem1MousePressed(evt);
}
});
jMenu1.add(jMenuItem1);
jMenu1.add(jSeparator1);
jMenuItem2.setBackground(javax.swing.UIManager.getDefaults().getColor("MenuBar.shadow"));
jMenuItem2.setFont(new java.awt.Font("Comic Sans MS", 2, 16)); // NOI18N
jMenuItem2.setText("Summary Report");
jMenuItem2.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
jMenuItem2MousePressed(evt);
}
});
jMenu1.add(jMenuItem2);
jMenu1.add(jSeparator2);
jMenuItem3.setBackground(javax.swing.UIManager.getDefaults().getColor("MenuBar.shadow"));
jMenuItem3.setFont(new java.awt.Font("Comic Sans MS", 2, 16)); // NOI18N
jMenuItem3.setText("Admin Report");
jMenuItem3.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
jMenuItem3MousePressed(evt);
}
});
jMenu1.add(jMenuItem3);
jMenuBar1.add(jMenu1);
jMenu2.setText("Settings");
jMenu2.setFont(new java.awt.Font("Segoe Print", 2, 18)); // NOI18N
jMenuBar1.add(jMenu2);
setJMenuBar(jMenuBar1);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void jMenuItem1MousePressed(java.awt.event.MouseEvent evt) {
jLabel1.setText("WELCOME TO DETAIL REPORT");
}
private void Clear_btnActionPerformed(java.awt.event.ActionEvent evt) {
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextField10.setText("");
}
private void jMenuItem3MousePressed(java.awt.event.MouseEvent evt) {
jLabel1.setText("WELCOME TO ADMIN REPORT");
}
private void jMenuItem2MousePressed(java.awt.event.MouseEvent evt) {
jLabel1.setText("WELCOME TO SUMMARY REPORT");
}
private void Add_to_tableActionPerformed(java.awt.event.ActionEvent evt) {
DefaultTableModel model=(DefaultTableModel) table1.getModel(); model.addRow(new Object[]{ jTextField1.getText(),jTextField7.getText(),jTextField8.getText(),jTextField5.getText(),jTextField4.getText(), jTextField9.getText(),jTextField10.getText() }); }
private void Excel_ExportActionPerformed(java.awt.event.ActionEvent evt) {
ExcelExport exp=new ExcelExport();
exp.toExcel(table1, new File("E:\\Rajeev Sharma\\export.xls"));
System.out.println("exporting!");
}
void print()
{
Document doc=new Document();
try{
PdfWriter writer;
writer = PdfWriter.getInstance(doc, new FileOutputStream("E:\\Rajeev Sharma\\export.pdf"));
doc.open();
PdfContentByte cb = writer.getDirectContent();
table1.updateUI();
PdfTemplate tp=cb.createTemplate(800,800);
Graphics2D g2 = tp.createGraphicsShapes(800,800);
table1.print(g2);
g2.dispose();
cb.addTemplate(tp,30,00);
}catch(DocumentException | FileNotFoundException e){}
doc.close();
}
private void Pdf_exportActionPerformed(java.awt.event.ActionEvent evt) {
print();
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
try {
new menuframe().setVisible(true);
} catch (SQLException ex) {
Logger.getLogger(menuframe.class.getName()).log(Level.SEVERE, null, ex);
}
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton Add_to_table;
private javax.swing.JButton Clear_btn;
private javax.swing.JButton Excel_Export;
private javax.swing.JButton Pdf_export;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JMenu jMenu1;
private javax.swing.JMenu jMenu2;
private javax.swing.JMenuBar jMenuBar1;
private javax.swing.JMenuItem jMenuItem1;
private javax.swing.JMenuItem jMenuItem2;
private javax.swing.JMenuItem jMenuItem3;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollBar;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JPopupMenu.Separator jSeparator1;
private javax.swing.JPopupMenu.Separator jSeparator2;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField10;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.JTextField jTextField4;
private javax.swing.JTextField jTextField5;
private javax.swing.JTextField jTextField6;
private javax.swing.JTextField jTextField7;
private javax.swing.JTextField jTextField8;
private javax.swing.JTextField jTextField9;
private javax.swing.JTable table1;
// End of variables declaration
private Object GetData(JTable table1, int i, int i0) {
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
}