Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try{
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, pass);
- stm = conn.createStatement();
- result = stm.executeQuery(sql);
- int row = 0;
- while(result.next()){
- String name = result.getString("name");
- String email = result.getString("email");
- jTable.setValueAt(name, row, 0); // row = 0, col = 0
- jTable.setValueAt(email, row, 1); // row = 0, col = 1
- row++;
- }
- result.close();
- stm.close();
- conn.close();
- }catch(Exception e){
- outWarn.setText("Warning: " + e.getMessage());
- }
- }
- // Unlimited rows
- ############
- table.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {},
- {},
- {},
- {}
- },
- new String [] {
- }
- ));
- ##############
- String[] colTitle = {"Name", "Email"};
- String[] rowData = new String[2];
- String sSQL = "";
- model = new DefaultTableModel(null, colTitle);
- try{
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, pass);
- stm = conn.createStatement();
- String sql = ""SELECT * FROM ITTB";
- result = stm.executeQuery(sql);
- int row = 0;
- while(result.next()){
- rowData[0] = rs.getString("Name");
- rowData[1] = rs.getString("Email");
- model.addRow(rowData);
- }
- jTable.setModel(model);
- result.close();
- stm.close();
- conn.close();
- }catch(Exception e){
- outWarn.setText("Warning: " + e.getMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment