栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

java窗口实现QQ登录连接数据库

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

java窗口实现QQ登录连接数据库

 

//登录窗口
package dl;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.stream.StreamSupport;

public class dlwindow extends JFrame {
    JTextField name;
    JPasswordField password;
    JButton qr;
    JButton zc;
    JLabel jl1;
    JLabel jl2;
    JLabel jl3;//账号密码输入错误提示

    ActionListener zclistener;//转换到注册窗口事件
    ActionListener dllistener;//账号密码数据库验证事件处理
    dlwindow()
    {
        init();
        setTitle("登录");
        setBounds(100,100,500,380);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }
    //初始化
    private void init() {
        setVisible(true);
        name=new JTextField(8);
        password=new JPasswordField(12);
        qr=new JButton("确认");
        zc=new JButton("注册");
        jl1=new JLabel("姓名:");
        jl2=new JLabel("密码:");
        jl3=new JLabel();
        setLayout(null);
        add(jl1);
        jl1.setBounds(140,50,60,30);
        add(name);
        name.setBounds(175,50,150,30);
        add(jl2);
        jl2.setBounds(140,110,60,30);
        add(password);
        password.setBounds(175,110,150,30);
        add(qr);
        qr.setBounds(180,160,60,30);
        add(zc);
        zc.setBounds(260,160,60,30);
        add(jl3);
        jl3.setBounds(230,200,200,30);
        //事件
        zclistener=new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                setVisible(false);
                zcwindow zcw=new zcwindow();
                zcw.setVisible(true);
            }
        };
        zc.addActionListener(zclistener);
        //数据库验证账号密码事件
        dllistener=new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
               String username=name.getText();
               String userpassword=password.getText();
               boolean flag=pd(username,userpassword);
                if (flag)
                {
                    setVisible(false);
                    showwindow showw=new showwindow();
                    showw.setVisible(true);
                }else {
                    jl3.setText("账号或密码错误,请再次输入");
                    name.setText(null);
                    password.setText(null);
                }
            }
        };
        qr.addActionListener(dllistener);
    }

    private boolean pd(String username, String userpassword) {
        Connection coon=null;
        Statement stmt=null;
        try {
            coon=JDBCUtils.getConnection();
            stmt=coon.createStatement();
            String sql="select * from users where name='"+username+"'and password='"+userpassword+"'";
            ResultSet rs=stmt.executeQuery(sql);
            return rs.next();
        } catch (ClassNotFoundException classNotFoundException) {
            classNotFoundException.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return false;
    }
}

//注册窗口

package dl;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class zcwindow extends JFrame {
    JTextField name;
    JTextField email;
    JPasswordField password1;
    JPasswordField password2;
    JButton back;
    JButton qr;
    JLabel jl1;
    JLabel jl2;
    JLabel jl3;
    JLabel jl4;
    JLabel jl5;//注册状态信息
    //事件
    ActionListener backlistener;
    ActionListener zclistener;
    zcwindow()
    {
        init();
        setBounds(100,100,500,380);
        setTitle("注册");
        setVisible(false);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }

    private void init() {
        name=new JTextField(8);
        password1=new JPasswordField(12);
        password2=new JPasswordField(12);
        email=new JTextField(16);
        back=new JButton("返回");
        qr=new JButton("确认");
        jl1=new JLabel("姓名:");
        jl2=new JLabel("密码:");
        jl4=new JLabel("邮箱:");
        jl3=new JLabel("再次输入密码:");
        jl5=new JLabel();
        setLayout(null);
        add(jl1);
        jl1.setBounds(140,30,60,30);
        add(name);
        name.setBounds(175,30,150,30);
        add(jl2);
        jl2.setBounds(140,90,60,30);
        add(password1);
        password1.setBounds(175,90,150,30);
        add(jl3);
        jl3.setBounds(93,150,100,30);
        add(password2);
        password2.setBounds(175,150,150,30);
        add(email);
        email.setBounds(175,210,150,30);
        add(back);
        back.setBounds(180,270,60,30);
        add(qr);
        qr.setBounds(255,270,60,30);
        add(jl4);
        jl4.setBounds(140,210,60,30);
        add(jl5);
        jl5.setBounds(300,305,200,30);
        //返回登录窗口界面事件
        backlistener=new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                setVisible(false);
                dlwindow dlw=new dlwindow();
                dlw.setVisible(true);
            }
        };
        back.addActionListener(backlistener);
        //注册user并添加到数据库
        zclistener=new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                User user=new User();
                user.setName(name.getText());
                user.setPassword(password1.getText());
                user.setEmail(email.getText());
                if (password1.getText().equals(password2.getText()))
                {
                    insert(user);
                    jl5.setText("注册成功!");
                }else
                {
                    jl5.setText("两次密码不一致,请再次输入");
                    password1.setText(null);
                    password2.setText(null);
                }
            }
        };
        qr.addActionListener(zclistener);
    }

    private void insert(User user) {
        Connection coon=null;
        Statement stmt=null;
        try {
            coon=JDBCUtils.getConnection();
            stmt=coon.createStatement();
            int num=1;
            String sql1="select * from users";
            ResultSet rs=stmt.executeQuery(sql1);
            while (rs.next())
            {
                num=num+1;
            }
            String sql2="insert into users(id,name,password,email)values('"+num+"','"+user.getName()+"','"+user.getPassword()+"','"+user.getEmail()+"')";
            stmt.executeUpdate(sql2);
            coon.close();
            stmt.close();
            rs.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
}

//展示窗口

package dl;

import javax.swing.*;

public class showwindow extends JFrame {
    JLabel jLabel;
     showwindow()
     {
         init();
         setVisible(true);
         setBounds(100,100,330,500);
         setTitle("QQ");
         setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
     }

    private void init() {
         jLabel=new JLabel("hello QQ");
         setLayout(null);
         add(jLabel);
         jLabel.setBounds(130,150,60,30);
    }
}

//User类

package dl;

public class User {
    private int id;
    private String name;
    private String password;
    private String email;

    public int getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getPassword() {
        return password;
    }

    public String getEmail() {
        return email;
    }

    public void setId(int id) {
        this.id = id;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", password='" + password + ''' +
                ", email='" + email + ''' +
                '}';
    }
}

//JDBCUtil类,方便后面不用一次一次创建连接,直接调用

package dl;

import java.sql.*;

public class JDBCUtils {
    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String url="jdbc:mysql://localhost:3306/jdbc?serverTimezone=GMT%2B8";
        String username="root";
        String password="";//输入自己的密码
        Connection coon= DriverManager.getConnection(url,username,password);
        return coon;
    }
    //释放资源
    public static void release(Statement stmt, Connection coon)
    {
        if (stmt!=null)
        {
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            stmt=null;
        }
        if (coon!=null)
        {
            try {
                coon.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            coon=null;
        }
    }
    public static void release(ResultSet rs, Statement stmt, Connection coon)
    {
        if (rs!=null)
        {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            rs=null;
        }
        release(stmt,coon);
    }
}

//测试类

package dl;

public class doMain {
    public static void main(String[] args) {
        dlwindow dlw=new dlwindow();
    }
}

运行截图:

 

 注册成功后的数据库,数据添加成功

 

 

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/956732.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号