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
| public String cb1_action() {
String Login = this.it1.getValue() + "";
String Pwd = this.it2.getValue() + "";
try {
Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "stage2013", "grassi");
if (conn != null) {
CallableStatement ps = null;
try {
ps = conn.prepareCall("call valid(?,?,?)");
ps.setString(1, Login);
ps.setString(2, Pwd);
ps.registerOutParameter(3, Types.BOOLEAN);
System.out.println("*******");
ps.executeQuery();
Boolean pp = ps.getBoolean(3);
if (pp)
System.out.println("user_vue : ");
else
System.out.println("faux");
} catch (SQLException ex) {
System.err.println(ex.toString());
}
}
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException sqle) {
sqle.getMessage();
}
return null;
} |
