LibraryManagementSystem/ChangePass.java at master · simran045/LibraryManagementSystem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class ChangePass extends JFrame implements ActionListener
{
    JLabel l1, l2, l3,l4;
    JTextField tf1,tf2;
    JButton btn1;
    JPasswordField p1;

    ChangePass()
    {
        setTitle("Login Form in Windows Form");
        setVisible(true);
        setSize(800, 800);
        setLayout(null);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        l1 = new JLabel("Login Form in Windows Form:");
        l1.setForeground(Color.blue);
        l1.setFont(new Font("Serif", Font.BOLD, 20));

        l2 = new JLabel("Enter Name:");
        l3 = new JLabel("Enter Email:");
		l4 = new JLabel("Enter Password:");
        tf1 = new JTextField();
		tf2 = new JTextField();
        p1 = new JPasswordField();
        btn1 = new JButton("Submit");

        l1.setBounds(100, 30, 400, 30);
        l2.setBounds(80, 70, 200, 30);
        l3.setBounds(80, 110, 200, 30);
        tf1.setBounds(300, 70, 200, 30);
		tf2.setBounds(300, 110, 200, 30);
		l4.setBounds(80, 110, 200, 30);
        p1.setBounds(300, 200, 200, 30);
        btn1.setBounds(150, 160, 100, 30);

        add(l1);
        add(l2);
        add(tf1);
        add(l3);
		add(tf2);
		add(l4);
        add(p1);
        add(btn1);
        btn1.addActionListener(this);
    }

    public void actionPerformed(ActionEvent e)
    {
        showData();
    }

    public void showData()
    {
        JFrame f1 = new JFrame();
        JLabel l, l0;

        String str1 = tf1.getText();
		String str2 = tf2.getText();
        char[] p = p1.getPassword();
        String str3 = new String(p);
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("Jdbc:Odbc:mydsn","","");
            PreparedStatement ps = con.prepareStatement("select lname,lid,lpass from lib_login where lname=?  and lid=? and lpass=?");
            ps.setString(1, str1);
            ps.setString(2, str2);
			ps.setString(3, str3);
            ResultSet rs = ps.executeQuery();
            if (rs.next())
            {
                f1.setVisible(true);
                f1.setSize(600, 600);
                f1.setLayout(null);
                l = new JLabel();
                l0 = new JLabel("you are succefully logged in..");
                l0.setForeground(Color.blue);
                l0.setFont(new Font("Serif", Font.BOLD, 30));
                l.setBounds(60, 50, 400, 30);
                l0.setBounds(60, 100, 400, 40);

                f1.add(l);
                f1.add(l0);
                l.setText("Welcome " + rs.getString(1)+" "+ rs.getString(2));
                l.setForeground(Color.red);
                l.setFont(new Font("Serif", Font.BOLD, 30));

            } else
            {
                JOptionPane.showMessageDialog(null,
                   "Incorrect email-Id or password..Try Again with correct detail");
            }
        }

		catch(SQLException e){JOptionPane.showMessageDialog(null,e);}
		catch(ClassNotFoundException e){JOptionPane.showMessageDialog(null,e);}
    }

    public static void main(String arr[])
    {
        new ChangePass();
    }
}