package Lesson0524;

import javax.swing.*;

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class atm extends JFrame{
	private JLabel J_zh;
	private JTextField zh_1;
	private JLabel J_mm;
	private JPasswordField mm_1;
	private JButton dl;
	private JButton qx;
	private JPanel mb;
	
	public atm(){
		

	}
	public atm(String title){
		super(title);
		J_zh = new JLabel("账号：");
		zh_1 = new JTextField(20);
		J_mm = new JLabel("密码：");
		mm_1 = new JPasswordField(20);
		dl = new JButton("登陆");
		dl.addActionListener(new ActionListener(){

			@Override
			public void actionPerformed(ActionEvent arg0) {
				// TODO 自动生成的方法存根
				
			try{
				boolean b = denglu();
				if(b){
					sh();
					new cz("取款");
				}else{
					JOptionPane.showMessageDialog(null, "账号或者密码错误，请重新登陆");
				}
			} catch(ClassNotFoundException e){
				e.printStackTrace();
			} catch(SQLException e){
				e.printStackTrace();
			}
		}
			
	});

		qx = new JButton("取消");
		mb = new JPanel();
		
		mb.add(J_zh);
		mb.add(zh_1);
		mb.add(J_mm);
		mb.add(mm_1);
		mb.add(dl);
		mb.add(qx);
		
		this.add(mb);
		this.setBounds(300, 300, 300, 300);
		this.setVisible(true);
		
	}
	
	public boolean denglu() throws ClassNotFoundException, SQLException{
		String zh = zh_1.getText();
		String mm = mm_1.getText();
		

			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://localhost:3306/atm?characterEncoding=utf-8";
			String user="root";
			String pass="root";
			Connection conn = DriverManager.getConnection(url,user,pass);
			
			Statement stmt = conn.createStatement();
			
			
			String sql="select * from account where accounts='"+zh+"'and password='"+mm+"'";
			ResultSet rs = stmt.executeQuery(sql);
			
			boolean b = rs.next();
			return b;
	}
	public void sh(){
		this.dispose();
	}
}