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.