populating jtable with sql server database

Question

public InventoryJFrame() throws ClassNotFoundException {
    try {
        initComponents();
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver" );
        StringstringCon="jdbc:sqlserver://AAYANPC;databaseName=Qseal;user=sa;password=123";

        Connection con=DriverManager.getConnection(stringCon);
        Statement state=con.createStatement();
        ResultSet rs=state.executeQuery("select * from Qseal");
        ResultSetMetaData rsmetadata=rs.getMetaData();
        int columns=rsmetadata.getColumnCount();
        DefaultTableMode1 dtm=new DefaultTableMode1();
    }   
    catch (SQLException ex) {

        Logger.getLogger(InventoryJFrame.class.getName()).log(Level.SEVERE, null, ex);
    }
}

i get a error in the line DefaultTableMode1 dtm=new DefaultTableMode1();. The error is "cannot find symbol" and in the hint it says that create a pachkage DefaultTableName in source pack

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

According to What does a “Cannot find symbol” compilation error mean?

A "Cannot find symbol" error is about the identifiers. When your code is compiled, the compiler needs to work out what each and every identifier in your code means.

A "Cannot find symbol" error means that the compiler cannot do this. Your code appears to be referring to something that the compiler doesn't understand.

I suppose you have a spelling error when taping DefaultTableModel. It ends with the character l instead of the digit 1.

edited Jun 20 '20 at 09:12

Community

1
1

answered Jun 29 '16 at 11:16

Mincong Huang

5,284
8
39
62

how do i type digit 1 instead of character 1 – Mohit Joshi Jun 29 '16 at 11:29
@MohitJoshi, it's an L, not one. – Mincong Huang Jun 29 '16 at 11:32
@MohitJoshi, copy this line `DefaultTableModel dtm=new DefaultTableModel();` – Mincong Huang Jun 29 '16 at 11:36
It's my pleasure. Can you accept my answer ? By the way, I don't recommand you to use admin account `sa` for you application, it can cause severe security issue. Check [why should an application not use the sa account](http://dba.stackexchange.com/questions/39124/why-should-an-application-not-use-the-sa-account) – Mincong Huang Jun 29 '16 at 11:57
i am new here . how can i give u the link of another question in asked on this forum. – Mohit Joshi Jun 29 '16 at 12:05
Do you mean [Data insertion in SQL Server table using jtextfield in netbeans](http://stackoverflow.com/questions/38092655/data-insertion-in-sql-server-table-using-jtextfield-in-netbeans) ? You can use the [markdown syntax](http://stackoverflow.com/editing-help) to give the URL. – Mincong Huang Jun 29 '16 at 12:07
There's a check mark on the left side of my answer, just under the number 0. @MohitJoshi – Mincong Huang Jun 29 '16 at 15:01
Thank, bro @MohitJoshi – Mincong Huang Jun 29 '16 at 16:18

populating jtable with sql server database

1 Answers1