form1.java

JAVA语言实现的图书馆图书管理系统设计与源码

//Form1.java

import com.ms.wfc.app.*;
import com.ms.wfc.core.*;
import com.ms.wfc.ui.*;
import com.ms.wfc.data.*;
import com.ms.wfc.data.ui.*;

public class Form1 extends Form
{

    public void btnRefresh_Click(Object sender, Event evt)
    {
        try
        {
            btnRefresh.setEnabled( false );
            dataSource1.getRecordset().cancelBatch();
            Object bm =  dataSource1.getRecordset().getBookmark();
            dataSource1.requery();
            if( bm != null ) 
                dataSource1.getRecordset().setBookmark( bm );
            
        }
        catch (Exception e)
        {
            handleADOException(e);
        }
        btnRefresh.setEnabled( true );
    }

    public void btnClose_Click(Object sender, Event evt)
    {
		this.dispose();
    }

    public void dispose()
    {
        super.dispose();
        components.dispose();
    }
	
    public Form1()
    {
        // Required for Visual J++ Form Designer support
        initForm();
        
        this.show();
        this.update();

        //TODO: Add any constructor code after initForm call
    }    

    public void formClose(Event e)
    {
        Application.exit( );
    }    

    
    void handleADOException(Exception e)
    {
        e.printStackTrace();
        MessageBox.show( e.toString(), "Form1" );
    }

	private void Form1_click(Object source, Event e)
	{
		
	}

	/**
	 * NOTE: The following code is required by the Visual J++ form
	 * designer.  It can be modified using the form editor.  Do not
	 * modify it using the code editor.
	 */
	Container components = new Container();
	DataSource dataSource1 = new DataSource(components);
	Button btnRefresh = new Button();
	Button btnClose = new Button();
	Panel panel1 = new Panel();
	DataNavigator dataNavigator = new DataNavigator();
	DataGrid dataGrid = new DataGrid();
	Column column1 = new Column();
	Column column2 = new Column();
	Column column3 = new Column();
	Column column4 = new Column();
	Column column5 = new Column();
	Splitter splitter1 = new Splitter();

	private void initForm()
	{
		this.setBackColor(new Color(0, 64, 64));
		this.setFont(new Font("宋体", 12.0f, FontSize.POINTS, FontWeight.NORMAL, false, false, false, CharacterSet.DEFAULT, 0));
		this.setLocation(new Point(7, 7));
		this.setText("发行商数据管理");
		this.setAutoScaleBaseSize(new Point(8, 16));
		this.setAutoScroll(true);
		this.setClientSize(new Point(774, 545));
		this.setStartPosition(FormStartPosition.CENTER_SCREEN);
		this.setWindowState(FormWindowState.MAXIMIZED);
		this.addOnClick(new EventHandler(this.Form1_click));

		dataSource1.setConnectionString("PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\\My Documents\\db1.mdb");
		dataSource1.setCommandText("select 供应商ID, 供应商名称, 联系人姓名, 地址, 邮政编码 from 供应商 ORDER by 供应商ID");
		dataSource1.setSort(null);
		dataSource1.setStayInSync(true);
		dataSource1.setUserId(null);
		dataSource1.setPassword(null);

		btnRefresh.setFont(new Font("仿宋_GB2312", 12.0f, FontSize.POINTS, FontWeight.NORMAL, true, false, false, CharacterSet.DEFAULT, 0));
		btnRefresh.setLocation(new Point(152, 16));
		btnRefresh.setSize(new Point(120, 32));
		btnRefresh.setTabIndex(0);
		btnRefresh.setText("刷新纪录");
		btnRefresh.addOnClick(new EventHandler(this.btnRefresh_Click));

		btnClose.setFont(new Font("仿宋_GB2312", 12.0f, FontSize.POINTS, FontWeight.NORMAL, true, false, false, CharacterSet.DEFAULT, 0));
		btnClose.setLocation(new Point(440, 16));
		btnClose.setSize(new Point(112, 30));
		btnClose.setTabIndex(1);
		btnClose.setText("关闭");
		btnClose.addOnClick(new EventHandler(this.btnClose_Click));

		panel1.setDock(ControlDock.BOTTOM);
		panel1.setLocation(new Point(0, 464));
		panel1.setSize(new Point(774, 64));
		panel1.setTabIndex(1);
		panel1.setText("");

		dataNavigator.setDock(ControlDock.BOTTOM);
		dataNavigator.setLocation(new Point(0, 528));
		dataNavigator.setSize(new Point(774, 20));
		dataNavigator.setTabIndex(2);
		dataNavigator.setTabStop(false);
		dataNavigator.setText("");
		dataNavigator.setDataMember("");
		dataNavigator.setDataSource(dataSource1);

		column1.setWidth(80);
		column1.setAlignment(ContentAlignment.MIDDLELEFT);
		column1.setBoundFieldName("供应商ID");
		column1.setCaption("供应商ID");
		column1.setIndex(0);

		column2.setWidth(200);
		column2.setAlignment(ContentAlignment.MIDDLELEFT);
		column2.setBoundFieldName("供应商名称");
		column2.setCaption("供应商名称");
		column2.setIndex(1);

		column3.setWidth(120);
		column3.setAlignment(ContentAlignment.MIDDLELEFT);
		column3.setBoundFieldName("联系人姓名");
		column3.setCaption("联系人姓名");
		column3.setIndex(2);

		column4.setWidth(200);
		column4.setAlignment(ContentAlignment.MIDDLELEFT);
		column4.setBoundFieldName("地址");
		column4.setCaption("地址");
		column4.setIndex(3);

		column5.setWidth(147);
		column5.setAlignment(ContentAlignment.MIDDLELEFT);
		column5.setBoundFieldName("邮政编码");
		column5.setCaption("邮政编码");
		column5.setIndex(4);

		dataGrid.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		dataGrid.setBackColor(Color.CYAN);
		dataGrid.setForeColor(new Color(64, 0, 0));
		dataGrid.setSize(new Point(774, 464));
		dataGrid.setTabIndex(0);
		dataGrid.setText("");
		dataGrid.setBorderStyle(BorderStyle.NONE);
		dataGrid.setCaption("");
		dataGrid.setColumns(new Column[] {
							column1, 
							column2, 
							column3, 
							column4, 
							column5});
		dataGrid.setDefaultColumnWidth(30);
		dataGrid.setGridLineStyle(GridLineStyle.RAISED3D);
		dataGrid.setHeaderFont(Font.DEFAULT_GUI);
		dataGrid.setSelectedBackColor(Color.DARKGRAY);
		dataGrid.setDynamicColumns(false);
		dataGrid.setDataMember("");
		dataGrid.setDataSource(dataSource1);

		splitter1.setDock(ControlDock.LEFT);
		splitter1.setSize(new Point(3, 64));
		splitter1.setTabIndex(2);
		splitter1.setTabStop(false);

		this.setNewControls(new Control[] {
							dataNavigator, 
							panel1, 
							dataGrid});
		panel1.setNewControls(new Control[] {
							  splitter1, 
							  btnRefresh, 
							  btnClose});

		dataSource1.begin();
	}
    //NOTE: End of form designer support code.

    /**
    * The main entry point for the application.
    *
    * @param args Array of parameters passed to the application
    * via the command line.
    */
    public static void main(String args[])
    {
        Application.run( new Form1() );
    }
}