Coder Forum

Java Quellcode

package gfx.client;
 
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
 
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
 
import javax.swing.table.AbstractTableModel;
 
public class mymodel extends AbstractTableModel {
 
//Initiierung div. datenbankspezifischer Varbiablen
  static final String LOG_FILE = "jdbc.log";
  static final String USER     = "root";
  static final String PW       = "root";
  static final String URL      = "jdbc:mysql://localhost/db";
 String sql = "select * from tb1";
  MysqlDataSource mds = new MysqlDataSource();
  Connection con = null;
  PreparedStatement ps = null;
  ResultSet rs = null;
 
 public int getColumnCount() {...}
  public int getRowCount() {...}
  public Object getValueAt( int row, int col) {...}
   public String getColumnName(int c){...}
  public boolean isCellEditable( int row, int col) {...}
}

Java Quellcode

package gfx.client;
 
import java.awt.*;
import java.awt.event.MouseAdapter;
 
import java.awt.event.MouseEvent;
 
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.table.*;
 
public class TableDB extends JInternalFrame
{
  public static String sql_preview ;
 
	public TableDB( String sql_preview){
    Vector columnNames = new Vector();
        Vector data = new Vector();
 
        try
        {
            //  Connect to the Database
 
            String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
            String url = "jdbc:mysql://localhost/hotel";
            String userid = "root";
            String password = "root";
 
            Class.forName( driver );
            Connection connection = DriverManager.getConnection( url, userid, password );
 
            //  Read data from a table
 
            Statement stmt = connection.createStatement();
          ResultSet rs = stmt.executeQuery( sql_preview );
            ResultSetMetaData md = rs.getMetaData();
            int columns = md.getColumnCount();
 
            //  Get column names
 
            for (int i = 1; i <= columns; i++)
            {
                columnNames.addElement( md.getColumnName(i) );
            }
 
            //  Get row data
 
            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 );
        }
 
        //  Create table with database data
 
        JTable table = new JTable(data, columnNames)
        {
			public Class getColumnClass(int column)
			{
				return getValueAt(0, column).getClass();
			}
        };
 
        JScrollPane scrollPane = new JScrollPane( table );
        getContentPane().add( scrollPane );
 
        JPanel buttonPanel = new JPanel();
        getContentPane().add( buttonPanel, BorderLayout.SOUTH );
    try {
      jbInit();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
 
    public static void main(String[] args)
    {
        TableDB frame = new TableDB( sql_preview );
        frame.setDefaultCloseOperation( EXIT_ON_CLOSE );
        frame.pack();
 
        frame.setVisible(true);
 
 
    }
 
  private void jbInit() throws Exception {
  }
 
}

Source code

private JTable tab = nee JTable(new mymodel());