Java实战项目（1）：swing图书管理系统的登录，注册，找回密码，增删查，个人解析等

2020-04-12 22:35 作者:诗书画唱 0人读过 | 我要投稿

SQL部分：

drop table yonghu, shangpin,dingdanxiangqing,sp_Type

drop table shangpin

select * from yonghu;

select * from shangpin;

select * from sp_Type;

create table yonghu(--创建用户表

yh_ID int primary key identity(1,1),

yh_Uname varchar(30) not null,

yh_Pwd varchar(30) not null,

yh_Name varchar(30) not null,

yh_Age int,

yh_Sex varchar(20),

yh_Phone varchar(100),

yh_Address varchar(200),

yh_Jieshao varchar(500),

yh_Q varchar(500),

yh_AQ varchar(500)

);

insert into yonghu values('1','11','诗书画唱1',21,'男','19999999999','江西','阳光帅气的男孩子','你爱好多吗？','多');

insert into yonghu values('2','22','诗书画唱2',22,'男','29999999999','北京','阳光帅气的男孩子','你看过的书多吗？','多');

insert into yonghu values('3','33','诗书画唱3',23,'男','39999999999','上海','阳光帅气的男孩子','你会的技能多吗？','多');

insert into yonghu values('4','44','诗书画唱4',24,'男','49999999999','湖南','阳光帅气的男孩子','你喜欢的动漫吗？','多');

insert into yonghu values('5','55','诗书画唱5',25,'男','59999999999','浙江','阳光帅气的男孩子','你喜欢的歌曲多吗？','多');

create table sp_Type(--商品类型表

sp_TypeID int primary key identity(1,1),

sp_TypeName varchar(100) not null

);

insert into sp_Type values('水果');

insert into sp_Type values('零食');

insert into sp_Type values('小吃');

insert into sp_Type values('日常用品');

create table shangpin(--商品表

sp_ID int primary key identity(1,1),

sp_Name varchar(100) not null,

sp_Price decimal(10,2) not null,

sp_TypeID int,

sp_Jieshao varchar(300)

);

insert into shangpin values('苹果',12,1,'好吃的苹果');

insert into shangpin values('香蕉',2,1,'好吃的香蕉');

insert into shangpin values('橘子',4,1,'好吃的橘子');

insert into shangpin values('娃哈哈',3,2,'好吃营养好');

insert into shangpin values('牙刷',5,4,'全自动牙刷');

drop table dingdan

create table dingdan(

dingdan_ID int primary key identity(1,1),

yh_ID int,

dingdanxiangqing_ID int

)

insert into dingdan values(1,1);

insert into dingdan values(1,2);

insert into dingdan values(1,3);

insert into dingdan values(2,4);

insert into dingdan values(2,5);

insert into dingdan values(2,6);

insert into dingdan values(3,7);

create table dingdanxiangqing(

dingdanxiangqing_ID int primary key identity(1,1),

sp_ID int,

sp_num int

)

insert into dingdanxiangqing values(1,3);

insert into dingdanxiangqing values(2,4);

insert into dingdanxiangqing values(1,5);

insert into dingdanxiangqing values(3,5);

insert into dingdanxiangqing values(4,2);

insert into dingdanxiangqing values(5,1);

insert into dingdanxiangqing values(3,3);

insert into dingdanxiangqing values(4,3);

select * from yonghu;

select * from shangpin;

select * from sp_Type;

结构：

（1到4）

package denglu;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPasswordField;

