Hi, the code of my program is the following:
I have problems with this code.HTML Code:code import javax.swing.*; import javax.swing.table.*; import java.lang.*; import java.awt.*; import java.awt.event.*; public class TableConnection1 extends JFrame { static String bd = "-*******-"; static String usuario = "-******-"; static String clave = "-******-"; static String url = "jdbc:mysql://localhost/"+bd; public static void main(String args[]) throws Exception { TableConnection1 frame = new TableConnection1(); frame.setDefaultCloseOperation(EXIT_ON_CLOSE); frame.pack(); frame.setVisible(true); } TableConnection1() { Connection conexion = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conexion = DriverManager.getConnection(url, usuario, clave); if (conexion != null) { Statement stmt = conexion.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM contactos"); ResultSetMetaData md = rs.getColumnCount(); int columnCount = md.getColumnCount(); Vector columns = new Vector(columnCount); for (int i = 1; i < columnCount; i++) columns.add(md.getColumnName(i)); Vector data = new Vector(); Vector row; while (rs.next()) { row = new Vector(columnCount); for (int i = 1; i < columnCount; i++) { row.add(rs.getString(i)); } data.add(row); rs.close(); stmt.close(); conexion.close(); JTable table = new JTable(data, columns); JScrollPane scrollPane = new JScrollPane(table); getContentPane().add(scrollPane); } // fin del while // se agrega un escuchador para cerrar la ventana con la x de arriba addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { System.exit(0); } }); } // fin del if } // fin del try catch (InstantiationException ex) { } catch (IllegalAccessException ex) { } catch (SQLException ex) { } catch (ClassNotFoundException ex) { } } }
The errors are the following:
I don't know what's the problem.HTML Code:----jGRASP exec: javac -g C:\tut_java\TableConnection1.java TableConnection1.java:27: cannot find symbol symbol : class Connection location: class TableConnection1 Connection conexion = null; ^ TableConnection1.java:32: cannot find symbol symbol : variable DriverManager location: class TableConnection1 conexion = DriverManager.getConnection(url, usuario, clave); ^ TableConnection1.java:36: cannot find symbol symbol : class Statement location: class TableConnection1 Statement stmt = conexion.createStatement(); ^ TableConnection1.java:37: cannot find symbol symbol : class ResultSet location: class TableConnection1 ResultSet rs = stmt.executeQuery("SELECT * FROM contactos"); ^ TableConnection1.java:38: cannot find symbol symbol : class ResultSetMetaData location: class TableConnection1 ResultSetMetaData md = rs.getColumnCount(); ^ TableConnection1.java:41: cannot find symbol symbol : class Vector location: class TableConnection1 Vector columns = new Vector(columnCount); ^ TableConnection1.java:41: cannot find symbol symbol : class Vector location: class TableConnection1 Vector columns = new Vector(columnCount); ^ TableConnection1.java:47: cannot find symbol symbol : class Vector location: class TableConnection1 Vector data = new Vector(); ^ TableConnection1.java:47: cannot find symbol symbol : class Vector location: class TableConnection1 Vector data = new Vector(); ^ TableConnection1.java:48: cannot find symbol symbol : class Vector location: class TableConnection1 Vector row; ^ TableConnection1.java:53: cannot find symbol symbol : class Vector location: class TableConnection1 row = new Vector(columnCount); ^ TableConnection1.java:93: cannot find symbol symbol : class SQLException location: class TableConnection1 catch (SQLException ex) ^ 12 errors ----jGRASP wedge2: exit code for process is 1. ----jGRASP: operation complete.
Thank's so much for the help.
P.D. sorry for my english, I'm mexican.


Reply With Quote


Bookmarks