会python真的可以为所欲为0(回)
356天前
这里还有人吗1(回)
541天前这里还有人吗0(回)
541天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
766天前到处都是羊，不想上班0(回)
846天前
鸽子
0(回)
850天前/* |
* To change this license header, choose License Headers in Project Properties. |
* To change this template file, choose Tools | Templates |
* and open the template in the editor. |
*/ |
package jtabel; |
import java.awt.BorderLayout; |
import java.sql.Connection; |
import java.sql.DriverManager; |
import java.sql.PreparedStatement; |
import java.sql.ResultSet; |
import java.util.Vector; |
import javax.swing.JFrame; |
import javax.swing.JScrollPane; |
import javax.swing.JTable; |
import javax.swing.JTextField; |
import javax.swing.ListSelectionModel; |
import javax.swing.event.ListSelectionEvent; |
import javax.swing.event.ListSelectionListener; |
import javax.swing.table.DefaultTableModel; |
import javax.swing.table.TableRowSorter; |
public class TableModel extends JFrame { |
public DefaultTableModel tableModel; |
public JTable table; |
JScrollPane tablePane; |
Connection ct; |
PreparedStatement ps; |
ResultSet rs; |
public ListSelectionListener selectAndDisplay; |
public JTextField show; |
int s; |
public TableModel(){ |
selectAndDisplay = new ListSelectionListener() { |
@Override |
public void valueChanged(ListSelectionEvent e) { |
int row = table.getSelectedRow(); |
// System.out.println("转化前 ："+row); |
if(row!=-1){ |
s = table.convertColumnIndexToModel(row); |
System.out.println("转化后："+s); |
show.setText((String) table.getValueAt(s,0)); |
} |
} |
}; |
|
String[] columnStrings ={ |
"goods_Id", |
"goods_name", |
"goods_price", |
"goods_number" |
}; |
|
tableModel = new DefaultTableModel(); |
for(String i :columnStrings) |
tableModel.addColumn(i); |
|
try{ |
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); |
ct=DriverManager.getConnection("jdbc:odbc:bean"); |
System.out.println("select * from test.dbo,Inventory"); |
ps = ct.prepareStatement("select * from Market.dbo.Inventory"); |
rs= ps.executeQuery(); |
while(rs.next()){ |
Vector<String> Ve= new Vector<>(); |
Ve.add(rs.getString(1)); |
Ve.add(rs.getString(2)); |
Ve.add(rs.getString(3)); |
Ve.add(rs.getString(4)); |
tableModel.addRow(Ve); |
} |
}catch(Exception e){ |
System.out.println("ERROR:"+e); |
} |
|
|
table = new JTable(tableModel); |
table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); |
table.getSelectionModel().addListSelectionListener(selectAndDisplay); |
TableRowSorter<DefaultTableModel> sorter = new TableRowSorter<>(tableModel); |
table.setRowSorter(sorter); |
|
|
show = new JTextField(); |
tablePane = new JScrollPane(table); |
this.setLayout(new BorderLayout()); |
this.add(tablePane); |
this.add(show,BorderLayout.SOUTH); |
this.setTitle("JTable Model Test "); |
this.setSize(500,300); |
this.setVisible(true); |
this.setDefaultCloseOperation(3); |
} |
public static void main(String[] args) { |
new TableModel(); |
} |
} |
