31bdbe1b
 msahmane
Version où les te...
|
1
2
3
4
5
6
7
8
9
10
11
|
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package fr.plil.sio.persistence.jdbc;
import fr.plil.sio.persistence.api.Right;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
|
|
60e63100
msahmane
Test des Right à ...
|
12
13
|
import java.util.ArrayList;
import java.util.List;
|
|
31bdbe1b
msahmane
Version où les te...
|
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
import javax.sql.DataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
/**
*
* @author msahmane
*/
@Repository
public class RightRepositoryJdbc implements RightRepository {
private static final Logger logger = LoggerFactory.getLogger(GroupRepository.class);
@Autowired
private DataSource dataSource;
@Override
|
|
60e63100
msahmane
Test des Right à ...
|
33
|
public List<Right> findByName(String name) {
|
|
31bdbe1b
msahmane
Version où les te...
|
34
35
|
Statement stmt = null;
ResultSet rs = null;
|
|
60e63100
msahmane
Test des Right à ...
|
36
|
List<Right> list = new ArrayList<>();
|
|
31bdbe1b
msahmane
Version où les te...
|
37
38
39
40
41
42
43
44
|
try {
stmt = dataSource.getConnection().createStatement();
rs = stmt.executeQuery("SELECT * FROM RIGHT_T WHERE NAME_R = \'" + name + "\'");
if (rs.next()) {
logger.debug("found group " + name);
Right right = new Right();
right.setId(rs.getLong("RIGHT_ID"));
right.setName(rs.getString("NAME_R"));
|
|
60e63100
msahmane
Test des Right à ...
|
45
46
|
list.add(right);
return list;
|
|
31bdbe1b
msahmane
Version où les te...
|
47
48
|
} else {
logger.debug("not found " + name);
|
|
60e63100
msahmane
Test des Right à ...
|
49
|
return list;
|
|
31bdbe1b
msahmane
Version où les te...
|
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
|
}
} catch (SQLException e) {
throw new UnsupportedOperationException("sql exception", e);
} finally {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
throw new UnsupportedOperationException("sql exception during close", e);
}
}
}
@Override
public void save(Right right) {
Statement stmt = null;
ResultSet rs = null;
try {
stmt = dataSource.getConnection().createStatement();
stmt.executeUpdate("INSERT INTO RIGHT_T (NAME_R) VALUES (\'" + right.getName() + "\')",
Statement.RETURN_GENERATED_KEYS);
rs = stmt.getGeneratedKeys();
if (rs.next()) {
right.setId(rs.getLong(1));
} else {
throw new UnsupportedOperationException("default in key access");
}
} catch (SQLException e) {
throw new UnsupportedOperationException("sql exception", e);
} finally {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
throw new UnsupportedOperationException("sql exception during close", e);
}
}
}
@Override
public void delete(Long id) {
Statement stmt = null;
ResultSet rs = null;
try {
stmt = dataSource.getConnection().createStatement();
stmt.executeUpdate("DELETE FROM RIGHT_T WHERE RIGHT_ID="+id,
Statement.RETURN_GENERATED_KEYS);
rs = stmt.getGeneratedKeys();
} catch (SQLException e) {
throw new UnsupportedOperationException("sql exception", e);
} finally {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
throw new UnsupportedOperationException("sql exception during close", e);
}
}
}
|
|
60e63100
msahmane
Test des Right à ...
|
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
|
@Override
public Right findOne(Long id){
Statement stmt = null;
ResultSet rs = null;
try{
stmt = dataSource.getConnection().createStatement();
rs = stmt.executeQuery("SELECT * FROM RIGHT_T WHERE RIGHT_ID = "+id);
if (rs.next()) {
Right right = new Right();
right.setId(rs.getLong("RIGHT_ID"));
right.setName(rs.getString("NAME_R"));
return right;
}
return null;
}catch(SQLException e){
throw new UnsupportedOperationException("sql exception", e);
}finally{
try{
if(rs !=null){
rs.close();
}
if(stmt != null){
stmt.close();
}
}catch(SQLException e){
throw new UnsupportedOperationException("sql exception during close", e);
}
}
}
|
|
31bdbe1b
msahmane
Version où les te...
|
156
|
}
|