Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.util.*;
- import javax.swing.table.DefaultTableModel;
- import javax.swing.table.DefaultTableCellRenderer;
- import javax.swing.*;
- import java.awt.*;
- import java.awt.event.*;
- class BurgerData extends JFrame
- {
- JTable BurgerList;
- public BurgerData()
- {
- setSize(800,800);
- setLayout(new FlowLayout());
- setVisible(true);
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/image","root","");
- Statement stmnt = con.createStatement();
- ResultSet rs = stmnt.executeQuery("SELECT * FROM `icon`");
- ResultSetMetaData rsmetadata = rs.getMetaData();
- int col = rsmetadata.getColumnCount();
- DefaultTableModel dtm = new DefaultTableModel();
- Vector<String> col_name = new Vector<String>();
- Vector<Object> row_data = new Vector<Object>();
- for(int i=1;i<=col;i++)
- {
- col_name.addElement(rsmetadata.getColumnName(i));
- }
- dtm.setColumnIdentifiers(col_name);
- while(rs.next())
- {
- row_data = new Vector<Object>();
- for(int i=1;i<=col;i++)
- {
- row_data.addElement(rs.getObject(i));
- }
- dtm.addRow(row_data);
- }
- BurgerList = new JTable( dtm )
- {
- public Class getColumnClass(int column)
- {
- return getValueAt(0, column).getClass();
- }
- };
- BurgerList.setModel(dtm);
- add(BurgerList);
- }
- catch(SQLException e)
- {
- System.out.println("Unknown Error");
- }
- catch(Exception eg)
- {
- System.out.println("Unknown Error");
- }
- }
- public static void main(String args[])
- {
- BurgerData n = new BurgerData();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement