Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.ObjectInputStream.GetField;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.ArrayList;
- import java.util.List;
- public class PruebasJDBC {
- public static void main(String[] args) {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- Connection cx = null;
- Libro l = new Libro(0,"El resplandor","Stephen King","El Susto",600,Seccion.TERROR,null);
- try {
- cx = DriverManager.getConnection("jdbc:mysql://localhost:3306/biblioteca","root","root");
- Statement st = cx.createStatement();
- st.executeUpdate("INSERT INTO libro " +
- "(TITULO,AUTOR,EDITORIAL,NUMERO_DE_PAGINAS,SECCION) " +
- "VALUES " +
- "('"+l.getTitulo()+"','"+l.getAutor()+"','"+l.getEditorial()+"',"+l.getNumeroDePaginas()+",'"+l.getSeccion()+"')");
- // PREPARED STATEMENT (FETEN)
- Libro l2 = new Libro(1,"El Resplandor","Stephen King, el loco","El Demon",655,Seccion.INFANTIL,null);
- PreparedStatement pst = cx.prepareStatement("UPDATE libro SET TITULO=? ,AUTOR=? ,NUMERO_DE_PAGINAS=? " +"WHERE ID_LIBRO= ? ");
- pst.setString(1, l2.getTitulo());
- pst.setString(2, l2.getAutor());
- pst.setInt(3,l2.getNumeroDePaginas());
- pst.setInt(4,l2.getIdLibro());
- pst.executeUpdate();
- //DELETE FROM libro WHERE ID_LIBRO=?
- //SELECT
- List<Libro> libros = new ArrayList<Libro>();
- PreparedStatement pst2 = cx.prepareStatement("SELECT * FROM libro");
- ResultSet rs=pst2.executeQuery();//informacion en bruto que me devuelve la BD, matriz con filas y columnas
- while(rs.next())
- {
- Libro lAux = new Libro(rs.getInt("ID_LIBRO"), rs.getString("TITULO"), rs.getString("AUTOR"), rs.getString("EDITORIAL"), rs.getInt("NUMERO_DE_PAGINAS"), Seccion.valueOf(rs.getString("SECCION")), null);
- libros.add(lAux);
- }
- System.out.println("==============");
- for(Libro laux: libros)
- {
- System.out.println(laux);
- }
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- } finally {
- try {
- cx.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- //Class.forName("com.mysql.jdbc.Driver");
- }
- }
Add Comment
Please, Sign In to add comment