java 窗口实现登录连接mysql

package loginjava;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

public class window extends JFrame {
    JTextField inputname;
    JPasswordField inputpassword;
    JButton jButton;
    ActionListener listener;
    JLabel show;
    JLabel jlname;
    JLabel jlpassword;
    window()
    {
        init();
        setBounds(100,100,580,380);
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }

    private void init() {
        inputname=new JTextField(10);
        inputpassword=new JPasswordField(10);
        jButton=new JButton("確認");
        show=new JLabel("hello");
        jlname=new JLabel("姓名");
        jlpassword=new JLabel("密碼");
        setLayout(new FlowLayout());
        add(jlname);
        add(inputname);
        add(jlpassword);
        add(inputpassword);
        add(jButton);
        add(show);

        //事件
        listener=new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                          String name=inputname.getText();
                          String password=inputpassword.getText();
                          boolean flag=pd(name,password);
                          if(flag)
                          {
                              show.setText("欢迎来到我的世界");
                          }else {
                              show.setText("账号或密码错误");
                          }
            }
        };
        jButton.addActionListener(listener);
    }
    public boolean pd(String username1,String userpassword1) {
        Connection coon;
        Statement stmt;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/jdbc?serverTimezone=GMT%2B8";
            String username = "root";
            String userpassword = "";//输入自己的密码
            coon = DriverManager.getConnection(url, username, userpassword);
            stmt = coon.createStatement();
            String sql = "select * from users where name ='" + username1 + "'and password='" + userpassword1 + "'";
            ResultSet rs = stmt.executeQuery(sql);
            return rs.next();
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return false;
    }
}
//运行类
package loginjava;

import java.util.Scanner;

public class doMain {
    public static void main(String[] args) {
        window wd=new window();
        wd.setTitle("登錄");
    }
}


版权声明:本文为m0_64979660原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。