calculate.java

完成课程设计

package 客房管理;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Calculate extends JFrame implements ActionListener 
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JLabel lNO,lKFNO,lNAME,lMONEY;
	JTextField tNO;
	JButton bCalculate;
	JPanel panelmain,panel1,panel2,panel3;
	
	public Calculate()
	{
		super("结账");
		lNO=new JLabel("客房号");
		lKFNO=new JLabel();
		lNAME=new JLabel();
		lMONEY=new JLabel();
		
		tNO=new JTextField(6);
		bCalculate=new JButton("计算");
		bCalculate.addActionListener(this);
		
		panelmain=new JPanel();
		
		panel1=new JPanel();
		panel1.add(lNO);
		panel1.add(tNO);
		
		panel2=new JPanel();
		panel2.add(bCalculate);
		
		panel3=new JPanel();
		panel3.add(lKFNO);
		panel3.add(lNAME);
		panel3.add(lMONEY);
		panel3.setLayout(new GridLayout(3,1,20,20));
		
		panelmain.add(panel1);
		panelmain.add(panel2);
		panelmain.add(panel3);
		this.setContentPane(panelmain);
		
		setBounds(500,300,200,250);
		setResizable(false);
		setVisible(true);
	}
	
	public void actionPerformed(ActionEvent ae) 
	{
		if(ae.getSource()==bCalculate)
		{
			Connection con;
			Statement stat;
			
			String a="update 金额_view set 需负金额=datediff(day,入住时间,getdate())*价格-押金 " +
					"where 客房编号="+"'"+tNO.getText()+"'"+"";
			String b="update 金额_view set 离店时间=dateadd(day,datediff(day,入住时间,getdate()),入住时间) " +
					"where 客房编号="+"'"+tNO.getText()+"'"+"";
			String c="select 客房编号,姓名,需负金额 from 金额_view " +
					"where 客房编号="+"'"+tNO.getText()+"'"+"";
			
			ResultSet rs;
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
				stat=con.createStatement();
				stat.executeUpdate(a);
				stat.executeUpdate(b);
				rs=stat.executeQuery(c);
				if(rs.next())
				{
					lKFNO.setText("客房编号:"+rs.getString("客房编号"));
					lNAME.setText("姓名:"+rs.getString("姓名"));
					lMONEY.setText("需负金额:"+rs.getString("需负金额"));
				}
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
		}
	}
	
	/*public static void main(String[] args)
	{
		new Calculate();
	}*/
}