数据绑定表格.docxVIP

package databasevisit;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.Statement;import java.util.Vector;import javax.swing.JFrame;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.ScrollPaneConstants;import javax.swing.table.DefaultTableModel;public class DataBindingTable {/** * @param args */public static void main(String[] args) {// TODO Auto-generated method stubDemoWindow12 dw = new DemoWindow12(数据绑定表格);dw.setBounds(dw.getToolkit().getScreenSize().width / 3, dw.getToolkit().getScreenSize().height / 3,dw.getToolkit().getScreenSize().width / 3, dw.getToolkit().getScreenSize().height / 3);dw.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);dw.setVisible(true);}}class DemoWindow12 extends JFrame {DataGrid dg = new DataGrid(test, student2);int v = ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS;int h = ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS;JScrollPane jsp = new JScrollPane(dg, v, h);public DemoWindow12(String title) {super(title);add(jsp);}}class DataGrid extends JTable {String databaseName = null;String tableName = null;Connection con = null;Statement stm = null;ResultSet rs = null;ResultSetMetaData rsmd = null;Vector result = new Vector();DefaultTableModel dtm = null;String[] fieldNames = null;public DataGrid(String databaseName, String tableName) {this.databaseName = databaseName;this.tableName = tableName;init();load();setDataSource();}public void init() {try {Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);con = DriverManager.getConnection(jdbc:sqlserver://localhost:1433;DatabaseName=+ databaseName, sa, jocean);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void load() {try {stm = con.createStatement();rs = stm.executeQuery(select * from + tableName);rsmd = rs.getMetaData();while (rs.next()) {Vector temp = new Vector();for (int i = 1; i = rsmd.getColumnCount(); i++) {temp.add(rs.getObject(i));}re