超市购物系统【GUI/Swing+MySQL】（Java课设）

import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; class Login { JFrame frame =new JFrame("登录"); Container c = frame.getContentPane();//创建视图 JLabel userLabel=new JLabel("用户名"); JTextField username= new JTextField(); JLabel passwdLabel=new JLabel("密码"); JPasswordField password=new JPasswordField(); JButton okbutton = new JButton("登录"); JButton cancelbttton = new JButton("注册"); JPanel inputPanel; public Login(){ frame.setBounds(600, 200, 300, 250);//设置窗体位置&大小 c.setLayout(new BorderLayout());//设置视图的布局 frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//设置❌功能 init();//初始化，把控件放在布局里 frame.setVisible(true);//设置窗体可见 //登录的点击事件 okbutton.addActionListener (new ActionListener() { public void actionPerformed(ActionEvent e) { try{ //获取单选框的值 String type =""; for(Component c:inputPanel.getComponents()){ if(c instanceof JRadioButton){ if(((JRadioButton) c).isSelected()){ type += ((JRadioButton)c).getText(); } } } //连接数据库校验 Connection conn =JDBCUtils.getConnection(); String sql = "select * from user where username=?"; PreparedStatement pstm = conn.prepareStatement(sql); pstm.setString(1, username.getText()); // 执行查询 ResultSet rs = pstm.executeQuery(); rs.next(); String passwordDB= rs.getString("password"); String typeDB = rs.getString("type"); //判断账号密码和类型是否一致 if (passwordDB.equals(password.getText())&&typeDB.equals(type)){ JOptionPane.showMessageDialog(null, "登录成功"); if (typeDB.equals("用户")){ new UserMain(); }else if(typeDB.equals("管理员")){ new AdminMain(); } }else{ JOptionPane.showMessageDialog(null, "账号或密码错误"); } }catch(SQLException sqle){ sqle.printStackTrace(); } } }); cancelbttton.addActionListener (new ActionListener() { public void actionPerformed(ActionEvent e) { new Register(); } }); } public void init(){ // 标题——上方 JPanel titlePanel =new JPanel();//创建一个放置标题的面板 titlePanel.setLayout(new FlowLayout()); titlePanel.add(new JLabel("超市购物系统")); c.add(titlePanel, "North");//加入视图中 // 输入框——中间 inputPanel=new JPanel(); inputPanel.setLayout(null); userLabel.setBounds(50, 20, 50, 20);//标签位置 passwdLabel.setBounds(50, 60, 50, 20); inputPanel.add(userLabel); inputPanel.add(passwdLabel); username.setBounds(110, 20, 120, 20); password.setBounds(110, 60, 120, 20); JRadioButton admin = new JRadioButton("管理员");//创建单选框 JRadioButton user = new JRadioButton("用户");//创建单选框 ButtonGroup group = new ButtonGroup(); //创建单选框按钮组 group.add(admin); group.add(user); admin.setBounds(80, 100, 80, 20); user.setBounds(160, 100, 120, 20); inputPanel.add(username); inputPanel.add(password); inputPanel.add(user); inputPanel.add(admin); c.add(inputPanel, "Center"); // 按钮底部 JPanel buttonPanel =new JPanel(); buttonPanel.setLayout(new FlowLayout()); buttonPanel.add(okbutton); buttonPanel.add(cancelbttton); c.add(buttonPanel, "South"); } public static void main(String[] args) { new Login(); } }