forfilm.java

一个非常不错的影碟管理系统

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import java.text.SimpleDateFormat;
import java.util.Date;
public class ForFilm extends JFrame implements ActionListener
{
	//**************                       影碟新加入
	JTextField numberField,nameField,manyField;
	JButton buttonEnter,buttonCancel;
	//**************                       影碟出租
	JButton buttonFind,buttonOut;
	//**************                       点击"出租"按钮，进入影碟出租页面
	//**************                       结帐
	JButton buttonEnd,buttonDelete;
	//**************                       //进入
	ChaZhao chaZhao=new ChaZhao();
	JFrame chaZhaoFrame=new JFrame();           // 进入查找界面
	ChuZhu chuZhu=new ChuZhu();
	JFrame chuZhuFrame=new JFrame();            // 进入出租界面
	JieZhang jieZhang=new JieZhang();
	JFrame jieZhangFrame=new JFrame();          // 进入结帐界面
	//**************                       数据库相关
	Connection con=null;
	Statement stmt=null;
	int Id=0;
	String Names="";
	int Numbers=0;
	String Times="";
	//**************
	public static void main(String[] args)
	{
		ForFilm frame=new ForFilm();
		frame.pack();
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		Dimension screenSize=Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize=frame.getSize();
		int x=(screenSize.width-frameSize.width)/2;
		int y=(screenSize.height-frameSize.height)/2;
		frame.setLocation(x,y);
		frame.setVisible(true);
	}
	public ForFilm()
	{
	    setTitle("影碟出租管理系统");
	    try
	    {
	    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }
	    catch(ClassNotFoundException e)
	    {
	    }
	    try
	    {
	    	con=DriverManager.getConnection("jdbc:odbc:XX","123","123");
	    	stmt=con.createStatement();
	    }
	    catch(SQLException e)
	    {
	    }
	    //************************************************影碟新加入
	    JPanel Panel1=new JPanel();
	    Panel1.setLayout(new GridLayout(3,1,3,3));
	    Panel1.add(new JLabel("编号:"));
	    Panel1.add(new JLabel("名称:"));
	    Panel1.add(new JLabel("数量"));
	    JPanel Panel2=new JPanel();
	    Panel2.setLayout(new GridLayout(3,1,3,3));
	    Panel2.add(numberField=new JTextField(4));
	    Panel2.add(nameField=new JTextField(20));
	    Panel2.add(manyField=new JTextField(4));
	    JPanel Panel3=new JPanel();
	    Panel3.add(buttonEnter=new JButton("录入"),BorderLayout.WEST);
	    Panel3.add(buttonCancel=new JButton("取消"),BorderLayout.EAST);
	    JPanel PanelIn=new JPanel();
	    PanelIn.setLayout(new BorderLayout(2,2));
	    PanelIn.add(Panel1,BorderLayout.WEST);
	    PanelIn.add(Panel2,BorderLayout.CENTER);
	    PanelIn.add(Panel3,BorderLayout.SOUTH);
	    PanelIn.setBorder(new TitledBorder("影碟新加入"));
	    //************************************************进入各项功能界面的按钮
	    JPanel buttonPanel=new JPanel();
	    buttonPanel.setLayout(new GridLayout(2,2,6,6));
	    buttonPanel.add(buttonFind=new JButton("查找"));
	    buttonPanel.add(buttonOut=new JButton("出租"));
	    buttonPanel.add(buttonEnd=new JButton("结帐"));
	    buttonPanel.add(buttonDelete=new JButton("消除"));
	    buttonPanel.setBorder(new TitledBorder("影碟出租"));
	    //************************************************
	    getContentPane().add(PanelIn,BorderLayout.WEST);
	    getContentPane().add(buttonPanel,BorderLayout.CENTER);
	    //************************************************查找页面的设置
	    chaZhaoFrame.getContentPane().add(chaZhao);
	    chaZhaoFrame.pack();
		chaZhaoFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		Dimension screenSize1=Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize1=chaZhaoFrame.getSize();
		int x1=(screenSize1.width-frameSize1.width)/2;
		int y1=(screenSize1.height-frameSize1.height)/2;
		chaZhaoFrame.setLocation(x1,y1);
		chaZhaoFrame.setVisible(false);
		//************************************************出租页面的设置
		chuZhuFrame.getContentPane().add(chuZhu);
	    chuZhuFrame.pack();
		chuZhuFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		Dimension screenSize2=Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize2=chaZhaoFrame.getSize();
		int x2=(screenSize2.width-frameSize2.width)/2;
		int y2=(screenSize2.height-frameSize2.height)/2;
		chuZhuFrame.setLocation(x2,y2);
		chuZhuFrame.setVisible(false);
		//************************************************结帐页面的设置
		jieZhangFrame.getContentPane().add(jieZhang);
	    jieZhangFrame.pack();
		jieZhangFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		Dimension screenSize3=Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize3=jieZhangFrame.getSize();
		int x3=(screenSize3.width-frameSize3.width)/2;
		int y3=(screenSize3.height-frameSize3.height)/2;
		jieZhangFrame.setLocation(x3,y3);
		jieZhangFrame.setVisible(false);
	    buttonEnter.addActionListener(this);
	    buttonCancel.addActionListener(this);
	    buttonFind.addActionListener(this);
	    buttonOut.addActionListener(this);
	    buttonEnd.addActionListener(this);
	    buttonDelete.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==buttonEnter)
		{
			try
			{
				tianJia();
			}
			catch(SQLException ee)
			{
				System.out.println("录入失败，数据库中已有此碟!");
			}
		}
		else if(e.getSource()==buttonCancel)
		{
			try
			{
				tuiChu();
			}
			catch(SQLException ee)
			{
			}
		}
		else if(e.getSource()==buttonFind)
		{
			System.out.println ("asffsafas");
			chaZhaoFrame.setVisible(true);
		}
		else if(e.getSource()==buttonOut)
		{
			chuZhuFrame.setVisible(true);
		}
		else if(e.getSource()==buttonEnd)
		{
			jieZhangFrame.setVisible(true);
		}
		else if(e.getSource()==buttonDelete)
		{
			qingChu();	
		}
	}
	public void tianJia() throws SQLException
	{
		Id=Integer.parseInt(numberField.getText().trim());
		Names="'"+nameField.getText().trim()+"'";
		Numbers=Integer.parseInt(manyField.getText().trim());
		Times="'"+gettime()+"'";
	    con=DriverManager.getConnection("jdbc:odbc:XX","123","123");
		stmt = con.createStatement();
		String temp="INSERT INTO Film VALUES("+Id+","+Names+","+Numbers+","+Times+")";
		System.out.println (temp);
		stmt.executeUpdate(temp);
		con.close();
	}
	public void tuiChu() throws SQLException
	{
		System.exit(0);
	}
	public String gettime()   
    { 
          String datestr="";     
          try
          {   
          SimpleDateFormat df=new SimpleDateFormat("yyyy年MM月dd日HH点ss分");   
          Date date=new Date();   
          datestr=df.format(date);   
          }   
          catch(Exception ex)
          {   
          }
          return datestr;
    }
    public void qingChu()
	{
		numberField.setText(null);
		nameField.setText(null);
		manyField.setText(null);
	}
}
class ChaZhao extends JPanel implements ActionListener
{
	JTextField numberField,nameField,outField;
	JButton buttonFind;
	Connection con=null;
	Statement stmt=null;
	int Id=0;
	String Names="";
	int Numbers=0;
	String Times="";
	public ChaZhao()
	{
		JPanel Panel1=new JPanel();
		Panel1.setLayout(new GridLayout(3,1,3,3));
		Panel1.add(new JLabel("编号:"));
		Panel1.add(new JLabel("名称:"));
		Panel1.add(new JLabel("查找情况"));
		JPanel Panel2=new JPanel();
		Panel2.setLayout(new GridLayout(3,1,3,3));
		Panel2.add(numberField=new JTextField(4));
		Panel2.add(nameField=new JTextField(20));
		Panel2.add(outField=new JTextField(20));
		outField.setEditable(false);
		JPanel Panel12=new JPanel();
		Panel12.setLayout(new GridLayout(1,2,3,3));
		Panel12.add(Panel1);
		Panel12.add(Panel2);
		JPanel Panel3=new JPanel();
		Panel3.add(buttonFind=new JButton("查找"),BorderLayout.WEST);
		add(Panel12,BorderLayout.CENTER);
		add(Panel3,BorderLayout.SOUTH);
		buttonFind.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==buttonFind)
		{
			try
			{
			cZhao();
			}
			catch(SQLException ee)
			{
			}
		}
	}
	public void cZhao() throws SQLException
	{
			Id=Integer.parseInt(numberField.getText().trim());
			String temp="SELECT name,number FROM Film WHERE id ="+Id;
			System.out.println (temp);
	    	con=DriverManager.getConnection("jdbc:odbc:XX","123","123");
			stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(temp);
			if(rs.next())
			{
				Numbers=Integer.parseInt(rs.getString("number"));
				if(Numbers>=1)
				{
				nameField.setText(rs.getString("name"));
				outField.setText("现在此影碟数量为"+Numbers+"个");
				}	
			}
			else
			{
				nameField.setText("此影碟暂时在借,没有存货");
				outField.setText(null);
			}
			con.close();
	}
}
class ChuZhu extends JPanel implements ActionListener               //出租功能
{
	JTextField numberField,nameField,outField,timeField;
	JButton buttonChuZhu,buttonTianJia;
	Connection con=null;
	Statement stmt=null;
	int Id=0;
	int UserNumber=0;
	String FilmName="";
	int Numbers=0;
	String ChuZhuTime="";
	int Money=0;
	public ChuZhu()
	{
		try
	    {
	    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }
	    catch(ClassNotFoundException e)
	    {
	    }
	    try
	    {
	    	con=DriverManager.getConnection("jdbc:odbc:XX","123","123");
	    	stmt=con.createStatement();
	    }
	    catch(SQLException e)
	    {
	    }
	    JPanel Panel1=new JPanel();
		Panel1.setLayout(new GridLayout(4,1,3,3));
		Panel1.add(new JLabel("顾客编号:"));
		Panel1.add(new JLabel("影碟编号:"));
		Panel1.add(new JLabel("影碟名称:"));
		Panel1.add(new JLabel("出租时间:"));
		JPanel Panel2=new JPanel();
		Panel2.setLayout(new GridLayout(4,1,3,3));
		Panel2.add(numberField=new JTextField(4));
		Panel2.add(nameField=new JTextField(20));
		Panel2.add(outField=new JTextField(20));
		Panel2.add(timeField=new JTextField(20));
		outField.setEditable(false);
		timeField.setEditable(false);
		JPanel Panel12=new JPanel();
		Panel12.setLayout(new GridLayout(1,2,3,3));
		Panel12.add(Panel1);
		Panel12.add(Panel2);
		JPanel Panel3=new JPanel();
		Panel3.add(buttonTianJia=new JButton("顾客编号"),BorderLayout.WEST);
		Panel3.add(buttonChuZhu=new JButton("出租影碟"),BorderLayout.CENTER);
		add(Panel12,BorderLayout.CENTER);
		add(Panel3,BorderLayout.SOUTH);
		buttonTianJia.addActionListener(this);
		buttonChuZhu.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
		
		if(e.getSource()==buttonTianJia)
		{
			try
			{
				cZhu();	
			}
			catch(SQLException ee)
			{
				ee.printStackTrace();
			}
		}
		else if(e.getSource()==buttonChuZhu)
		{
			try
			{
				cZhuOut();	
			}
			catch(SQLException ee)
			{
				ee.printStackTrace();
			}
		}
	}
	public void cZhu() throws SQLException
	{
		UserNumber=Integer.parseInt(numberField.getText().trim());
		con=DriverManager.getConnection("jdbc:odbc:XX","123","123");
		stmt = con.createStatement();
		String temp="INSERT INTO User VALUES("+UserNumber+ ")";
		System.out.println (temp);	
		stmt.executeUpdate(temp);
		con.close();
	}
	
