runframe.java

一个用于实现不同数据库数据同步的程序

	catch(Exception e){}

	jTextArea1.append("\n记录存放目录:\t"+txtAddress+"\n");
	tempPanel.add(jTextArea1);

    }


	void jMenuInquirePeopleInfor_actionPerformed(ActionEvent actionEvent) {

		tempPanel.removeAll();this.repaint();
		System.gc();
		tempPanel = (JPanel) getContentPane();
		tempPanel.setLayout(null);
		tempPanel.setSize(800, 600);

		JLabel jLabel1 = new JLabel();
		jLabel1.setSize(750,15); 
		jLabel1.setLocation(45,25);
		jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
		jLabel1.setText("选择并输入查询条件：");

		String [] ary ={"学号","姓名","性别"}; 
		jComboBox1 = new JComboBox(ary);
		jComboBox1.setSize(100,20); 
		jComboBox1.setLocation(45,50);
		jComboBox1.setBackground(Color.white);
		jComboBox1.setBorder(border1);
		jComboBox1.setAutoscrolls(true);
		jComboBox1.addItemListener(new runFrame_jMenuInquirePIchange_ActionAdapter(this));

		String [] ary3 ={"    男","    女"}; 
		jComboBox3 = new JComboBox(ary3);
		jComboBox3.setSize(350,20); 
		jComboBox3.setLocation(170,50);
		jComboBox3.setBackground(Color.white);
		jComboBox3.setBorder(border1);
		jComboBox3.setAutoscrolls(true);
		jComboBox3.setVisible(false);

		jTextField1 = new JTextField();
		jTextField1.setSize(350,20); 
		jTextField1.setLocation(170,50);
		jTextField1.setVisible(true);

		JButton jButton1 = new JButton();
		jButton1.setSize(100, 23);
		jButton1.setLocation(650, 510);
		jButton1.setText("确认查找");
		jButton1.addActionListener(new runFrame_jMenuInquirePIbutton_ActionAdapter(this));

		JButton jButton2 = new JButton();
		jButton2.setSize(100, 23);
		jButton2.setLocation(525, 510);
		jButton2.setText("重新输入");
		jButton2.addActionListener(new runFrame_jMenuInquirePIbutton2_ActionAdapter(this));

		String []ary2 ={"添加查询条件","  交  集","  并  集"}; 
		jComboBox2 = new JComboBox(ary2);
		jComboBox2.setSize(100,20); 
		jComboBox2.setLocation(555, 50);
		jComboBox2.setBackground(SystemColor.control);
		jComboBox2.setBorder(BorderFactory.createRaisedBevelBorder());
		jComboBox2.addItemListener(new runFrame_jMenuInquirePIAdd_ActionAdapter(this));
		jComboBox2.setAutoscrolls(true);

		jTextArea1 = new JTextArea();
		jTextArea1.setBackground(SystemColor.control);
		jTextArea1.setBorder(BorderFactory.createEmptyBorder());
		jTextArea1.setSize(600,300);
		jTextArea1.setLocation(35,80);
		jTextArea1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
		jTextArea1.setEditable(false);

		tempPanel.add(jLabel1);
		tempPanel.add(jComboBox1);
		tempPanel.add(jComboBox3);
		tempPanel.add(jTextField1);
		tempPanel.add(jButton1);
		tempPanel.add(jButton2);
		tempPanel.add(jComboBox2);
		tempPanel.add(jTextArea1);
	}

	void jMenuInquirePIbutton_actionPerformed(ActionEvent actionEvent)
	{
		String s1=jComboBox1.getSelectedItem().toString();
		String s2="";
		int i=0;
		i=jComboBox1.getSelectedIndex();
		if(i==0)
		{
			s1="SNAME";
			s2=jTextField1.getText();
		}
		else
		{
			if(i==1)
			{
				s1="SNUMBER";
				s2=jTextField1.getText();
			}
			else
			{
				if(i==2)
				{
					s1="SSEX";
					s2=jComboBox3.getSelectedItem().toString();
				}
			}
		}
		jTextArea1.append(s1+"="+s2);
		s1=jTextArea1.getText();
		sendCollectAsk(s1);

		FrameWaitingBox dlg = new FrameWaitingBox(this);
       		 Dimension dlgSize = dlg.getPreferredSize();
       	 Dimension frmSize = getSize();
       	 Point loc = getLocation();
        dlg.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x,
                        (frmSize.height - dlgSize.height) / 2 + loc.y);
        dlg.setModal(true);
        dlg.pack();
        dlg.setVisible(true);
		
	}

	void jMenuInquirePIbutton2_actionPerformed(ActionEvent actionEvent) {
		jComboBox1.setSelectedIndex(0);
		jTextField1.setText("");
		jTextArea1.setText("");
	}

	void jMenuInquirePIAdd_actionPerformed(ItemEvent actionEvent)
	{
		String s1=jComboBox1.getSelectedItem().toString();
		String s2="";
		int i=0;
		if(actionEvent.getStateChange() == ItemEvent.SELECTED)
		{ 
			i=jComboBox1.getSelectedIndex();
			if(i==0)
			{
				s1="SNAME";
				s2=jTextField1.getText();
			}
			else
			{
				if(i==1)
				{
					s1="SNUMBER";
					s2=jTextField1.getText();
				}
				else
				{
					if(i==2)
					{
						s1="SSEX";
						s2=jComboBox3.getSelectedItem().toString();
					}
				}
			}

			i=jComboBox2.getSelectedIndex();
			if(i==1)
			{
				jTextArea1.append(s1+"="+s2);
				jTextArea1.append("\n&&\n");
			}
			else
			{
				if(i==2)
				{
					jTextArea1.append(s1+"="+s2);
					jTextArea1.append("\n||\n");
				}
			}
			jComboBox2.setSelectedIndex(0);
		}
	}

	void jMenuInquirePIchange_actionPerformed(ItemEvent actionEvent)
	{
		if(actionEvent.getStateChange() == ItemEvent.SELECTED)
		{ 
			int i=jComboBox1.getSelectedIndex();

			if(i==2)
			{
				jTextField1.setVisible(false);
				jComboBox3.setVisible(true);
			}
			else
			{
				jTextField1.setVisible(true);
				jComboBox3.setVisible(false);
			}
		}
	}

    void jMenuHelpAbout_actionPerformed(ActionEvent actionEvent) {
        Frame1_AboutBox dlg = new Frame1_AboutBox(this);
        Dimension dlgSize = dlg.getPreferredSize();
        Dimension frmSize = getSize();
        Point loc = getLocation();
        dlg.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x,
                        (frmSize.height - dlgSize.height) / 2 + loc.y);
        dlg.setModal(true);
        dlg.pack();
        dlg.setVisible(true);
    }

	public void sendCollectAsk(String ms)
	{
		String s="",mesg="",temp="",wMesg="",sMesg="";
		mesg=ms;
		int start=0,mid=0;
		dealMessage cutingMessage=new dealMessage();

		getUpdateTime gut=new getUpdateTime();
		String sTime=gut.getSystemTime();

		writeText writeMissionManage=new writeText(databaseName,txtAddress,"MissionManageTemp.txt");

		try
		{
		//writeMissionManage.writingMission("Search\t"+sTime+"\t0");
		//writeMissionManage.writingMission("------------------------------------------");
		}catch(Exception e){}
		
		mesg=mesg.replace("\n","\t");
		while(true)
		{	
			start=0;
			mid=mesg.indexOf("\t");
			if(mid!=-1)
			{
				s=cutingMessage.cutMessage(mesg,start,mid);
			}
			else
			{
				s=mesg;
			}

			mid=s.indexOf("=");
			if(mid!=-1)
			{
				sMesg+=s;
				/*s=s.replace("=","\t");mid=s.indexOf("\t");
				start=0;
				temp=cutingMessage.cutMessage(s,start,mid);
				wMesg+=temp+"\t";
				start=mid;
				mid=s.length();
				temp=cutingMessage.cutMessage(s,start,mid);
				wMesg+=temp;*/
			}
			else
			{
				sMesg+="\t"+s.trim()+"\t";
				//wMesg+="\t"+s.trim()+"\t";
			}

			start=mesg.indexOf("\t");
			if(start!=-1)
			{
				mid=mesg.length();
				mesg=cutingMessage.cutMessage(mesg,start,mid);
			}
			else
			{
				break;
			}	
		}

		try
		{
			//writeMissionManage.insertWriting(sMesg,sTime);

			sqlOperation so=new sqlOperation();
			ResultSet rs=null;
			rs=so.ResultSetFromDB("select * from DBINFORMATION where STATE=0");
			sendBySocket sendmesg=new sendBySocket(databaseName,txtAddress);

			Random random;
			String pno="";

			while(rs.next())
			{
				s=rs.getString("DBNAME");

				random = new Random();
				pno=""+Math.abs(random.nextInt())%10000;

				//writeMissionManage.insertWriting("\t"+pno+"\t"+s+"\t0",sTime);
				sendmesg.sendSingleMessage(s,"search\t"+pno+"\t"+databaseName+"\t"+sMesg);
			}
		}
		catch(Exception e){}
	}
}