package electronicbook;
//设计登录界面的类

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.io.*;
import java.sql.*;
import javax.imageio.ImageIO;
import javax.swing.*;
 
/*import dates.DBOperation;
import dates.MyDBConnection;*/
 
public class Window22 extends JFrame implements ActionListener{//implements MouseListener 
 
	//设置面板以及面板标题
	public JFrame chuangkou = new JFrame("登录窗口");
	
    
	private JLabel id=new JLabel("用户名:");
	private JLabel psw=new JLabel("密   码:");
	
	//定义文本框
	private JTextField txt1=new JTextField();
	private JTextField txt2=new JTextField();
	/*private String text1;
	private String text2;*/
	
	//定义按钮
	private JButton denglu=new JButton("登陆");
	/*private JButton zhuce=new JButton("注册");
	private JButton tuichu=new JButton("取消");*/
	
	private int distinguish;//用来记录鼠标悬停在哪个位置(查阅了资料）
	
	/*MyDBConnection myDB=new MyDBConnection();
	public DBOperation myOpr=new DBOperation(myDB);*/
	
	
	public Window22(){
		
		
	    
		//设置窗口大小、位置
		chuangkou.setLayout(null);
		chuangkou.setSize(500,300);
		chuangkou.setLocation(400, 400);
		
		
		//设置字体、颜色
		Font font=new Font("华文行楷",Font.BOLD,20);
		id.setFont(font);
		psw.setFont(font);
		id.setForeground(Color.black);
		psw.setForeground(Color.black);
		
		//设置透明
		txt1.setOpaque(true);
		txt2.setOpaque(true);
		
		//设置按钮登录
		denglu.setContentAreaFilled(true);//设置button组件透明
		denglu.setFont(font);
	    denglu.setForeground(Color.black);
	    denglu.setBorder(BorderFactory.createRaisedBevelBorder());//设置突出button组件
	    denglu.addActionListener(this); 
	    
	    //设置按钮注册
	   /* zhuce.setContentAreaFilled(true);
		zhuce.setFont(font);
		zhuce.setForeground(Color.black);
		zhuce.setBorder(BorderFactory.createRaisedBevelBorder());
	        
		//设置退出按钮
	    tuichu.setContentAreaFilled(true);
		tuichu.setFont(font);
		tuichu.setForeground(Color.black);
		tuichu.setBorder(BorderFactory.createRaisedBevelBorder());*/
		
		//设置登陆界面背景图
		JLabel bg;
		bg=new JLabel(new ImageIcon("../201922210125-于芷萱/登录界面2.jpg")); 
	 
	    
		
		//布局排版
	    id.setBounds(100,100,100,100);
		txt1.setBounds(180,140, 150, 20);
		psw.setBounds(100,130,100,100);
		txt2.setBounds(180,170, 150, 20);
		
		denglu.setBounds(200,200,100,20);
		/*zhuce.setBounds(190,200,80,20);
		tuichu.setBounds(280,200,80,20);*/
		chuangkou.setContentPane(bg);
		chuangkou.setLayout(null);
		chuangkou.add(id);
		chuangkou.add(txt1);
		chuangkou.add(psw);
		chuangkou.add(txt2);
		chuangkou.add(denglu);
		/*chuangkou.add(zhuce);
		chuangkou.add(tuichu);*/
		
		id.setVisible(true);
		psw.setVisible(true);
		chuangkou.setVisible(true);
		bg.setVisible(true);
	}
	
	
	
	public void actionPerformed(ActionEvent e){  
        String name,pwd;  
        name=txt1.getText();  
        pwd=txt2.getText();  
        try{  
          Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载数据库驱动 
           
        }  
        catch(ClassNotFoundException ex){  
        System.out.println(ex);  
        }  
        try{  
            Connection con;  
            Statement sql;  
            ResultSet rs;  
            String url,userName,userPwd;  
             // 连接数据库的语句
            url="jdbc:sqlserver://localhost:1433;DatabaseName=电子书订阅";
        
            userName="sa";  
            userPwd="123456";  
            con=DriverManager.getConnection(url,userName,userPwd);  
            sql=con.createStatement();  
            rs=sql.executeQuery("select * from 管理员注册信息  where userName ='"+name+"' and userPwd='"+pwd+"'");//对应自己数据库建的表填写  
            int q=0;  
            while(rs.next()){  
                q++;  
            }  
            if(q>0){  
                JOptionPane.showMessageDialog(this, "登陆成功！","消息对话框",JOptionPane.WARNING_MESSAGE);  
                this.dispose();  
                new B();    
                  
            }  
            else  
                JOptionPane.showMessageDialog(this, "账号或者密码错误!","消息对话框",JOptionPane.WARNING_MESSAGE);  
        }  
        catch(SQLException exp){  
            System.out.println(exp);  
        } 
        
    }  
}