java - JTable not showing output -


here's code:

private void show(java.awt.event.actionevent evt) {     connection conn = null;     string url = "jdbc:mysql://localhost:3306/";     string dbname = "phone";     string driver = "com.mysql.jdbc.driver";     string username = "root";     string password = "school";     try {         class.forname(driver).newinstance();         conn = drivermanager.getconnection(url + dbname, username, password);         preparedstatement pstmt = conn.preparestatement("select * contacts");         resultset rs = pstmt.executequery();         jframe frame1 = new jframe();         frame1.setdefaultcloseoperation(jframe.exit_on_close);          frame1.setsize(300, 150);         frame1.setvisible(true);         while (rs.next() == true) {              object rowdata[][] = {{"name"},                 {"phone"}};             object columnnames[] = {"column one", "column two"};             jtable table = new jtable(rowdata, columnnames);             jscrollpane scrollpane = new jscrollpane(table);             frame1.add(scrollpane, borderlayout.center);           }         rs.close();         pstmt.close();         conn.close();     } catch (exception ex) {         system.out.println(ex);     } } 

i want display record in separate window showing blank screen. corrections suggested?

            vector columnnames = new vector();             vector data = new vector();                              try{             connection conn = null;             drivermanager.registerdriver(new oracle.jdbc.oracledriver());             conn = drivermanager.getconnection(             "jdbc:oracle:thin:@localhost:1521:xe","yedal ","yedal121288");             statement stmt = conn.createstatement();                 resultset rs = stmt.executequery("");                             resultsetmetadata meta=rs.getmetadata();                                 int columns = meta.getcolumncount();                 (int = 1; <= columns; i++)                  {                     columnnames.addelement( meta.getcolumnname(i) );                 }                 while (rs.next())                  {                      vector row = new vector(columns);                     (int = 1; <= columns; i++)                     {                         row.addelement( rs.getobject(i) );                     }                        data.addelement( row );                 }                 rs.close();                 stmt.close();                 }               catch (sqlexception ex) {                  ex.printstacktrace();                  }               t= new jtable(data, columnnames); t.setvisible(true);                           tablecolumn col;               (int = 0; < t.getcolumncount(); i++)               {                  col = t.getcolumnmodel().getcolumn(i);                  col.setmaxwidth(200);              }               jscrollpane scrollpane = new jscrollpane(t); 

Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -