Java Image Development Learning--jtable Import Database

Package Demo;import Java.awt.borderlayout;import Java.awt.container;import java.awt.event.mouseadapter;import Java.awt.event.mouseevent;import Java.awt.event.mouselistener;import Java.sql.resultset;import Java.sql.resultsetmetadata;import Java.sql.sqlexception;import Java.util.vector;import Javax.swing.JButton;import Javax.swing.jframe;import Javax.swing.jlabel;import Javax.swing.jpanel;import Javax.swing.JScrollPane;import Javax.swing.jtable;public Class Demo {public demo () {JFrame frame=new JFrame ("Twilight Snow Super Mac"); Container ContentPane = Frame.getcontentpane (); JPanel panel=new JPanel (); JPanel panel1=new JPanel (); JPanel panel2=new JPanel (); JLabel jlabel=new JLabel ("Super pa"); JButton button=new JButton ("Start"); JButton button2=new JButton ("pause"); JButton button3=new JButton ("Next song"), Contentpane.setlayout (New BorderLayout ());p Anel.add (JLabel);p anel.add (button); Panel.add (button2);p anel.add (Button3); Contentpane.add (Panel,borderlayout.north); JButton button4=new JButton ("exit"); Conn con=new Conn (); ResultSet Select = Con.getselect ("Select *from Chaoba"); Vector col = getcol (select); Vector data = GetData (select); JTable jtable=new JTable (Data,col); JScrollPane jscrollpane=new JScrollPane () Jscrollpane.getviewport (). Add (jTable);p anel1.add (button4);p Anel2.add ( JScrollPane); Contentpane.add (Panel1,borderlayout.south); Contentpane.add (Panel2,borderlayout.center); Frame.setsize (+); frame.setvisible (true); Button.addmouselistener (new Mouseadapter () {@Overridepublic void mouseclicked (MouseEvent arg0) {System.out.println ("Start");}}); Button2.addmouselistener (New Mouseadapter () {@Overridepublic void mouseclicked (MouseEvent arg0) {System.out.println ( "Pause");});} public static void Main (string[] args) {new DeMO ();} Public Vector Getcol (ResultSet rs) {vector col=new vector (); try {resultsetmetadata metaData = Rs.getmetadata (); int ColumnCount = Metadata.getcolumncount (); for (int i = 1; I <= columnCount; i++) {Col.add (Metadata.getcolumnname (i));}} catch (Exception e) {//TODO auto-generated catch block E.printstacktrace ();} RetUrn Col;} Public Vector GetData (ResultSet rs) {vector data=new vector (); try {resultsetmetadata metaData = Rs.getmetadata (); int ColumnCount = Metadata.getcolumncount (), while (Rs.next ()) {vector v=new vector (), for (int i=1;i<=columncount;i++) { V.addelement (rs.getstring (i)); Data.addelement (v);}} catch (SQLException e) {//TODO auto-generated catch block E.printstacktrace ();} return data;}}

　　

Package Demo;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.resultset;import Java.sql.resultsetmetadata;import Java.sql.sqlexception;import Java.sql.statement;import Java.util.Vector;public Class Conn {Connection con;public  Conn () {try {class.forname ("com.mysql.jdbc.Driver"); String url= "jdbc:mysql://localhost:3306/chaoba?user=root&password=root&useunicode=true& Characterencoding=utf8 "; Con=drivermanager.getconnection (URL);} catch (Exception e) {//TODO auto-generated catch block E.printstacktrace ();}} Public ResultSet getselect (String sql) {vector col=new vector (); Vector data=new vector (); ResultSet Rs=null;  Statement statement;try {Statement = Con.createstatement (); rs = statement.executequery (sql);} catch (SQLException e) {// TODO Auto-generated catch block E.printstacktrace ();} return RS;}}

　　

Java Image Development Learning--jtable Import Database