Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //---------------- llenando la tabla de empleados--------------//
- private void llenarTabla() {
- try {
- DefaultTableModel model = new DefaultTableModel();
- jTEmpleados.setModel(model);
- jTEmpleados.setAutoCreateRowSorter(true);
- PreparedStatement ps = null;
- ResultSet rs = null;
- Connection conn = MySQLConection.getConnection();
- String sql = "SELECT numEmpleado,user FROM empleados where puesto='diseñador'";
- ps = conn.prepareStatement(sql);
- rs = ps.executeQuery();
- ResultSetMetaData rsMeta = rs.getMetaData();
- int columnas = rsMeta.getColumnCount();
- model.addColumn("ID");
- model.addColumn("Usuario");
- int[] anchos = {3, 50};
- for (int x = 0; x < columnas; x++) {
- jTEmpleados.getColumnModel().getColumn(x).setPreferredWidth(anchos[x]);
- }
- while (rs.next()) {
- Object[] filas = new Object[columnas];
- for (int i = 0; i < columnas; i++) {
- filas[i] = rs.getObject(i + 1);
- }
- model.addRow(filas);
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "Error al actualizar" + e);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement