JdbcSql.rar_java resultset_jtable

import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.util.*; import java.io.*; import java.sql.*; import javax.swing.table.*; //import java.util.Vector;使用Vector类更规范 class JdbcSql extends JFrame implements ActionListener { JPanel p,p1,p2; JButton button1,button2,button3; JTable table=null; DefaultTableModel defaultModel=null; JTextField t1,t2,t3,t4; ResultSet result; Connection con; Statement stat; Object[][] c;//用来对table进行构造 String[] b;// int n,j; public JdbcSql() { p1=new JPanel(new GridLayout(4,3)); t1=new JTextField(15); t2=new JTextField(15); t3=new JTextField(15); t4=new JTextField(15); button1=new JButton("确定"); button2=new JButton("清空"); button3=new JButton("关闭"); p1.add(new JLabel("数据库")); p1.add(t1); p1.add(button1); p1.add(new JLabel("用户名")); p1.add(t2); p1.add(button2); p1.add(new JLabel("密码")); p1.add(t3); p1.add(button3); p1.add(new JLabel("表名")); p1.add(t4); p1.add(new JLabel()); p2=new JPanel(new BorderLayout()); defaultModel=new DefaultTableModel(c,b); table=new JTable(defaultModel); table.setPreferredScrollableViewportSize(new Dimension(300,150)); p2.add(new JScrollPane(table),BorderLayout.CENTER); p=new JPanel(new BorderLayout()); p.add(p1,BorderLayout.NORTH); p.add(p2,BorderLayout.CENTER); button1.addActionListener(this); button2.addActionListener(this); button3.addActionListener(this); getContentPane().add(p); pack(); setLocation(250,200); // setSize(300,400); setVisible(true); setDefaultCloseOperation(3); t1.setText("pubs"); t2.setText("sa"); t3.setText(""); t4.setText("authors"); } public void actionPerformed(ActionEvent event) { if (event.getSource()==button1) { lianjie(); } if(event.getSource()==button2) { t1.setText(""); t2.setText(""); t3.setText(""); t4.setText(""); } if(event.getSource()==button3) { System.exit(0); } } public static void main(String[] args) { new JdbcSql(); } void lianjie() { try { String url="jdbc:odbc:"+t1.getText(); String db="Select * from "+t4.getText(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection(url,t2.getText(),t3.getText()); stat=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); result=stat.executeQuery(db); ResultSetMetaData a=result.getMetaData(); n=a.getColumnCount(); b=new String[n];//确定一维数组 for(int i=0;i<n;i++) { b[i]=a.getColumnName(i+1); } j=0; while(result.next()) { j++; } c=new String[j][n]; int row=0; result.beforeFirst(); while (result.next()) { for (int i=1;i<=n ;i++ ) { Object obj=result.getObject(i); String str=""; if(!result.wasNull()) { str=obj.toString().trim(); c[row][i-1]=str; } else c[row][i-1]="null"; } row++; } defaultModel.setDataVector(c,b); result.close(); stat.close(); con.close(); } catch(Exception e) { JOptionPane.showMessageDialog(null,e); } } }