	public void cZhuOut() throws SQLException
	{
		System.out.println ("dfdd");
		UserNumber=Integer.parseInt(numberField.getText().trim());
		
		
		Id=Integer.parseInt(nameField.getText().trim());
		System.out.println(Id);
		System.out.println(getTime());
		ChuZhuTime=getTime();
		timeField.setText(ChuZhuTime);
		con=DriverManager.getConnection("jdbc:odbc:XX","123","123");
		stmt = con.createStatement();
		String temp="select name,number from Film where id="+Id;
		ResultSet rs=stmt.executeQuery(temp);
		if(rs.next())
		{
		Numbers=Integer.parseInt(rs.getString("number"));
		String temp1=(rs.getString("name"));
		temp="INSERT INTO UserChuZhu(usernumber,filmname,chuzhutime,moneys) VALUES("+UserNumber+",'"+temp1+"','"+ChuZhuTime+"',"+Money+")";
		outField.setText(temp1);
		stmt.executeUpdate(temp);
		con.close();
		}
		else
			System.out.println ("asdfasfddfs");
	}
	public String getTime()  
    { 
          String datestr="";     
          try
          {   
          java.text.SimpleDateFormat df=new java.text.SimpleDateFormat("yyyy年MM月dd日HH点ss分");   
          java.util.Date date=new java.util.Date();   
          datestr=df.format(new java.util.Date());   
          }   
          catch(Exception ex)
          {   
          }
          return datestr;
    }
}
class JieZhang extends JPanel implements ActionListener
{
	int UserNumber;
	String FilmName="";
	int Money=0;
	JTextField userField,moneyField;
	JComboBox filmBox;
	JButton jieZhangButton;
	public JieZhang()
	{
		JPanel Panel1=new JPanel();
		Panel1.setLayout(new GridLayout(3,1,3,3));
	    Panel1.add(new JLabel("用户编号:"));
	    Panel1.add(new JLabel("所租影碟:"));
	    Panel1.add(new JLabel("应收租金:"));
	    JPanel Panel2=new JPanel();
	    Panel2.setLayout(new GridLayout(3,1,3,3));
	    Panel2.add(userField=new JTextField(4));
	    Panel2.add(filmBox=new JComboBox());
	    Panel2.add(moneyField=new JTextField(20));
	    JPanel Panel3=new JPanel();
	    Panel3.setLayout(new GridLayout(1,2,6,6));
	    Panel3.add(Panel1);
	    Panel3.add(Panel2);
	    JPanel Panel4=new JPanel();
	    Panel4.add(jieZhangButton=new JButton("结帐"));
	    add(Panel3,BorderLayout.WEST);
	    add(Panel4,BorderLayout.CENTER);
	    jieZhangButton.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
	}
}