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 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162
| import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
/**
*
* @author EXCELL
*/
public class test0 extends JInternalFrame {
JPanel p=new JPanel();
JTabbedPane tp= new JTabbedPane();
JButton b1=new JButton("Annuler");
JButton b2=new JButton("OK");
JLabel l1=new JLabel("Identifiant");
JLabel l2=new JLabel("Mot de passe");
JPasswordField t2=new JPasswordField();
JTextField t1=new JTextField(" ");
String st1;
String st2;
String url = "jdbc:postgresql://localhost:5432/proj";
String user = "postgres";
String passwd = "cpa";
Connection connect;
Statement st;
boolean maj;
ResultSet rs1;
ResultSet rs2;
String chaineconnection;
String chaineconnection1;
class actionbouton implements ActionListener{
public void actionPerformed(ActionEvent e) {
creerjeu();
}
}
public class ecouteurtf1 extends KeyAdapter {
JTextField jt;
ecouteurtf1(JTextField l) {
jt=l;
}
public void keyReleased(KeyEvent e) {
System.out.println(jt.getText());
st1=jt.getText();
}
}
public class ecouteurtf2 extends KeyAdapter {
JPasswordField jt;
ecouteurtf2(JPasswordField l) {
jt=l;
}
public void keyReleased(KeyEvent e) {
System.out.println(jt.getPassword().toString());
st2=jt.getPassword().toString();
}
}
test0() {
actionbouton act=new actionbouton();
ecouteurtf1 bac1=new ecouteurtf1(t1);
ecouteurtf2 bac2=new ecouteurtf2(t2);
setLayout(null);
b2.setBounds(125,330,85,20);
b1.setBounds(220,330,85,20);
tp.setBounds(15,15,300,300);
setSize(340,395);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
p.setSize(250,200);
p.setLayout(null);
l1.setBounds(40,65,100,20);
t1.setBounds(40,85,120,20);
l2.setBounds(40,105,100,20);
t2.setBounds(40,125,120,20);
p.setBackground(Color.WHITE);
p.add(l1);
p.add(t1);
p.add(t2);
p.add(l2);
b2.addActionListener(act);
t1.addKeyListener(bac1);
t2.addKeyListener(bac2);
tp.addTab("Utilisateur existant",p);
tp.addTab("Nouvel Utilisateur",new JPanel());
getContentPane().add(tp);
getContentPane().add(b2);
getContentPane().add(b1);
setVisible(true);
if (connect == null) {
try {
Class.forName("org.postgresql.Driver").newInstance();}
catch (Exception e) {}
try {
connect = DriverManager.getConnection(url, user, passwd);
st = connect.createStatement();
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, e.getMessage(), "ERREUR DE CONNEXION ! ", JOptionPane.ERROR_MESSAGE);
}
}
}
public void creerjeu() {
maj = true;
try {
chaineconnection = "select id_utilisateur from utilisateur where id_utilisateur =" +st1 ;
chaineconnection1 = "select mot_de_passe from utilisateur where mot_de_passe =" +st2 ;
rs1 = st.executeQuery(chaineconnection);
rs2 = st.executeQuery(chaineconnection1);
if(st1.compareTo(rs1.toString())==1)
{
if(st2.compareTo(rs2.toString())==1)
{
JFrame sam = new JFrame();
sam.setTitle("réussi");
}
}
else{
JFrame erreur=new JFrame();
erreur.setTitle("Erreur");
erreur.setBounds(10,10,300,150);
JLabel alerte = new JLabel("Nom d'utilisateur et/ou mot de passe invalide");
JPanel pano;
pano=new JPanel();
pano.add(alerte);
erreur.getContentPane().add(pano);
erreur.setVisible(true);
}
rs1.close();
rs2.close();
st.close();
}
catch (SQLException e) {
//JOptionPane.showMessageDialog(null, e.getMessage(), "ERREUR DE CONNEXION ! ", JOptionPane.ERROR_MESSAGE);
}
}
public static void main(String[] args) {
test0 tx= new test0();
}
} |
Partager