phonenum.java

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

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

/***********************************
 *                                 *
 *       主      程     序         *
 *                                 *
 ***********************************/

public class phonenum{
/****************************
 *    这里定义组件          *
 ****************************/
	static private JFrame frm;
	static private buttons button;
	static private menu bar;
	static private SqlTable tablePane;
	static private Box basePane;
    static private Connection con;
    static private String sql="select * from phonenum";
    static private String mdburl="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=phonenum.mdb";
    
    public static JFrame getFrame(){
    	return frm;
    }
    
	public phonenum(){
	 /******************************
	  *    这里是LookAndFeel       *
	  ******************************/
	   try{UIManager.setLookAndFeel(
			//UIManager.getCrossPlatformLookAndFeelClassName());
			  UIManager.getSystemLookAndFeelClassName());
			//"com.sun.java.swing.plaf.gtk.GTKLookAndFeel");
	   }catch(Exception e){}
	   
	 /******************************
	  *    这里定义数据库连接      *
	  ******************************/
	 try{
	  
	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	  con=DriverManager.getConnection(mdburl);
      }
	 catch(Exception e){e.printStackTrace();}

	 /******************************
	  *    这里初始化组件          *
	  ******************************/
	   getObject.setSql(sql);
	   basePane=Box.createVerticalBox();
	   tablePane=new SqlTable(con,sql);
	   frm=new JFrame("超强电话本");
	   frm.setLocation(300,150);
	   Container pan=frm.getContentPane();
	   button=new buttons(con,tablePane);
	   bar=new menu(con,tablePane,sql);
	   frm.setJMenuBar(bar);
	   frm.setContentPane(pan);
	   pan.add(basePane);
	   basePane.add(button,BorderLayout.NORTH);
	   basePane.add(tablePane,BorderLayout.CENTER);
       frm.pack();
	   frm.show();
	}
	
	public static String getConnection(){
	   return mdburl;
	}
	
	public static void furbish(){
	try{
	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	  con=DriverManager.getConnection(mdburl);
      }
	catch(Exception e){}//e.printStackTrace();}
		sql=getObject.getSql();
	    basePane.remove(tablePane);
	    tablePane=new SqlTable(con,sql);
	    basePane.add(tablePane,BorderLayout.CENTER);frm.show();
	}

/***********************************
 *          这里是主函数	       *
 ***********************************/
	public static void main(String args[]){
        new phonenum();
        //getObject.printSql(con,sql);
	}
}