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);
}
}
}
