Java swing jdbc DBUtils收銀管理系統(tǒng)，商品管理系統(tǒng)【詩書畫唱】
用了皮膚包，有時界面按鈕顏色用代碼改變不了。
以下都是按我自己寫的順序布局的內(nèi)容（按順序做是一個很好的習(xí)慣）：
可以把多個表查出到一個界面，多個功能整合到一個界面等。
select * from sp a inner join sp_type b on a.sp_typeid=b.sp_typeid inner join gouwuche c on a.sp_id=c.sp_id
select * from sp a inner join sp_type b on a.sp_typeid=b.sp_typeid
create database shouyin
create table yh_Type(
yh_typeid int primary key identity(1,1),
yh_typename varchar(100) not null
);
insert into yh_Type values('普通用戶');
insert into yh_Type values('管理員用戶');
create table yonghu(
?yh_ID int primary key identity(1,1),
?yh_Uname varchar(30) not null unique,
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_A varchar(500),
yh_type nvarchar(20) check(yh_type='普通用戶' or yh_type='管理員用戶'),
);
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 nvarchar(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 sp(
sp_id int primary key identity(1,1),
sp_name nvarchar(50) not null unique,
sp_typeid int,
sp_price decimal(10,2),
sp_jieshao nvarchar(100)
)
insert into sp values('蘋果',1,1,'好吃的蘋果'),('薯片',2,1,'好香的薯片'),
('雞柳',3,1,'好吃的雞柳'),('牙刷',5,4,'全自動牙刷');
--購物車表
create table gouwuche(
gwc_id int primary key identity(1,1),
userid int,
sp_id int,
sp_num int
)
insert into gouwuche values(1,1,1);
select * from yh_type;
select * from yonghu;
select * from sp_type;
select * from sp;
select * from gouwuche;
drop table sp_type
drop table sp
drop table yh_type
drop table yonghu
drop table gouwuche;
package denglu;
import org.jb2011.lnf.beautyeye.BeautyEyeLNFHelper;
public class mains {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
BeautyEyeLNFHelper.frameBorderStyle = BeautyEyeLNFHelper.FrameBorderStyle
.osLookAndFeelDecorated;
org.jb2011.lnf.beautyeye.BeautyEyeLNFHelper.launchBeautyEyeLNF();
} catch (Exception e) {
}
new dengLu();
}
}
package denglu;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.ImageIcon;
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.JPasswordField;
import javax.swing.JTextField;
public class dengLu extends JFrame {
public static JButton dengLuAnNiu,?
quXiaoAnNiu, zhuCeAnNiu,
zhaoHuiMiMaAnNiu = null;
static JComboBox xiaLaKuang = null;
public static JLabel unameWenZi,?
pwdWenZi, imgJLabel,
yhTypeWenZi = null;
public static JPasswordField pwdKuang = null;
public static JTextField unameWenBenKuang = null;
public JPanel oldMianBan = null;
public dengLu() {
this.setTitle("收銀管理系統(tǒng)");
this.setLayout(null);
this.setSize(640, 400);
this.setLocationRelativeTo(null);
unameWenZi = new JLabel("用戶名");
pwdWenZi = new JLabel("密碼");
yhTypeWenZi = new JLabel("用戶類型");
xiaLaKuang = new JComboBox();
xiaLaKuang.addItem("普通用戶");
xiaLaKuang.addItem("管理員用戶");
xiaLaKuang.setBounds(180, 180, 140, 30);
yhTypeWenZi.setBounds(110, 180, 70, 30);
this.add(xiaLaKuang);
this.add(yhTypeWenZi);
unameWenZi.setBounds(110, 100, 70, 30);
pwdWenZi.setBounds(110, 140, 70, 30);
// 圖片
imgJLabel = new JLabel();
imgJLabel.setBounds(30, 0, 580, 100);
imgJLabel.setIcon(new?
ImageIcon("img//beijing.gif"));
oldMianBan = new JPanel();
oldMianBan.setLayout(null);
oldMianBan.setBounds(30, 0, 580, 100);
oldMianBan.add(imgJLabel);
this.add(oldMianBan);
this.add(unameWenZi);
this.add(pwdWenZi);
// JTextField_unametxt1 =?
//new JTextField("1");//寫死
unameWenBenKuang = new JTextField();
// 沒寫死
pwdKuang = new JPasswordField();
unameWenBenKuang.
setBounds(180, 100, 140, 30);
pwdKuang.setBounds(180, 140, 140, 30);
this.add(unameWenBenKuang);
this.add(pwdKuang);
dengLuAnNiu = new JButton("登錄");
dengLuAnNiu.setBounds(60, 220, 100, 35);
dengLuAnNiu.addActionListener
(new shiJian(this));
quXiaoAnNiu = new JButton("取消");
quXiaoAnNiu.setBounds(450, 220, 70, 35);
quXiaoAnNiu.addActionListener
(new shiJian(this));
zhuCeAnNiu = new JButton("普通用戶注冊");
zhuCeAnNiu.setBounds(190, 220, 120, 35);
zhuCeAnNiu.addActionListener
(new shiJian(this));
zhaoHuiMiMaAnNiu = new JButton("找回密碼");
zhaoHuiMiMaAnNiu.setBounds(330, 220, 90, 35);
zhaoHuiMiMaAnNiu.
addActionListener(new shiJian(this));
this.add(zhuCeAnNiu);
this.add(dengLuAnNiu);
this.add(quXiaoAnNiu);
this.add(zhaoHuiMiMaAnNiu);
this.setVisible(true);
}}
class shiJian implements ActionListener {
public dengLu jieShouChuangTi = null;
public shiJian(dengLu ChuangTi) {
this.jieShouChuangTi = ChuangTi;
}
@Override
public void actionPerformed
(ActionEvent arg0) {
String uname = jieShouChuangTi.
unameWenBenKuang.getText().trim();
String pwd = jieShouChuangTi.
pwdKuang.getText().trim();// 獲取密碼
String type = jieShouChuangTi.
xiaLaKuang.getSelectedItem().toString();
if (arg0.getActionCommand().
equals("登錄")) {
if (type.equals("管理員用戶")) {
String sql = "select * from yonghu "
+ "where yh_uname='" + uname
+ "' and yh_pwd='" + pwd +?
"' and yh_type='" + type
+ "'";
System.out.println(sql);
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
new guanLiYuandengLu(uname);
jieShouChuangTi.setVisible(false);
} else {
JOptionPane.showMessageDialog(null,
"用戶名或密碼錯誤或你不是管理員用戶"
+ "或用戶類型選擇錯誤");
}
} catch (SQLException e) {
e.printStackTrace();
}
} else if (type.equals("普通用戶")) {
String sql = "select * from yonghu "
+ "where yh_uname='" + uname
+ "' and yh_pwd='" + pwd +?
"' and yh_type='" + type
+ "'";
System.out.println(sql);
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
new ptYongHudengLu(uname);
jieShouChuangTi.setVisible(false);
} else {
JOptionPane.showMessageDialog(null,
"用戶名或密碼錯誤或你不是管理員用戶或"
+ "用戶類型選擇錯誤");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
} else if (arg0.getActionCommand()
.equals("普通用戶注冊")) {
new zhuCe();
} else if (arg0.getActionCommand()
.equals("找回密碼")) {
JOptionPane.showMessageDialog(null,?
"點擊了找回密碼按鈕");
new zhaoHuiMiMa();
}
else if (arg0.getActionCommand()
.equals("取消")) {
JOptionPane.showMessageDialog(null,?
"點擊了取消按鈕");
jieShouChuangTi.setVisible(false);
}
}
}
package denglu;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
class zhuCeShiJian implements ActionListener {
public static zhuCe jieShouChuangTi = null;
public zhuCeShiJian(zhuCe ChuangTi) {
this.jieShouChuangTi = ChuangTi;
}
@Override
public void actionPerformed(ActionEvent arg0) {
JOptionPane.showMessageDialog(null, "點擊了注冊按鈕");
String uname = jieShouChuangTi.unameKuang.getText();
String pwd1 = jieShouChuangTi.pwdKuang1.getText();
String pwd2 = jieShouChuangTi.pwdKuang2.getText();
String name = jieShouChuangTi.nameKuang.getText();
String age = jieShouChuangTi.xiaLaKuang.
getSelectedItem()
.toString();
String sex = "男";
if (jieShouChuangTi.rb2.isSelected()) {
sex = "女";
}
String StringPhone = jieShouChuangTi.
phoneKuang.getText();
ArrayList<String> jiHe = new ArrayList<String>();
if (jieShouChuangTi.diZhiFuxuanKaung1.isSelected()) {
jiHe.add(jieShouChuangTi.diZhiFuxuanKaung1.getText());
}
if (jieShouChuangTi.diZhiFuxuanKaung2.isSelected()) {
jiHe.add(jieShouChuangTi.diZhiFuxuanKaung2.getText());
}
if (jieShouChuangTi.diZhiFuxuanKaung3.isSelected()) {
jiHe.add(jieShouChuangTi.diZhiFuxuanKaung3.getText());
}
String StringAddress = " ";
for (int i = 0; i < jiHe.size(); i++) {
StringAddress += jiHe.get(i) + " ";
}
String StringJieShao = jieShouChuangTi.
jieshaoWenBenYu.getText();
String String_Q = jieShouChuangTi.wenTiKaung.getText();
String String_A = jieShouChuangTi.daAnKuang.getText();
if (!pwd1.equals(pwd2)) {
JOptionPane.showMessageDialog(null,?
"兩次密碼輸入不一致， 請重新輸入");
return;
}
String sql = "select * from "
+ "yonghu where yh_uname='"
+ uname + "'";
ResultSet res_select_uname = DBUtils.
Select(sql);
try {
if (res_select_uname.next()) {
JOptionPane.showMessageDialog(null,?
"用戶名已經(jīng)存在了，請重新輸入");
return;
}
} catch (SQLException e) {
e.printStackTrace();
}
String sqlInsert = "insert into yonghu(yh_uname,"
+ "yh_pwd,yh_Name"
+ ",yh_age,yh_sex,yh_phone,yh_address"
+ ",yh_jieshao,yh_Q,yh_A,yh_type) values('"?
+ uname+ "','"+ pwd1 + "','"
+ name + "'," + age + ",'" + sex
+ "','" + StringPhone + "','" + StringAddress?
+ "','"+ StringJieShao + "','" + String_Q + "','"?
+ String_A + "'"
+ ",'普通用戶')";
if (DBUtils.ZSG(sqlInsert)) {
JOptionPane.showMessageDialog(null, "注冊成功");
} else {
JOptionPane.showMessageDialog(null,?
"出現(xiàn)了未知的錯誤，請重試");
}
}
}
public class zhuCe extends JFrame {
static JCheckBox diZhiFuxuanKaung1,
diZhiFuxuanKaung2,
diZhiFuxuanKaung3 = null;
public static JButton zhuCeAnNiu = null;
static JComboBox xiaLaKuang = null;
public static JPasswordField pwdKuang1,
pwdKuang2 = null;
static JTextArea jieshaoWenBenYu = null;
public static JTextField unameKuang, nameKuang,
phoneKuang, jieShaoKuang, wenTiKaung,
daAnKuang = null;
public static JLabel unameWenZi, pwdWenZi,?
queRenPwdWenZi,
nameWenZi, ageWenZi, sexWenZi,
phoneWenZi, addressWenZi, jieShaoWenZi,?
QWenZi, AWenZi = null;
static JRadioButton rb1, rb2 = null;
public zhuCe() {
this.setLayout(null);
this.setSize(600, 700);
this.setTitle("注冊界面（只有普通用戶才要注冊）");
this.setLocationRelativeTo(null);
unameWenZi = new JLabel("用戶名");
pwdWenZi = new JLabel("用戶密碼");
queRenPwdWenZi = new JLabel("確認(rèn)密碼");
nameWenZi = new JLabel("真實姓名");
ageWenZi = new JLabel("年齡");
sexWenZi = new JLabel("性別");
phoneWenZi = new JLabel("電話");
addressWenZi = new JLabel("地址");
jieShaoWenZi = new JLabel("介紹");
QWenZi = new JLabel("問題");
AWenZi = new JLabel("答案");
unameWenZi.setBounds(80, 100, 70, 30);
pwdWenZi.setBounds(80, 140, 70, 30);
queRenPwdWenZi.setBounds(80, 180, 70, 30);
nameWenZi.setBounds(80, 220, 70, 30);
ageWenZi.setBounds(80, 260, 70, 30);
sexWenZi.setBounds(80, 300, 70, 30);
phoneWenZi.setBounds(80, 340, 70, 30);
addressWenZi.setBounds(80, 380, 70, 30);
jieShaoWenZi.setBounds(80, 420, 70, 30);
QWenZi.setBounds(80, 460, 70, 30);
AWenZi.setBounds(80, 500, 70, 30);
this.add(unameWenZi);
this.add(pwdWenZi);
this.add(queRenPwdWenZi);
this.add(nameWenZi);
this.add(ageWenZi);
this.add(sexWenZi);
this.add(phoneWenZi);
this.add(addressWenZi);
this.add(jieShaoWenZi);
this.add(QWenZi);
this.add(AWenZi);
unameKuang = new JTextField();
pwdKuang1 = new JPasswordField();
pwdKuang2 = new JPasswordField();
nameKuang = new JTextField();
rb1 = new JRadioButton("男", true);
rb2 = new JRadioButton("女");
this.add(rb1);
this.add(rb2);
xiaLaKuang = new JComboBox();
ButtonGroup anNiuFenZu = new ButtonGroup();
//anNiuFenZu按鈕分組
anNiuFenZu.add(rb1);
anNiuFenZu.add(rb2);
for (int i = 18; i < 60; i++) {
xiaLaKuang.addItem(i);
}
this.add(xiaLaKuang);
phoneKuang = new JTextField();
diZhiFuxuanKaung1 = new JCheckBox("中國", true);
diZhiFuxuanKaung2 = new JCheckBox("日本");
diZhiFuxuanKaung3 = new JCheckBox("美國");
wenTiKaung = new JTextField();
daAnKuang = new JTextField();
jieshaoWenBenYu = new JTextArea();
jieshaoWenBenYu.setColumns(8);
jieshaoWenBenYu.setRows(4);
jieshaoWenBenYu.setLineWrap(true);
this.add(jieshaoWenBenYu);
unameKuang.setBounds(160, 100, 140, 30);
pwdKuang1.setBounds(160, 140, 140, 30);
pwdKuang2.setBounds(160, 180, 140, 30);
nameKuang.setBounds(160, 220, 140, 30);
xiaLaKuang.setBounds(160, 260, 140, 30);
rb1.setBounds(160, 300, 50, 30);
rb2.setBounds(220, 300, 50, 30);
phoneKuang.setBounds(160, 340, 140, 30);
diZhiFuxuanKaung1.setBounds(160, 380, 80, 30);
diZhiFuxuanKaung2.setBounds(240, 380, 70, 30);
diZhiFuxuanKaung3.setBounds(320, 380, 70, 30);
jieshaoWenBenYu.setBounds(160, 420, 140, 40);
wenTiKaung.setBounds(160, 460, 140, 30);
daAnKuang.setBounds(160, 500, 140, 30);
this.setLocationRelativeTo(null);
this.add(unameKuang);
this.add(pwdKuang1);
this.add(pwdKuang2);
this.add(nameKuang);
this.add(phoneKuang);
this.add(wenTiKaung);
this.add(daAnKuang);
this.add(diZhiFuxuanKaung1);
this.add(diZhiFuxuanKaung2);
this.add(diZhiFuxuanKaung3);
zhuCeAnNiu = new JButton("確認(rèn)注冊");
zhuCeAnNiu.addActionListener
(new zhuCeShiJian(this));
zhuCeAnNiu.setBounds(160, 580, 120, 30);
this.add(zhuCeAnNiu);
this.setVisible(true);
}
}
package denglu;
import java.awt.Color;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
class zhaoHuiMiMaShiJian implements
FocusListener, ActionListener {
public zhaoHuiMiMa jieShouChuangTi = null;
public zhaoHuiMiMaShiJian(zhaoHuiMiMa ChuangTi) {
this.jieShouChuangTi = ChuangTi;
}
@Override
public void actionPerformed(ActionEvent arg0) {
if(arg0.getActionCommand()
.equals("確認(rèn)且回答正確后跳轉(zhuǎn)重置密碼頁面")){
String uname = jieShouChuangTi.unameWenBenKuang
.getText().trim();
String wenTi = jieShouChuangTi.wenTiWenBenKuang
.getText().trim();
String daAn = jieShouChuangTi.daAnWenBenKuang
.getText().trim();
String sql = "select * from yonghu where "
+ "yh_Uname='" + uname
+ "'and yh_Q='" + wenTi + "'and yh_A='" + daAn
+ "'";
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
new chongZhiMiMa();
gongjvClass.uname = uname;
} else {
JOptionPane.showMessageDialog(null, "答案輸入錯誤");
jieShouChuangTi.daAnWenZi2.setText("答案輸入錯誤");
jieShouChuangTi.daAnWenZi2.setForeground(Color.red);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
else if (arg0.getActionCommand()
.equals("取消")) {
JOptionPane.showMessageDialog(null,?
"點擊了取消按鈕");
jieShouChuangTi.setVisible(false);
}
}
@Override
public void focusGained(FocusEvent arg0) {
}
@Override
public void focusLost(FocusEvent arg0) {
String uname = jieShouChuangTi.unameWenBenKuang.
getText().trim();
String sql = "select * from yonghu where yh_uname='"?
+ uname + "'";
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
String wenTi = res.getString("yh_Q");
jieShouChuangTi.wenTiWenBenKuang.setText(wenTi);
jieShouChuangTi.unameWenZi2.setText("");
} else {
jieShouChuangTi.unameWenZi2.setText("用戶名錯誤");
jieShouChuangTi.unameWenZi2.setForeground(Color.red);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class zhaoHuiMiMa extends JFrame {
static JButton queRenAnNiu, quXiaoAnNiu = null;
static JLabel unameWenZi1, wenTiWenZi1,?
daAnWenZi1 = null;
static JLabel unameWenZi2, wenTiWenZi2,?
daAnWenZi2 = null;
static JTextField unameWenBenKuang, wenTiWenBenKuang,?
daAnWenBenKuang = null;
public zhaoHuiMiMa() {
this.setTitle("找回密碼頁面");
this.setLayout(null);
this.setSize(500, 500);
this.setLocationRelativeTo(null);
unameWenZi1 = new JLabel("用戶名");
wenTiWenZi1 = new JLabel("問題");
daAnWenZi1 = new JLabel("答案");
unameWenZi2 = new JLabel("請輸入用戶名");
daAnWenZi2 = new JLabel("請輸入答案");
unameWenBenKuang = new JTextField();
wenTiWenBenKuang = new JTextField();
daAnWenBenKuang = new JTextField();
unameWenBenKuang.addFocusListener
(new zhaoHuiMiMaShiJian(this));
unameWenZi2.setForeground(Color.blue);
daAnWenZi2.setForeground(Color.blue);
unameWenZi1.setBounds(100, 100, 100, 30);
wenTiWenZi1.setBounds(100, 140, 100, 30);
daAnWenZi1.setBounds(100, 180, 100, 30);
unameWenZi2.setBounds(310, 105, 100, 30);
daAnWenZi2.setBounds(310, 185, 100, 30);
this.add(unameWenZi1);
this.add(wenTiWenZi1);
this.add(daAnWenZi1);
this.add(unameWenZi2);
this.add(daAnWenZi2);
unameWenBenKuang.setBounds(210, 100, 100, 30);
wenTiWenBenKuang.setBounds(210, 140, 100, 30);
wenTiWenBenKuang.setEditable(false);
daAnWenBenKuang.setBounds(210, 180, 100, 30);
this.add(unameWenBenKuang);
this.add(wenTiWenBenKuang);
this.add(daAnWenBenKuang);
queRenAnNiu = new JButton("確認(rèn)且回答正確后跳轉(zhuǎn)重置密碼頁面");
queRenAnNiu.addActionListener(new zhaoHuiMiMaShiJian(this));
quXiaoAnNiu = new JButton("取消");
quXiaoAnNiu.addActionListener(new zhaoHuiMiMaShiJian(this));
queRenAnNiu.setBounds(10, 230, 290, 30);
quXiaoAnNiu.setBounds(340, 230, 70, 30);
this.add(queRenAnNiu);
this.add(quXiaoAnNiu);
this.setVisible(true);
}
}
package denglu;
import java.awt.event.*;
import javax.swing.*;
public class chongZhiMiMa extends JFrame {
static JButton QuRenAnNiu = null;
static JLabel tiShiWenZi1, tiShiWenZi2 = null;
static JPasswordField miMaKuang1, miMaKuang2 = null;
public chongZhiMiMa() {
this.setLayout(null);
this.setTitle("重置密碼頁面");
this.setSize(500, 500);
this.setLocationRelativeTo(null);
this.setVisible(true);
//tiShiWenZi提示文字
tiShiWenZi1 = new JLabel("請輸入密碼");
tiShiWenZi2 = new JLabel("請再次輸入密碼");
tiShiWenZi1.setBounds(100, 100, 100, 30);
this.add(tiShiWenZi1);
tiShiWenZi2 = new JLabel("請再次輸入密碼");
tiShiWenZi2.setBounds(100, 140, 100, 30);
this.add(tiShiWenZi2);
QuRenAnNiu = new JButton("確認(rèn)修改");
QuRenAnNiu.setBounds(100, 290, 150, 30);
this.add(QuRenAnNiu);
QuRenAnNiu.addActionListener(new shijian_queRenXiuGai(this));
miMaKuang1 = new JPasswordField();
miMaKuang2 = new JPasswordField();
miMaKuang1.setBounds(280, 100, 100, 30);
miMaKuang2.setBounds(280, 140, 100, 30);
this.add(miMaKuang1);
this.add(miMaKuang2);
}
}
class shijian_queRenXiuGai implements ActionListener {
static chongZhiMiMa jieShouChuangTi = null;
public shijian_queRenXiuGai(chongZhiMiMa ChuangTi) {
this.jieShouChuangTi = ChuangTi;
}
@Override
public void actionPerformed(ActionEvent arg0) {
if (arg0.getActionCommand().equals("確認(rèn)修改")) {
JOptionPane.showMessageDialog(null, "點擊了修改密碼按鈕");
String pwd1 = jieShouChuangTi.miMaKuang1.getText();
String pwd2 = jieShouChuangTi.miMaKuang2.getText();
if (pwd1.equals(pwd2)) {
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, "出現(xiàn)了未知的錯誤，請重試!");
}
} else {
JOptionPane.showMessageDialog(null, "兩次密碼輸入不一致");
return;
}
}
}
}
