package csgl;
import java.awt.event.*;
import javax.swing.*;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.awt.*;
public class Login implements ActionListener{
JFrame f;
JLabel l1;
JLabel l2;
JTextField jt1;
JTextField jt2;
JButton an1;
JButton an2;
JLabel l3;
public Login(){
f = new JFrame();
f.setTitle("吉姆超市管理");
f.setLayout(null);
l1 = new JLabel("请输入账号:");
l2 = new JLabel("请输入密码:");
l3 = new JLabel("吉姆超市管理系统");
jt1 =new JTextField(15);
jt2 =new JTextField(15);
an1 =new JButton("登录");
an2 =new JButton("取消");
an1.addActionListener(this);
JLabel banner = new JLabel();
Icon t1 = new ImageIcon("image/2.jpg");
banner.setBounds(0, 0, 300, 50);
banner.setIcon(t1);
l3.setBounds(80, 40, 150, 50);
l1.setBounds(60, 70, 100, 50);
l2.setBounds(60, 120, 100, 50);
jt1.setBounds(140, 85, 120, 20);
jt2.setBounds(140, 135, 120, 20);
an1.setBounds(50, 180, 90, 25);
an2.setBounds(150, 180, 90, 25);
l3.setFont(new Font("宋体", 1, 15));
f.add(l1);
f.add(jt1);
f.add(l2);
f.add(jt2);
f.add(an1);
f.add(an2);
f.add(l3);
f.add(banner);
f.setSize(300,300);
f.setResizable(false);
f.setVisible(true);
}
public static void main(String[] args) {
Login l1=new Login();
}
public void actionPerformed(ActionEvent e){
String zhanghao =jt1.getText();
String mima =jt2.getText();
DBConnection db =new DBConnection();
Connection conn =db.con;
try{Statement stmt = conn.createStatement();
ResultSet rs= stmt.executeQuery
("select * from denglu where zhanghao ='"+ zhanghao + "'and mima ='" + mima+"'");
if(rs.next()){
JOptionPane.showConfirmDialog(null,"登陆成功","提示信息",
JOptionPane.DEFAULT_OPTION,
JOptionPane.INFORMATION_MESSAGE);
setVisible(false);
new zhujiemian().init();
}else{
JOptionPane.showConfirmDialog(null,"登录失败","提示信息",
JOptionPane.DEFAULT_OPTION,
JOptionPane.INFORMATION_MESSAGE);
}
}
catch(Exception e1){
System.out.print("查询成功");
}
}
private Container getContentPane() {
// TODO Auto-generated method stub
return null;
}
private void setDefaultCloseOperation(int exitOnClose) {
// TODO Auto-generated method stub
}
private static void close() {
// TODO Auto-generated method stub
}
public void setVisible(boolean b) {
// TODO Auto-generated method stub
}
public void setSize(int i, int j) {
// TODO Auto-generated method stub
}
public void setLocation(int i, int j) {
// TODO Auto-generated method stub
}
}