[ MarkoBalkan @ 17.11.2007. 23:09 ] @
private void a(java.awt.event.MouseEvent evt) { { Vector columnNames = new Vector(); Vector data = new Vector(); try { // Connect to the Database String driver = "com.mysql.jdbc.Driver"; // String url = "jdbc:odbc:Teenergy"; // if using ODBC Data Source name String url = "jdbc:mysql://localhost:3306/database"; String userid = "root"; String password = "123"; Class.forName( driver ); Connection connection = DriverManager.getConnection( url, userid, password ); // Read data from a table String sql = "Select * from tablica"; Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery( sql ); 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 } } ovo je kod koji čita iz baze na događaj miša. sad mi još treba da rezultat povežem i prikažem u jtable-u. znači ovaj događaj je unutar klase JFrame. a na JFrame se nalazi Jtable i buton. a klik na buton definira ovaj događaj iznad. |