JDBC：找回员工密码

Function：

• 设计一个找回员工密码的界面(FindPasswordFrame)，
• 在三个文本框中分别输入员工帐号、密码保护问题和密码保护答案
• 如果输入全部正确，单击“找回密码”按钮，则在一个JLabel中显示员工密码。

UI类

/** * 设计一个找回员工密码的界面(FindPasswordFrame)， * 在三个文本框中分别输入员工帐号、密码保护问题和密码保护答案 * 如果输入全部正确，单击“找回密码”按钮，则在一个JLabel中显示员工密码。 */package com.Test.view;import java.awt.Component;import java.awt.Container;import java.awt.FlowLayout;import java.util.List;import java.awt.event.*;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.Toolkit;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.util.ArrayList;import java.util.Vector;import javax.swing.BorderFactory;import javax.swing.ComboBoxModel;import javax.swing.JButton;import javax.swing.JComboBox;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JTextField;import javax.swing.plaf.basic.BasicButtonListener;import javax.swing.plaf.basic.BasicOptionPaneUI.ButtonActionListener;import com.Test.dao.UsernameDAO;import com.Test.dto.UsernameDTO;public class UsernameDisplay extends JFrame{    private JLabel accountJlb,questionJlb,answerJlb,displayJlb;    private JTextField tf1,tf2,tf3;    private JButton findBtn;    //构造方法    public UsernameDisplay() {        this.setLayout(null);        Container c = this.getContentPane();        accountJlb = new JLabel("员工帐号:");        accountJlb.setBounds(80,30,70,30);        c.add(accountJlb);        tf1 = new JTextField();        tf1.setBounds(190,30,190,30);        tf1.setBorder(BorderFactory.createLoweredBevelBorder());        c.add(tf1);        questionJlb = new JLabel("密码保护问题:");        questionJlb.setBounds(80,50,100,90);        c.add(questionJlb);        tf2 = new JTextField();        tf2.setBounds(190,80,190,30);        tf2.setBorder(BorderFactory.createLoweredBevelBorder());        c.add(tf2);        answerJlb = new JLabel("密码保护答案:");        answerJlb.setBounds(80,100,100,90);        c.add(answerJlb);        tf3 = new JTextField();        tf3.setBounds(190,130,190,30);        tf3.setBorder(BorderFactory.createLoweredBevelBorder());        c.add(tf3);        findBtn = new JButton("找回密码");        findBtn.setBounds(140,190,90,30);        c.add(findBtn);        displayJlb = new JLabel();        displayJlb.setBounds(250,190,90,30);        c.add(displayJlb);//不能添加到下面        //FindPassword        findBtn.addActionListener(new ActionListener()          {           public void actionPerformed(ActionEvent e)           {             //获取输入              String userID = tf1.getText().trim();              String pw =  tf2.getText().trim();                String pw1 =  tf3.getText().trim();               //String empPassword = null;              JButton tempButton=(JButton)e.getSource();            if(tempButton==findBtn) //按下找回密码按钮后判断输入            {                if(userID.equals(""))                {                    JOptionPane.showMessageDialog(null,"账号不能为空！","错误提示",JOptionPane.ERROR_MESSAGE);                 }                else if(pw.equals(""))                {                    JOptionPane.showMessageDialog(null,"密码保护问题不能为空!","错误提示",JOptionPane.ERROR_MESSAGE);                          }                else if(pw1.equals(""))                {                    JOptionPane.showMessageDialog(null,"密码保护答案不能为空!","错误提示",JOptionPane.ERROR_MESSAGE);                          }                else                {                   UsernameDAO userdao = new UsernameDAO();                   UsernameDTO result = new UsernameDTO();                   result = userdao.findPass(userID, pw, pw1);                   if(result!=null) {    //确认输入账号 密保和答案正确                       displayJlb.setText(result.getEmpPassword());                      //JOptionPane.showMessageDialog(null,"密码是： " + result.getEmpPassword());                       //System.out.println(result.getEmpPassword());                   }                   else {                       JOptionPane.showMessageDialog(null, "账号或密保或密保答案有误！");                   }                }            }          }});         this.setTitle("FindPassword");        this.setSize(500,300);        this.setLocationRelativeTo(null);        int w = Toolkit.getDefaultToolkit().getScreenSize().width;        int h = Toolkit.getDefaultToolkit().getScreenSize().height;        this.setLocation(w/2-250, h/2-180);        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);        this.setVisible(true);    }    public static void main(String[] args) {            new UsernameDisplay();    }}

DAO类

/** * 千枝竞秀有天皆丽日，万木争荣无地不春风 * Author: RoniZeng * Time：     17/12/25 */package com.Test.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import com.Test.Util.DBUtil;import com.Test.dto.UsernameDTO;public class UsernameDAO {    private UsernameDTO userdto;    /**     * 显示密码select     * @param empPassword     * @return String     */    public UsernameDTO findPass(String account, String question,String answer){        Connection conn = null;        PreparedStatement statement = null;        ResultSet rs = null;        try{            conn = DBUtil.getConnection();            String sql = "select * from Employee where empAccount=? and empQuestion=? and empAnswer=?";            statement = conn.prepareStatement(sql);            statement.setString(1, account);            statement.setString(2, question);            statement.setString(3, answer);            rs = statement.executeQuery();            UsernameDTO userdto =null;            if(rs.next()) {                userdto = new UsernameDTO();                String password = rs.getString("empPassword");                userdto.setEmpPassword(password);            }        return userdto;        }        catch(Exception e){            e.printStackTrace();        }        finally{            try{                rs.close();                statement.close();                conn.close();            }            catch(Exception e1){                e1.printStackTrace();            }        }        return userdto;    }}

DTO类

package com.Test.dto;public class UsernameDTO {    private String empPassword;    public String getEmpPassword() {        return empPassword;    }    public void setEmpPassword(String empPassword) {        this.empPassword = empPassword;    }}

DBUtil类（工具类）

package com.Test.Util;import java.sql.Connection;import java.sql.DriverManager;public class DBUtil {    public static Connection getConnection(){        try{            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");            Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=HappyDB;user=sa;password=123456");            return conn;        }        catch (Exception e) {        }        return null;    }}

MyQuestion

1. 单击“找回密码”按钮，无论三个框输入什么，都弹出“账号或密保或密保答案有误！”
2. 不知道怎么在一个JLabel中显示员工密码