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;
}
} |
Partager