adddebt.java

培训时做的学生管理系统.基于J2SE平台开发

package cn.com.studentsystem.debt;

import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.swing.BorderFactory;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JSplitPane;
import javax.swing.JTextField;

import cn.com.studentsystem.log.Log;
import cn.com.util.DBConnection;
import cn.com.util.studentsystemcommon.JDatePicker;

public class AddDebt {
	JFrame jf;
	JDatePicker date_text;
	JTextField number_text;
	JComboBox io_box;
	JComboBox money_type ;
	JTextField money_text;
	JTextField reason_text;
	JTextField manager_text;
	JButton add_button;
	JButton cancel_button;
	JOptionPane jop = new JOptionPane();
	public AddDebt(){
		
		init();
	}
	
	public void init(){
		
	    jf = new JFrame("账务单据");
		jf.setSize(480,430);
		jf.setLocationRelativeTo(null);
	    BorderLayout border = new BorderLayout();
	    FlowLayout flow = new FlowLayout(FlowLayout.CENTER,50,50);
		GridLayout grid = new GridLayout(5,1,10,10);
		ImageIcon i = new ImageIcon("image//title.png");
		jf.setIconImage(i.getImage());
		
		JSplitPane slipt_pane = new JSplitPane();
		JPanel up_pane = new JPanel();
		JPanel left_pane = new JPanel();
		JPanel right_pane = new JPanel();
		JPanel all_pane = new JPanel();
		
		up_pane.setBorder(BorderFactory.createTitledBorder("时间日期"));
		left_pane.setBorder(BorderFactory.createTitledBorder("款项条目"));
		right_pane.setBorder(BorderFactory.createTitledBorder("货币形式"));
		
		left_pane.setLayout(flow);
		right_pane.setLayout(flow);
		all_pane.setLayout(border);
		
		JLabel date_label = new JLabel("时间日期");
		date_text  = new JDatePicker();
		
		JLabel io_label = new JLabel("收支选择");
		io_box = new JComboBox();
		io_box.addItem("收入款");
		io_box.addItem("支出款");
		JLabel number_label = new JLabel("款项条数");
		number_text = new JTextField(10);
		
		JLabel left_label = new JLabel("货币类型");
		money_type = new JComboBox();
		money_type.addItem("RMB￥");
		money_type.addItem("HK$");
		money_type.addItem("美元$");
		money_type.addItem("台币");
		
		JLabel money_label = new JLabel("收支金额");
		money_text = new JTextField(10);
		
		JLabel reason_label = new JLabel("收支缘由");
		reason_text = new JTextField(10);
		
		JLabel  manager_label = new JLabel("负责人员");
		manager_text = new JTextField(10);
		
		add_button = new JButton("添加");
		cancel_button = new JButton("取消");
		
		up_pane.add(date_label);
		up_pane.add(date_text);
		
		left_pane.add(number_label);
		left_pane.add(number_text);
		left_pane.add(io_label);
		left_pane.add(io_box);
		left_pane.add(manager_label);
		left_pane.add(manager_text);
		left_pane.add(add_button);
		
		right_pane.add(left_label);
		right_pane.add(money_type);
	    right_pane.add(money_label);
		right_pane.add(money_text);
		right_pane.add(reason_label);
		right_pane.add(reason_text);
		right_pane.add(cancel_button);
		
		slipt_pane.setLeftComponent(left_pane);
		slipt_pane.setRightComponent(right_pane);
		slipt_pane.setAutoscrolls(true);
		slipt_pane.setDividerSize(2);
		slipt_pane.setDividerLocation(230);
		all_pane.add(up_pane,"North");
		all_pane.add(slipt_pane,"Center");
		
		jf.add(all_pane);
		
		class AddDebtAction implements ActionListener{

			public void actionPerformed(ActionEvent arg0) {
				// TODO Auto-generated method stub
				if(arg0.getActionCommand().equals("添加")){
					File file = new File("logdiary.txt");
					PrintWriter pw = null;
					try {
						 pw = new PrintWriter(new FileWriter(file,true),true);
					} catch (IOException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					Log.log("AddDebt的添加按钮", pw, "将新纪录插入数据库和JTable");
					
					Connection con = DBConnection.getConnectionOracle();
//					
					/** 
					 * 此处新加了正则表达式进行匹配
					 */
					  Pattern pattern = Pattern.compile("[0-9]+[.]?+[0-9]*") ;
					  Matcher matcher = pattern.matcher(money_text.getText().toString());
					  if(matcher.matches()){
					  try {
							PreparedStatement ps = con.prepareStatement("insert into debt values(?,?,?,?,?,?,?)");
					        ps.setInt(1,Integer.parseInt(number_text.getText().toString()) );
						    ps.setString(2, date_text.getSelectedItem().toString().substring(0, 10));
						    ps.setString(3, money_type.getSelectedItem().toString());
						    ps.setString(4, io_box.getSelectedItem().toString());//由原来的整数型转换成String类型
						    ps.setString(5, money_text.getText().toString());
						    ps.setString(6, manager_text.getText().toString());
						    ps.setString(7, reason_text.getText().toString());
						    ps.executeUpdate();
						    
                           int rows = Debt.table_model.getRowCount();
						    for(int i =rows-1;i>=0;i--){
						    	Debt.table_model.removeRow(i);
						    	
						    }
						    
					         Object[] obj = {number_text.getText().toString(), date_text.getSelectedItem().toString().substring(0, 10),
						                    money_type.getSelectedItem().toString(),io_box.getSelectedItem().toString(),money_text.getText().toString(),
						                    manager_text.getText().toString(),reason_text.getText().toString()};
						  
						  
						    Debt.table_model.addRow(obj);
						    jop.showMessageDialog(null, "添加账务成功", "账单业务提示", jop.INFORMATION_MESSAGE);
						     jf.dispose();
						
						} catch (SQLException e) {
							jop.showMessageDialog(null, "该记录已存在");
					   } catch(NumberFormatException e){
						   jop.showMessageDialog(null, "你输出的不是数字，请输入数字");
					   }	
					   
					     }else{
					    	 jop.showMessageDialog(null, "你输出的数值不匹配");
						   
					     }		
					
			  }
					else if(arg0.getActionCommand().equals("取消")){
					File file = new File("logdiary.txt");
					PrintWriter pw = null;
					try {
						 pw = new PrintWriter(new FileWriter(file,true),true);
					} catch (IOException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					Log.log("AddDebt的取消按钮", pw, "取消将数据插入数据库和JTable的操作");
					
					jf.dispose();
				}
				
			}
			
		}
		
		AddDebtAction adddebt_action = new AddDebtAction();
		cancel_button.addActionListener(adddebt_action);
		add_button.addActionListener(adddebt_action);
	    jf.setVisible(true);
		
	}

}