form5.java

这是个使用.net技术开发的学校图书管理的系统

//Form5.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 Form5 extends Form
{

    public void btnAdd_Click(Object sender, Event evt)
    {
        try
        {
            dataSource1.getRecordset().cancelUpdate();
            dataSource1.getRecordset().addNew();
            m_bAddNew = true;
            btnDelete.setText ("&返回" );
            btnAdd.setEnabled( false );
            btnRefresh.setEnabled( false );
        }
        catch (Exception e)
        {
            handleADOException(e);
        }
    }

    public void btnDelete_Click(Object sender, Event evt)
    {
        try
        {
            if( m_bAddNew )
            {
                dataSource1.getRecordset().cancelUpdate();
                m_bAddNew = false;
                btnDelete.setText ("&删除" );
                btnRefresh.setEnabled( true );
                btnAdd.setEnabled( true );
            }
            else
            {
                dataSource1.getRecordset().delete(AdoEnums.Affect.CURRENT);
                if( !dataSource1.getRecordset().getEOF() )
                {
                    dataSource1.getRecordset().moveNext();
                    if( dataSource1.getRecordset().getEOF() )
                        dataSource1.getRecordset().movePrevious();
                }
            }
        }
        catch (Exception e)
        {
            handleADOException(e);
            dataSource1.getRecordset().cancelBatch();
        }
    }

    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 btnUpdate_Click(Object sender, Event evt)
    {
        try
        {
            this.setCursor( Cursor.WAIT );
            dataBinder1.commitChanges();
            dataSource1.getRecordset().update();

            if( m_bAddNew )
            {
                dataSource1.requery();
                
                dataSource1.getRecordset().moveLast();
            }
        }
        catch (Exception e)
        {
            handleADOException(e);
            if( m_bAddNew )
            {
                this.setCursor( Cursor.DEFAULT );
                return;
            }
            else
                dataSource1.getRecordset().cancelUpdate();
        }

        this.setCursor( Cursor.DEFAULT );
        m_bAddNew = false;
        btnDelete.setText ("&删除" );
        btnRefresh.setEnabled( true );
        btnAdd.setEnabled( true );
    }

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

    boolean    m_bAddNew;
    public void dispose()
    {
        super.dispose();
        components.dispose();
    }
	
    public Form5()
    {
        // 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(), "Form5" );
    }

	/**
	 * 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);
	DataBinder dataBinder1 = new DataBinder(components);
	Label label姓名 = new Label();
	Edit edit姓名 = new Edit();
	Label label读者借书证号 = new Label();
	Edit edit读者借书证号 = new Edit();
	Label label国籍 = new Label();
	Edit edit国籍 = new Edit();
	CheckBox chk借书情况 = new CheckBox();
	Label label出生地 = new Label();
	Edit edit出生地 = new Edit();
	Label label生日 = new Label();
	Edit edit生日 = new Edit();
	Label label附注 = new Label();
	Edit edit附注 = new Edit();
	Button btnAdd = new Button();
	Button btnDelete = new Button();
	Button btnRefresh = new Button();
	Button btnUpdate = new Button();
	Button btnClose = new Button();
	Panel panel1 = new Panel();
	DataNavigator dataNavigator = new DataNavigator();

	private void initForm()
	{
		this.setBackColor(Color.AQUA);
		this.setForeColor(new Color(0, 0, 128));
		this.setLocation(new Point(7, 7));
		this.setText("读者管理");
		this.setAutoScaleBaseSize(new Point(6, 12));
		this.setAutoScroll(true);
		this.setClientSize(new Point(420, 300));
		this.setStartPosition(FormStartPosition.CENTER_SCREEN);

		dataSource1.setConnectionString("Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\\My Documents\\db3.mdb");
		dataSource1.setCommandText("select 姓名, 读者借书证号, 国籍, 借书情况, 出生地, 生日, 附注 from 表2 ORDER by 读者借书证号");
		dataSource1.setSort(null);
		dataSource1.setStayInSync(true);
		dataSource1.setUserId(null);
		dataSource1.setPassword(null);

		label姓名.setBackColor(Color.CONTROL);
		label姓名.setLocation(new Point(10, 20));
		label姓名.setSize(new Point(100, 20));
		label姓名.setTabIndex(0);
		label姓名.setTabStop(false);
		label姓名.setText("姓名");

		edit姓名.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		edit姓名.setLocation(new Point(120, 20));
		edit姓名.setSize(new Point(280, 20));
		edit姓名.setTabIndex(1);
		edit姓名.setText("ww");
		edit姓名.setMaxLength(50);
		edit姓名.setMultiline(true);

		label读者借书证号.setBackColor(Color.CONTROL);
		label读者借书证号.setLocation(new Point(10, 50));
		label读者借书证号.setSize(new Point(100, 20));
		label读者借书证号.setTabIndex(2);
		label读者借书证号.setTabStop(false);
		label读者借书证号.setText("读者借书证号");

		edit读者借书证号.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		edit读者借书证号.setLocation(new Point(120, 50));
		edit读者借书证号.setSize(new Point(280, 20));
		edit读者借书证号.setTabIndex(3);
		edit读者借书证号.setText("12");
		edit读者借书证号.setMultiline(true);

		label国籍.setBackColor(Color.CONTROL);
		label国籍.setLocation(new Point(10, 80));
		label国籍.setSize(new Point(100, 20));
		label国籍.setTabIndex(4);
		label国籍.setTabStop(false);
		label国籍.setText("国籍");

		edit国籍.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		edit国籍.setLocation(new Point(120, 80));
		edit国籍.setSize(new Point(280, 20));
		edit国籍.setTabIndex(5);
		edit国籍.setText("ee");
		edit国籍.setMaxLength(50);
		edit国籍.setMultiline(true);

		chk借书情况.setBackColor(Color.CONTROL);
		chk借书情况.setLocation(new Point(10, 110));
		chk借书情况.setSize(new Point(120, 20));
		chk借书情况.setTabIndex(6);
		chk借书情况.setText("借书情况");
		chk借书情况.setTextAlign(LeftRightAlignment.LEFT);
		chk借书情况.setChecked(true);
		chk借书情况.setCheckState(CheckState.CHECKED);

		label出生地.setBackColor(Color.CONTROL);
		label出生地.setLocation(new Point(10, 140));
		label出生地.setSize(new Point(100, 20));
		label出生地.setTabIndex(7);
		label出生地.setTabStop(false);
		label出生地.setText("出生地");

		edit出生地.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		edit出生地.setLocation(new Point(120, 140));
		edit出生地.setSize(new Point(280, 20));
		edit出生地.setTabIndex(8);
		edit出生地.setText("sds");
		edit出生地.setMaxLength(50);
		edit出生地.setMultiline(true);

		label生日.setBackColor(Color.CONTROL);
		label生日.setLocation(new Point(10, 170));
		label生日.setSize(new Point(100, 20));
		label生日.setTabIndex(9);
		label生日.setTabStop(false);
		label生日.setText("生日");

		edit生日.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		edit生日.setLocation(new Point(120, 170));
		edit生日.setSize(new Point(280, 20));
		edit生日.setTabIndex(10);
		edit生日.setText("");
		edit生日.setMultiline(true);

		label附注.setBackColor(Color.CONTROL);
		label附注.setLocation(new Point(10, 200));
		label附注.setSize(new Point(100, 20));
		label附注.setTabIndex(11);
		label附注.setTabStop(false);
		label附注.setText("附注");

		edit附注.setAnchor(ControlAnchor.TOPLEFTRIGHT);
		edit附注.setLocation(new Point(120, 200));
		edit附注.setSize(new Point(280, 20));
		edit附注.setTabIndex(12);
		edit附注.setText("asa");
		edit附注.setMaxLength(1073741824);
		edit附注.setMultiline(true);
		edit附注.setScrollBars(ScrollBars.VERTICAL);

		dataBinder1.setDataSource(dataSource1);
		dataBinder1.setDataMember("");
		dataBinder1.setBindings(new DataBinding[] {
								new DataBinding(edit姓名, "Text", "姓名", null), 
								new DataBinding(edit读者借书证号, "Text", "读者借书证号", null), 
								new DataBinding(edit国籍, "Text", "国籍", null), 
								new DataBinding(chk借书情况, "Checked", "借书情况", null), 
								new DataBinding(edit出生地, "Text", "出生地", null), 
								new DataBinding(edit生日, "Text", "生日", null), 
								new DataBinding(edit附注, "Text", "附注", null)});
		/* @designTimeOnly dataBinder1.setLocation(new Point(96, 0)); */

		btnAdd.setLocation(new Point(8, 8));
		btnAdd.setSize(new Point(70, 30));
		btnAdd.setTabIndex(0);
		btnAdd.setText("&添加");
		btnAdd.addOnClick(new EventHandler(this.btnAdd_Click));

		btnDelete.setLocation(new Point(94, 8));
		btnDelete.setSize(new Point(70, 30));
		btnDelete.setTabIndex(1);
		btnDelete.setText("&删除");
		btnDelete.addOnClick(new EventHandler(this.btnDelete_Click));

		btnRefresh.setLocation(new Point(176, 8));
		btnRefresh.setSize(new Point(70, 30));
		btnRefresh.setTabIndex(2);
		btnRefresh.setText("&刷新纪录");
		btnRefresh.addOnClick(new EventHandler(this.btnRefresh_Click));

		btnUpdate.setLocation(new Point(258, 8));
		btnUpdate.setSize(new Point(70, 30));
		btnUpdate.setTabIndex(3);
		btnUpdate.setText("&更新");
		btnUpdate.addOnClick(new EventHandler(this.btnUpdate_Click));

		btnClose.setLocation(new Point(340, 8));
		btnClose.setSize(new Point(70, 30));
		btnClose.setTabIndex(4);
		btnClose.setText("&关闭");
		btnClose.addOnClick(new EventHandler(this.btnClose_Click));

		panel1.setDock(ControlDock.BOTTOM);
		panel1.setLocation(new Point(0, 230));
		panel1.setSize(new Point(420, 50));
		panel1.setTabIndex(13);
		panel1.setText("");

		dataNavigator.setDock(ControlDock.BOTTOM);
		dataNavigator.setLocation(new Point(0, 280));
		dataNavigator.setSize(new Point(420, 20));
		dataNavigator.setTabIndex(14);
		dataNavigator.setTabStop(false);
		dataNavigator.setText("");
		dataNavigator.setDataMember("");
		dataNavigator.setDataSource(dataSource1);

		this.setNewControls(new Control[] {
							dataNavigator, 
							panel1, 
							label姓名, 
							edit姓名, 
							label读者借书证号, 
							edit读者借书证号, 
							label国籍, 
							edit国籍, 
							chk借书情况, 
							label出生地, 
							edit出生地, 
							label生日, 
							edit生日, 
							label附注, 
							edit附注});
		panel1.setNewControls(new Control[] {
							  btnAdd, 
							  btnDelete, 
							  btnRefresh, 
							  btnUpdate, 
							  btnClose});

		dataSource1.begin();
		dataBinder1.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 Form5() );
    }
}