public class chongzhimimajiemian extends JFrame {

static JButton JButton_QuRen = null;

static JLabel JLabel1, JLabel2 = null;

static JPasswordField JPasswordField_qslmm1, JPasswordField_qslmm2 = null;

public chongzhimimajiemian() {

this.setLayout(null);

this.setTitle("重置密码页面");

this.setSize(500, 500);

this.setLocationRelativeTo(null);

this.setVisible(true);

JLabel1 = new JLabel("请输入密码");

JLabel2 = new JLabel("请再次输入密码");

JLabel1.setBounds(100, 100, 100, 30);

this.add(JLabel1);

JLabel2 = new JLabel("请再次输入密码");

JLabel2.setBounds(100, 140, 100, 30);

this.add(JLabel2);

JButton_QuRen = new JButton("确认修改");

JButton_QuRen.setBounds(100, 290, 150, 30);

this.add(JButton_QuRen);

JButton_QuRen.addActionListener(new shijian_queRenXiuGai(this));

JPasswordField_qslmm1 = new JPasswordField();

JPasswordField_qslmm2 = new JPasswordField();

JPasswordField_qslmm1.setBounds(280, 100, 100, 30);

JPasswordField_qslmm2.setBounds(280, 140, 100, 30);

this.add(JPasswordField_qslmm1);

this.add(JPasswordField_qslmm2);

}

class shijian_queRenXiuGai implements ActionListener {

static chongzhimimajiemian chuangKou = null;

public shijian_queRenXiuGai(chongzhimimajiemian chuanzhi) {

this.chuangKou = chuanzhi;

/*个人理解:先声明空的窗口（chuangKou），之后属性都储存到窗口中，之后传值（chuanzhi）赋值给窗口的所有属性,

* 因为“chongzhimimajiemian chuanzhi”的声明，chuanzhi有chongzhimimajiemian中的所有内容*/

}

@Override

public void actionPerformed(ActionEvent arg0) {

if (arg0.getActionCommand().equals("确认修改")) {

JOptionPane.showMessageDialog(null, "点击了修改密码按钮");

// 点击了“确认修改”之后要用if比较一下两个密码输入的是否一致

String pwd1 = chuangKou.JPasswordField_qslmm1.getText();

String pwd2 = chuangKou.JPasswordField_qslmm2.getText();

if (pwd1.equals(pwd2)) {

// 如果相等就做进一步的修改密码

// SQL语句如何加条件：就是where后面加上zhmm（找回密码）页面的uname属性，可以直接调用

// 声明一个工具类，用来保存用户要修改的用户名，什么时候想要使用直接调用就好

String uname = gongjvClass.uname;// 获取到用户要修改的用户名

String sql = "update yonghu set yh_pwd='" + pwd1

+ "' where yh_uname= '" + uname + "'";

if (DBUtils.ZSG(sql)) {

JOptionPane.showMessageDialog(null, "密码重置成功");

} else {

JOptionPane.showMessageDialog(null, "出现了未知的错误，请重试!");

}

} else {

//不相等就提示用户两次密码输入不一致

JOptionPane.showMessageDialog(null, "两次密码输入不一致");

return;

}

package denglu;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

/*DBUtis封装了对JDBC的操作，简化了JDBC操作。可以少写代码。

1对于数据表的读操作，他可以把结果转换成List，Aray, Set等java集合，便于程序员操作:

2.对于数据表的写操作，也变得很简单(只需写sql语句)

3.可以使用数据源，使用JNDI, 数据库连接池等技术来优化性能-重用已经构建好的数据库连

注意，在使用DBUtis过程中，需要在C3P0Utils中添加getDateSource方法。*/

public class DBUtils {

private static Connection con = null;

private static ResultSet res = null;

private static Statement sta = null;

static {

try {

Class.forName("com.microsoft.sqlserver." + "jdbc.SQLServerDriver");

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

public static Connection getCon() {

if (con == null) {

try {

con = DriverManager.getConnection(

"jdbc:sqlserver://DESKTOP-49FTFSP;"

+ "databaseName=yonghu", "sa", "1234abcd");

} catch (SQLException e) {

e.printStackTrace();

}

return con;

}

public static ResultSet Select(String sql) {

/* Select为用于查找的静态方法 */

con = getCon();

try {

sta = con.createStatement();

res = sta.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return res;

}

public static boolean ZSG(String sql) {

/* ZXG为用于增加(Z)或修改(G)或删除(S)的静态方法,命名不可太长不然这里会不管用 */

boolean b = false;

con = getCon();

try {

sta = con.createStatement();

int num = sta.executeUpdate(sql);

if (num > 0) {

b = true;

}

} catch (SQLException e) {

e.printStackTrace();

}

return b;

}

package denglu;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPasswordField;

import javax.swing.JTextField;

public class denglu extends JFrame {

public static JButton JButton_dl, JButton_qx, JButton_zc,

JButton_zhmm = null;

public static JLabel JLabel_uname, JLabel_pwd = null;

public static JPasswordField JPasswordField_pwd1 = null;

public static JTextField JTextField_unametxt1 = null;

public denglu() {

this.setLayout(null);

this.setSize(640, 400);

this.setLocationRelativeTo(null);

JLabel_uname = new JLabel("用户名");

JLabel_pwd = new JLabel("密码");

JLabel_uname.setBounds(100, 100, 70, 30);

JLabel_pwd.setBounds(100, 140, 70, 30);

this.add(JLabel_uname);

this.add(JLabel_pwd);

JTextField_unametxt1 = new JTextField();

JPasswordField_pwd1 = new JPasswordField();

JTextField_unametxt1.setBounds(180, 100, 140, 30);

JPasswordField_pwd1.setBounds(180, 140, 140, 30);

this.add(JTextField_unametxt1);

this.add(JPasswordField_pwd1);

JButton_dl = new JButton("登录");

JButton_dl.setBounds(140, 180, 70, 35);

JButton_dl.addActionListener(new shijian_denglu(this));

JButton_qx = new JButton("取消");

JButton_qx.setBounds(230, 180, 70, 35);

// JButton_qx.setBounds(arg0（下标为0的值）， arg1, arg2， arg3);

JButton_qx.addActionListener(new shijian_denglu(this));

JButton_zc = new JButton("注册");

JButton_zc.setBounds(330, 180, 70, 35);

JButton_zc.addActionListener(new shijian_denglu(this));

JButton_zhmm = new JButton("找回密码");

JButton_zhmm.setBounds(430, 180, 90, 35);

JButton_zhmm.addActionListener(new shijian_denglu(this));

this.add(JButton_zc);

this.add(JButton_dl);

this.add(JButton_qx);

this.add(JButton_zhmm);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

}

* 点击按钮是触发事件，所以加点击事件(ActionEvent) 在事件中使用窗体，将窗体传过来

class shijian_denglu implements ActionListener {

public denglu shijian_dengLu1 = null;

public shijian_denglu(denglu shijian_dengLu2) {

shijian_dengLu1 = shijian_dengLu2;

}

@Override

public void actionPerformed(ActionEvent arg0) {

// JOptionPane.showMessageDialog(null, "点击");

if (arg0.getActionCommand().equals("登录")) {

String uname = shijian_dengLu1.JTextField_unametxt1.getText()

.trim();// 从shijian_dengLu1中的JTextField_unametxt1获取用户输入的用户名文本内容

String pwd = shijian_dengLu1.JPasswordField_pwd1.getText().trim();// 获取密码

String sql = "select * from yonghu where yh_uname='" + uname

+ "'and yh_pwd='" + pwd + "'";

ResultSet res = DBUtils.Select(sql);

try {// res.next()表明寻找res中的内容，如果res中有数据，登录成功，否则登录失败

if (res.next()) {

JOptionPane.showMessageDialog(null, "登录成功");

new dengLuHouJieMian();

shijian_dengLu1.setVisible(false);

} else {

JOptionPane.showMessageDialog(null, "用户名或密码错误");

}

} catch (SQLException e) {

e.printStackTrace();

}

// 点击按钮后会做登录，首先要获取窗体上的用户名和密码，

// 去数据库里查一下用户输入的用户名和密码数据库中存在情况，

// 如果数据库中存在和用户输入的用户名和密码一致

// 说明数据库有这条数据库，用户就可以登录

} else if (arg0.getActionCommand().equals("注册")) {

JOptionPane.showMessageDialog(null, "点击了注册按钮");

new zhuCe();

// dd. setVisible(false);（这里dd. setVisible(false);表明视图隐藏）

} else if (arg0.getActionCommand().equals("找回密码")) {

JOptionPane.showMessageDialog(null, "点击了找回密码按钮");

new zhaoHuiMiMa();

// dd. setVisible(false);

} else if (arg0.getActionCommand().equals("取消")) {

JOptionPane.showMessageDialog(null, "点击了取消按钮");

// dd. setVisible(false);

}

package denglu;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Vector;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.table.DefaultTableModel;

public class dengLuHouJieMian extends JFrame {

class shijian_table implements MouseListener, ActionListener {

public dengLuHouJieMian HanDengLuHouJieMianNeiRong = null;

public shijian_table(dengLuHouJieMian dengLuHouJieMianNeiRong) {

this.HanDengLuHouJieMianNeiRong = dengLuHouJieMianNeiRong;

}

// HanDengLuHouJieMianNeiRong（含登录后界面内容）

// DengLuHouJieMianNeiRong（登录后界面内容）

// 把窗体等内容都赋值传给HanDengLuHouJieMianNeiRong是为了方便下面如

// HanDengLuHouJieMianNeiRong.txt_name.getText();的“点（.）式引用,由“.”

// 后面的精确后缀条件提示等引用精确内容”

@Override

public void actionPerformed(ActionEvent arg0) {

String name = HanDengLuHouJieMianNeiRong.wenBenKuang_name.getText();

String price = HanDengLuHouJieMianNeiRong.wenBenKuang_price.getText();

String type = HanDengLuHouJieMianNeiRong.wenBenKuang_typeid.getText();

// int type = HanDengLuHouJieMianNeiRong.com1.getSelectedIndex();

String jieshao = HanDengLuHouJieMianNeiRong.wenBenKuang_spjieshao.getText();

String sql = "insert into shangpin values('" + name + "'" + ", "

+ price + "," + type + ",'" + jieshao + "')";

if (DBUtils.ZSG(sql)) {

JOptionPane.showMessageDialog(null, "增加成功");

HanDengLuHouJieMianNeiRong.chaxunchushihua();

} else {

JOptionPane.showMessageDialog(null, "出现了未知的错误，增加失败");

}

@Override

public void mouseClicked(MouseEvent arg0) {

if (arg0.getClickCount() == 2) {

int row = HanDengLuHouJieMianNeiRong.biaoGe1.getSelectedRow();

HanDengLuHouJieMianNeiRong.wenBenKuang_Bianhao