/*
Import database data in JTable.
Creation of 2 vectors
Col and dat col are stored in the field name
DAT to the data content.
Dbname=new JTable (Dat,col);
*/
Package Demo;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.io.*;import java.sql.*; Import Java.util.vector;public class Tabledemo extends Jframe{jscrollpane jsp=new JScrollPane (); JTable dbname;public Tabledemo () {super ("Loading database content example"); Container C=getcontentpane (); C.setlayout (new BorderLayout ()); ResultSetMetaData Rsd=null; Vector col= new vector (); Vector dat= new vector (); Try{class.forname ("Com.mysql.jdbc.Driver");} catch (ClassNotFoundException E1) {System.out.println ("The related driver not found!");} Try{connection con=drivermanager.getconnection ("Jdbc:mysql://localhost:3306/mysql?user=root&password=root &useunicode=true&characterencoding=utf8 "); Statement st=con.createstatement (); ResultSet rs=st.executequery ("SELECT * from User"), Rsd=rs.getmetadata (); for (int i=1;i<=rsd.getcolumncount (); i++) {Col.add (Rsd.getcolumnname (i));} while (Rs.next ()) {vector v=new vector (), for (int i=1;i<=rsd.getcolumncount (); i++) {v.addelement (rs.getstring (i));} Dat.addelement (v);} St.close (); con.clOSE (); SYSTEM.OUT.PRINTLN ("Database load succeeded!");} catch (SQLException E2) {System.out.println ("Table not found!" +e2.getnextexception () + "\ n" +e2.getsqlstate ()); Dbname=new JTable (Dat,col); Jsp.getviewport (). Add (dbname); C.add (JSP); Setdefaultcloseoperation (Jframe.exit_on_ CLOSE); setSize (800,600); setvisible (true);} public static void Main (string[] args) {Tabledemo jst=new tabledemo ();}}
JTable write to database contents