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
|
/*
* 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 DAO;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.springframework.jdbc.core.JdbcTemplate;
public class LivresDaoImp implements LivresDAO1{
private String driver;
private String url;
private String user;
private String password;
public LivresDaoImp () {
driver="com.mysql.jdbc.Driver";
url="jdbc:mysql://localhost/fst";
user="root";
password="";
}
public void insertLivre(Livres liv) throws Exception{
Class.forName(driver).newInstance();
Connection cnx = DriverManager.getConnection(url, user,
password);
Statement stmt = (Statement) cnx.createStatement();
String q = "insert into livre(cod_liv,auteur,titre,nb_exemp)value('" + liv.getCod_liv() + "','" +
liv.getAuteur() + "','" + liv.getTitre() + "','" + liv.getNb_exemp() + "')";
int update = stmt.executeUpdate(q);
}
public void updateLivre(Livres liv)throws Exception {
Class.forName(driver).newInstance();
Connection cnx = DriverManager.getConnection(url, user,
password);
Statement stmt = (Statement) cnx.createStatement();
String q=" update livre set nb_exemp='"+liv.getNb_exemp()+"', auteur='"+liv.getAuteur()+"',titre='"+liv.getTitre()+"' where cod_livt='"+liv.getCod_liv()+"'";
stmt.executeUpdate(q); int update = stmt.executeUpdate(q);
}
public void deleteLivre(int cod_liv) throws Exception{
Class.forName(driver).newInstance();
Connection cnx = DriverManager.getConnection(url, user,password);
Statement stmt = cnx.createStatement();
String q = " delete from livre where cod_liv='" +cod_liv+ "'";
stmt.executeUpdate(q);
}
public List<Livres> getLivres() throws Exception {
List<Livres> c = new ArrayList<Livres>();
Class.forName(driver).newInstance();
Connection cnx = DriverManager.getConnection(url, user,password);
Statement stmt = (Statement) cnx.createStatement();
String q = "select * from livre ";
ResultSet rs = stmt.executeQuery(q);
while (rs.next()) {
int cod_liv = rs.getInt("cod_liv");
String auteur = rs.getString("auteur");
String titre = rs.getString("titre");
int nb_exemp = rs.getInt("nb_exemp");
System.out.println("cod_liv"+cod_liv+" auteur "+auteur);
c.add(new Livres(cod_liv,auteur, titre, nb_exemp,0));
}
return c ;
}
public boolean TestAdministrateur(String login,String pass)throws Exception{
Class.forName(driver).newInstance();
Connection cnx = DriverManager.getConnection(url, user,password);
Statement stmt = (Statement) cnx.createStatement();
String q = "select * from administrateur";
ResultSet rs = stmt.executeQuery(q);
while (rs.next()) {
if((login.equalsIgnoreCase(rs.getString("Login")))&&(pass.equalsIgnoreCase(rs.getString("Password"))))
return true;
}
return false;
}
} |
