-
Notifications
You must be signed in to change notification settings - Fork 1
/
LoginDel.java
92 lines (69 loc) · 2.32 KB
/
LoginDel.java
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
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
class LoginDel extends JFrame implements ActionListener
{
JInternalFrame iFrameLoginDel = new JInternalFrame("Delete Login Info",true,true,true,true);
Connection con;
Statement stmt;
ResultSet rs;
LayoutManager lm = null;
JTextField LoginDel_Id = new JTextField(10);
JButton Delete = new JButton("Delete");
public LoginDel()
{
}
public JInternalFrame LoginDelFrame(JDesktopPane desktop)
{
iFrameLoginDel.setLayout(lm);
iFrameLoginDel.setLocation(25,25);
iFrameLoginDel.setSize(300,80);
Border border = new CompoundBorder(new BevelBorder(BevelBorder.RAISED),new EtchedBorder(EtchedBorder.RAISED));
iFrameLoginDel.setBorder(border);
JLabel l_LoginDel_Id =new JLabel("User ID :");
l_LoginDel_Id.setBounds(20,15,110,20);
iFrameLoginDel.add(l_LoginDel_Id);
LoginDel_Id.setBounds(120,15,60,20);
iFrameLoginDel.add(LoginDel_Id);
Border border12 = new CompoundBorder(new BevelBorder(BevelBorder.RAISED),new EtchedBorder(EtchedBorder.RAISED));
Delete.setBounds(190,15,100,20);
iFrameLoginDel.add(Delete);
Delete.setBorder(border12);
Delete.addActionListener(this);
desktop.add(iFrameLoginDel);
return(iFrameLoginDel);
//iFrameLoginDel.show();
}
public void actionPerformed(ActionEvent e)
{
String delstr = LoginDel_Id.getText();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:JMS");
//int custstr = Integer.parseInt(delstr);
String query = "DELETE * FROM Login E WHERE E.User = '"+delstr+"'";
System.out.println("Query ="+query);
stmt = con.createStatement();
int result = stmt.executeUpdate ( query );
System.out.println("result = "+result);
if(result==1)
{
JOptionPane.showMessageDialog(this,"The Login Record Deleted");
iFrameLoginDel.setVisible(false);
return;
}
if(result==0)
{
JOptionPane.showMessageDialog(this,"The Login Record Not Found Try Again.");
return;
}
}
catch(Exception ae)
{
ae.printStackTrace();
}
}
}