nextsecond.java

GUI银行管理系统,包括一系列的用户操作功能

package denglu;
import java.awt.Button;
import java.awt.Color;
import java.awt.Graphics;
import java.awt.Label;
import java.awt.MediaTracker;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;

public class NextSecond extends JPanel{
		JFrame aFrame ;
		private JLabel label_showbottom;
		private JLabel label_showhigh;
		private int total= 0;
		private boolean flagenter;
		GetSystemDate GSD = new GetSystemDate();
		Label gge[] = new Label[8];
		private Button button_exit;
		private Button button_back;
		private Button getButton_exit() {
			button_exit = new Button("取卡");
			button_exit.setBounds(30, 420, 60, 30);
			button_exit.setBackground(Color.cyan);
			button_exit.addActionListener(new ActionListener(){
				public void actionPerformed(ActionEvent e) {
					aFrame.dispose();
				}				
			});
			return button_exit;
		}
		private Button getButton_back() {
			if(flagenter)
			{
				button_back = new Button("下一页");
				button_back.setBounds(610, 420, 60, 30);
				button_back.setBackground(Color.cyan);
				button_back.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent e) {
						aFrame.dispose();
						new NextSecond();
					}
				});
			}else{
				button_back = new Button("返回");
				button_back.setBounds(610, 420, 60, 30);
				button_back.setBackground(Color.cyan);
				button_back.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent e) {
						FirstAwt FWT = new FirstAwt();
						aFrame.dispose();
					}					
				});
			}
			return button_back;
		}
		private JLabel getLabel_showbottom() {
			if(FirstAwt.Flag==100)
			{
				label_showbottom = new JLabel("谢谢使用，这是你第"+(FirstAwt.Next_month)+"月的使用记录！");
			}
			else
			{
				label_showbottom = new JLabel("谢谢使用，这是你第"+(GSD.SystemMonth-FirstAwt.Flag)+"月的使用记录！");
			}
			label_showbottom.setBounds(260,20, 200, 40);
			return label_showbottom;
		}
		private JLabel getLabel_showhigh() {
			label_showhigh = new JLabel("中国成都大学银行,版权所有！");
			//label_showhigh.setText("中国成都大学银行,版权所有！");
			label_showhigh.setBackground(Color.white);
			label_showhigh.setBounds(260, 400, 200, 40);
			return label_showhigh;
		}
		NextSecond()
		{
			aFrame = new JFrame("查询");
			InitNextSecond();
			aFrame.setVisible(true);
			aFrame.setBackground(Color.gray);
			aFrame.validate();
			aFrame.setBounds(200, 100, 700, 500);
		}
		private void InitNextSecond()
		{
			aFrame.add(getLabel_showhigh());
			aFrame.add(getLabel_showbottom());
			addarrary();
			addLabel();
			aFrame.add(getButton_exit());
			aFrame.add(getButton_back());
			aFrame.setLayout(null);
		}
		public void addarrary()
		{
			for (int i = 0 ; i<=7; ++i)
			{
				gge[i]= new Label();
				switch(i)
				{
					case 0:
						gge[i].setBounds(20, 80,50,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("存款");
						aFrame.add(gge[i]);
						break;
					case 1:
						gge[i].setBounds(90, 80,50,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("取款");
						aFrame.add(gge[i]);
						break;
					case 2:
						gge[i].setBounds(160, 80,50,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("是否转帐");
						aFrame.add(gge[i]);
						break;
					case 3:
						gge[i].setBounds(230, 80,50,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("修改密码");
						aFrame.add(gge[i]);
						break;
					case 4:
						gge[i].setBounds(330, 80,70,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("登录时间");
						aFrame.add(gge[i]);
						break;
					case 5:
						gge[i].setBounds(460, 80,70,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("用户帐号");
						aFrame.add(gge[i]);
						break;
					case 6:
						gge[i].setBounds(540, 80,70,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("查询现金");
						aFrame.add(gge[i]);
						break;
					case 7:
						gge[i].setBounds(620, 80,60,16);
						gge[i].setBackground(Color.white);
						gge[i].setText("转帐金额");
						aFrame.add(gge[i]);
						break;					
				}
			}
		}
		public void addLabel()
		{
			switch(FirstAwt.Flag)
			{
				case 0:
				{
					GSD.SystemMonth= GSD.SystemMonth-FirstAwt.Flag;
					break;
				}
				case 1:
				{
					GSD.SystemMonth= GSD.SystemMonth-FirstAwt.Flag;
					break;
				}
				case 2:
				{
					GSD.SystemMonth= GSD.SystemMonth-FirstAwt.Flag;
					break;
				}
				case 100:
				{
					GSD.SystemMonth = FirstAwt.Next_month;
					GSD.SystemYear = FirstAwt.Next_year;
					break;
				}
				default :System.out.println("FirsAwt is unknow error!");
			}
			try{
					String id=Login1.sqlusername;
					String sql = "SELECT *FROM AceessNoteTable " +
					"WHERE (ActionDate BETWEEN '"+GSD.SystemYear+"-"+GSD.SystemMonth+"-01'" +
					"AND '"+GSD.SystemYear+"-"+GSD.SystemMonth+"-29')AND CustomalID='"+id+"'order by ActionDate";
					LinkDataBast getData = new LinkDataBast (sql);
					int kee =0;
					new Acesstotal();
					if(Acesstotal.fangwen>1)
					{
						getData.rs.relative(17*Acesstotal.fangwen-1);
					}
					do
					{
						flagenter=getData.rs.next();
						for(int i=0;i<=7;++i)
						{	
							gge[i]= new Label();
							switch(i)
							{
								case 0:
									gge[i].setBounds(20,17*kee+100,50,16);
									gge[i].setBackground(Color.yellow);
									aFrame.add(gge[i]);
									gge[i].setText(getData.rs.getString(i+1));
									break;
								case 1:
									gge[i].setBounds(90,17*kee+100,50,16);
									gge[i].setBackground(Color.cyan);
									aFrame.add(gge[i]);
									gge[i].setText(getData.rs.getString(i+1));
									break;
								case 2:
									gge[i].setBounds(160,17*kee+100,50,16);
									gge[i].setBackground(Color.yellow);
									aFrame.add(gge[i]);
									if(getData.rs.getString(i+1).equalsIgnoreCase("0"))
									{
										gge[i].setText("NO");
									}
									else{
											gge[i].setText("YES");
										}
									break;
								case 3:
									gge[i].setBounds(230,17*kee+100,50,16);
									gge[i].setBackground(Color.cyan);
									aFrame.add(gge[i]);
									if(getData.rs.getString(i+1).equalsIgnoreCase("0"))
									{
										gge[i].setText("NO");
									}
									else{
											gge[i].setText("YES");
										}
									break;
								case 4:
									gge[i].setBounds(300,17*kee+100,140,16);
									gge[i].setBackground(Color.yellow);
									aFrame.add(gge[i]);
									gge[i].setText(getData.rs.getString(i+1));
									break;
								case 5:
									gge[i].setBounds(460,17*kee+100,70,16);
									gge[i].setBackground(Color.cyan);
									aFrame.add(gge[i]);
									gge[i].setText(getData.rs.getString(i+1));
									break;
								case 6:
									gge[i].setBounds(540,17*kee+100,70,16);
									gge[i].setBackground(Color.yellow);
									aFrame.add(gge[i]);
									if(getData.rs.getString(i+1).equalsIgnoreCase("0"))
									{
										gge[i].setText("NO");
									}
									else{
											gge[i].setText("YES");
										}
									break;
								case 7:
									gge[i].setBounds(620,17*kee+100,60,16);
									gge[i].setBackground(Color.cyan);
									aFrame.add(gge[i]);
									gge[i].setText(getData.rs.getString(i+1));
									break;			
							}
						}
						kee++;
						total++;
					}while(getData.rs.next()&&total<=17);
				}catch(SQLException ex){
					System.out.println("The database is exception!");
			}		
		}
}