sqltable.java

A easy phone book. With the book,you can manage you personal masagge.

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.util.*;

/***********************************
 *                                 *
 *       这里定义表格内容          *
 *                                 *
 ***********************************/
 
public class SqlTable extends JPanel{
	static Connection con;
    static String sql;
    static Statement stmt;
    static ResultSet rst;
    static private JScrollPane scrollPane;
    static private JTable table;
    static private JFrame frm;
    static private Vector vect,colnames;
    static private ListSelectionModel tableModel;
    static private String title[]={"姓名(name)","电话(tel)","性别(sex)","地址(address)"};//二维表列名
    
    
    public SqlTable(Connection con,String sql){
    	if(con==null){
    		try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    			con=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=phonenum.mdb");
    		}
    		catch(Exception e){
    			e.printStackTrace();
    		}
    		
    	}
    	sql=getObject.getSql();  
    	colnames=new Vector();
    	for(int i=0;i<title.length;i++)
    	  colnames.addElement(title[i]);
	
    	vect=getObject.getVect(con,sql);
    	setLayout(new BorderLayout());
    	table=new JTable(vect,colnames);
        tableModel=table.getSelectionModel();
    	table.setPreferredScrollableViewportSize(new Dimension(300,300));
    	tableModel.setSelectionMode(ListSelectionModel.SINGLE_INTERVAL_SELECTION);
    	scrollPane=new JScrollPane(table);
    	table.revalidate();
        add(scrollPane);
    }
    
    public static int[] getSelectedrows(){
    	int rows[]=table.getSelectedRows();
    	return rows;
    }
    
    public static String getValue(int row){
    	String value=(String)table.getValueAt(row,0);
    	return value;
    }
    
    public static void main(String args[]){
    	frm=new JFrame();
    	frm.getContentPane().add(new SqlTable(con,sql));
        frm.pack();
        frm.show();
    }
}