?? dbmanager.java
字號:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.sql.*;
import java.util.*;
public class DBManager extends JFrame implements ListSelectionListener
{
JList jl=new JList();
JScrollPane jspz=new JScrollPane(jl);
JTable jt=new JTable();
JScrollPane jspy=new JScrollPane(jt);
JSplitPane jsp=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,jspz,jspy);
Connection con;
Statement st;
public DBManager()
{
this.setTitle("數(shù)據(jù)庫查看器");
this.add(jsp);
jsp.setDividerLocation(200);
jsp.setDividerSize(4);
this.initDB();
this.initJList();
this.setBounds(100,100,600,400);
this.setVisible(true);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void initDB()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:stu","","");
st=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void initJList()
{
try
{
DatabaseMetaData dmd=con.getMetaData();
ResultSet rs=dmd.getTables(null,null,null,new String[]{"TABLE"});
Vector v=new Vector();
while(rs.next())
{
v.add(rs.getString(3));
}
jl.setListData(v);
}
catch(Exception e)
{
e.printStackTrace();
}
jl.addListSelectionListener(this);
}
public void valueChanged(ListSelectionEvent e)
{
try
{
String tn=(String)jl.getSelectedValue();
String sql="select * from "+tn;
ResultSet rs=st.executeQuery(sql);
ResultSetMetaData rsmd=rs.getMetaData();
Vector vcn=new Vector();
int cc=rsmd.getColumnCount();
for(int i=1;i<=cc;i++)
{
vcn.add(rsmd.getColumnName(i));
}
Vector vdata=new Vector();
while(rs.next())
{
Vector vtemp=new Vector();
for(int i=1;i<=cc;i++)
{
vtemp.add(rs.getString(i));
}
vdata.add(vtemp);
}
jt.setModel(new DefaultTableModel(vdata,vcn));
}
catch(Exception ea)
{
ea.printStackTrace();
}
}
public static void main(String args[])
{
new DBManager();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -