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
Post a Comment