//登录窗口
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();
}
}
运行截图:
注册成功后的数据库,数据添加成功



