inputcase.java

医院管理系统 压缩包内有比较详尽的安装演示与功能介绍 大家可以放心下载

				    //rs=stmt.executeQuery("select docName from doctor");
				    conn.close();
				    }catch(SQLException ButtonEX){
				       System.out.println("Link Error");
				    }
				//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
				    textField_1.setText(""); 
				    textField_2.setText("");  
				    textField_3.setText(""); 
				    textField_4.setText(""); 
				    textField_5.setText(""); 
				    textField_6.setText(""); 
				    textField_7.setText(""); 
			}
		});
		button.setText("病例生成");
		add(button);
		springLayout.putConstraint(SpringLayout.SOUTH, textField_7, -5, SpringLayout.NORTH, button);
		springLayout.putConstraint(SpringLayout.NORTH, textField_7, 5, SpringLayout.SOUTH, label_7);
		springLayout.putConstraint(SpringLayout.EAST, button, 530, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, button, 435, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.SOUTH, button, 325, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, button, 295, SpringLayout.NORTH, this);

		final JLabel label_8 = new JLabel();
		label_8.setIcon(SwingResourceManager.getIcon(InputCase.class, "images/05072617061780503.jpg"));
		add(label_8);
		springLayout.putConstraint(SpringLayout.SOUTH, label_8, 315, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, label_8, 0, SpringLayout.SOUTH, label);
		springLayout.putConstraint(SpringLayout.EAST, label_8, 235, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, label_8, 30, SpringLayout.WEST, this);

		comboBox = new JComboBox();
		comboBox.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				String docNoTrim=null;
				String docNo=null;
			    ResultSet res=null;		
			    ResultSet resNum=null;  //记录当天医生开的第N个药单查询语句
			    int num=0;   //初始化记录当天医生开的第N个药单
			    String dateinsertdocNo=null;
			    Connection conndb=null;
				Calendar rightNow = Calendar.getInstance();
				int year=rightNow.get(Calendar.YEAR);
				int month=rightNow.get(Calendar.MONTH)+1;
				int day=rightNow.get(Calendar.DAY_OF_MONTH);
				String dateinsert=String.valueOf(year)+String.valueOf(month)+String.valueOf(day);
				JComboBox cb = (JComboBox) e.getSource();
				String docName = (String) cb.getSelectedItem();
				System.out.println("你选择了1"+docName);
				
				
				
				
				//----------------------------------------------------------
				try{
				    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				    }catch(Exception eX){
				    System.out.println("Not Found Driver!!!");
				    }
				    try{
				    conndb=DriverManager.getConnection("jdbc:odbc:Hospital","","");
				    Statement stmt=conndb.createStatement();
				    res=stmt.executeQuery("select docNo from doctor where docName='"+docName+"'");
				    while(res.next())
				    {
				    	 docNo=res.getString(1); //通过医生名取出医生的NO
				    }				    
				    docNoTrim=docNo.trim(); //去掉取出的空格
				    dateinsertdocNo =dateinsert +docNoTrim; 
				    System.out.println("excute resnum" + dateinsertdocNo);
				    resNum=stmt.executeQuery("select * from sickcase where caseID like '"+dateinsertdocNo+"%'");
				    while(resNum.next())
				    {
				    	System.out.println("Num++");
				    	num++;
				    }
				    num++;  //在原有数字上加一为新的记录ID
				    conndb.close();
				    }catch(SQLException eX){
				    	System.out.println("查找医生NO时出错");
				       System.out.println("Link Error");
				    }
				    //--------------------------------------------------------------
				    dateinsert=String.valueOf(year)+String.valueOf(month)+String.valueOf(day)+docNoTrim+String.valueOf(num);
				    textField_7.setText(dateinsert);
					textField_1.setText(String.valueOf(year)+"-"+String.valueOf(month)+"-"+String.valueOf(day));
					System.out.println("数据库中已有"+num);
				
				
			}
		});
		add(comboBox);
		springLayout.putConstraint(SpringLayout.EAST, comboBox, 375, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, comboBox, 0, SpringLayout.WEST, label);
		springLayout.putConstraint(SpringLayout.SOUTH, comboBox, 0, SpringLayout.SOUTH, textField_1);
		springLayout.putConstraint(SpringLayout.NORTH, comboBox, -25, SpringLayout.SOUTH, textField_1);

		ResultSet rs=null;
		Connection conn=null;
		try{
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		    }catch(Exception e){
		    System.out.println("Not Found Driver!!!");
		    }
		    try{
		    conn=DriverManager.getConnection("jdbc:odbc:Hospital","","");
		    Statement stmt=conn.createStatement();
		    rs=stmt.executeQuery("select docName from doctor");
		    while(rs.next())
		    {
		    	comboBox.addItem(rs.getString(1));
		    	//System.out.println(rs.getString(1));
		    }
		    conn.close();
		    }catch(SQLException e){
		       System.out.println("Link Error");
		       System.out.println("组合框添加项错误");
		    }

		final JScrollPane scrollPane = new JScrollPane();
		add(scrollPane);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane, 0, SpringLayout.NORTH, label_5);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane, 5, SpringLayout.SOUTH, label_2);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane, 0, SpringLayout.EAST, label_2);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane, 0, SpringLayout.WEST, label_2);

		textField_2 = new JTextArea();
		scrollPane.setViewportView(textField_2);

		final JScrollPane scrollPane_1 = new JScrollPane();
		add(scrollPane_1);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane_1, 0, SpringLayout.EAST, label_6);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane_1, 0, SpringLayout.WEST, label_4);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane_1, 240, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane_1, 5, SpringLayout.SOUTH, label_4);

		textField_4 = new JTextArea();
		scrollPane_1.setViewportView(textField_4);

		final JScrollPane scrollPane_2 = new JScrollPane();
		add(scrollPane_2);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane_2, 305, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane_2, 5, SpringLayout.SOUTH, label_6);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane_2, 0, SpringLayout.EAST, label_6);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane_2, 0, SpringLayout.WEST, label_6);

		textField_6 = new JTextArea();
		scrollPane_2.setViewportView(textField_6);
	}
	public boolean isHaveSickName(String 病人姓名)
	{
		ResultSet rs=null;
		Connection conn=null;
		int num=0;
		try{
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		    }catch(Exception e){
		    System.out.println("Not Found Driver!!!");
		    }
		    try{
		    conn=DriverManager.getConnection("jdbc:odbc:Hospital","","");
		    Statement stmt=conn.createStatement();
		    rs=stmt.executeQuery("select sickName from sick where sickName='"+病人姓名+"'");
		    while(rs.next())
		    {
		        num++;
		    }
		    conn.close();
		    }catch(SQLException e){
		       System.out.println("Link Error");
		       System.out.println("查询病人姓名时出错");
		    }
		if(num==0)
		{
			return false;
		}else
		{
			return true;
		}
	}
}