Java Database Access will achieve the return of ResultSet values are displayed in tabular form (with source code)
JScrollPane need JPanel + + + JTable Shuilaihuachang DefaultTableModel these objects, a previous examples to show you see at a is to be JFrame, a graphical interface similar in other
Sqlserver cases - to the pubs for example, data in the table read titles:
Import java.awt .*;
Import java.sql .*;
Import java.util .*;
Import javax.swing .*;
Import java.awt.event .*;
Import javax.swing.table .*;
Public class ListFrame
(Extends JFrame
BorderLayout borderLayout1 = new BorderLayout ();
DefaultTableModel dtm = new DefaultTableModel ();
JPanel jPanel1 = new JPanel ();
JPanel jPanel2 = new JPanel ();
JScrollPane jScrollPane1 = new JScrollPane ();
JTable jTable1 = new JTable ();
JButton jButton1 = new JButton ();
Vector v = new Vector ();
Connection con;
Int columnCount;
Statement st;
ResultSet rs;
Public ListFrame () (
Try (
JbInit ();
)
Catch (Exception exception) (
Exception.printStackTrace ();
)
)
Private void jbInit () throws Exception (
This.setDefaultCloseOperation (EXIT_ON_CLOSE);
GetContentPane (). SetLayout (borderLayout1);
JPanel1.setLayout (null);
JPanel2.setBounds (10,10,790,250);
JPanel2.setLayout (null);
JButton1.setBounds (new Rectangle (300, 270, 142, 24));
JScrollPane1.setBounds (new Rectangle (10, 10, 755, 240));
JButton1.setText ( "data acquisition");
JButton1.addActionListener (new ListFrame_jButton1_actionAdapter (this));
This.getContentPane (). Add (jPanel1, java.awt.BorderLayout.CENTER);
JTable1.setModel (dtm);
JPanel1.add (jPanel2);
JPanel1.add (jButton1);
JPanel2.add (jScrollPane1);
JScrollPane1.getViewport (). Add (jTable1);
Class.forName ( "com.microsoft.jdbc.sqlserver.SQLServerDriver");
Con = DriverManager.getConnection (
"Jdbc: microsoft: sqlserver: / / localhost: 1433; DatabaseName = pubs", "sa"
"");
St = con.createStatement ();
Rs = st.executeQuery ( "select * from titles");
ColumnCount = rs.getMetaData (). GetColumnCount ();
For (int i = 1; i <= columnCount; i + +) (
Dtm.addColumn (rs.getMetaData (). GetColumnName (i));
)
Rs.close ();
This.setSize (800,350);
This.setVisible (true);
)
Public static void main (String [] args) (
ListFrame listframe = new ListFrame ();
)
Public void jButton1_actionPerformed (ActionEvent actionEvent) (
Try (
Rs = st.executeQuery ( "select * from titles");
String [] s = new String [columnCount];
While (rs.next ()) (
For (int i = 1; i <columnCount; i + +) (
S [i - 1] = rs.getString (i);
)
Dtm.addRow (s);
)
)
Catch (SQLException ex) (
System.out.println ( "1 –>"+ ex);
Ex.printStackTrace ();
)
)
)
Class ListFrame_jButton1_actionAdapter
(Implements ActionListener
Private ListFrame adaptee;
ListFrame_jButton1_actionAdapter (ListFrame adaptee) (
This.adaptee = adaptee;
)
Public void actionPerformed (ActionEvent actionEvent) (
Adaptee.jButton1_actionPerformed (actionEvent);
)
)
Tags: java access, java code, ResultSet